Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 vb 6.0 sql server connectivity

Author  Topic 

mk_garg20
Constraint Violating Yak Guru

343 Posts

Posted - 2004-10-10 : 21:16:54
Hi All,
Can you provide me some links for developing application wih vb 6.0 and sql server.

Thanks

mk_garg

tuenty
Constraint Violating Yak Guru

278 Posts

Posted - 2004-10-11 : 11:43:20
use ADO 2.5 in your project references

and look for help within the MSDN (it comes with VB but you can also search online) for connection, recordset, command etc.



I have a good book but it is not for learning but to improve the applications Effective VB How to Improve your VB/COM + Applications(5 authors)

some tips it mentions are:

*Allways create ADO objects locally except for a string where you can store the connectionString

*Don't worry so much for style, worry about response time

*Do not implement the object oriented style to data

*Allways use stored procedures (If you have a transaction that
involves three tables make that transaction with one call to one SP)

I don't know the sites but there are some forums like this one for VB


*.*.*.*.*.*.*.*.*.*.*.*.*.*.*.*.*.*.*.*.*.*.*.*.*

A candle loses nothing by lighting another candle
Go to Top of Page
   

- Advertisement -