SQL and VB

[ctxbsw]

Could anyone direct me to any resources, or give a bit of explanation about what is involved in connecting from vb6 to an sql server..... i can connect to an access file quite easily and manipulate data but how do you connect to a database on a server???

[paulw]

Pretty much the same way - use ADO and OLE DB as you would for Access. The main difference is that you don't always have the same properties available. Good books abound, but I've got Hithhikers guide to VB and SQL Server by William Vaughan. Might be a little heavy for what you want, but go and browse it - it will give you some ideas.

Cheers,

P.