By eblissbull ·
Am trying to become developer,
I have an sql 2005 standard edition database and I am developing a VB 6.0 front-end application that needs to be adding and deleting records to the this database. can you help with the connection type to use and a suggested connection string.

thanks so much

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Collapse -


by Tony Hopkinson In reply to DATABASE CONNECTIVITY

It you are using integrated security (the default).

The connection string would be "data source=MyServerName; initial catalog=MyDatabaseName;Integrated Security=SSPI;

If you but a an ADOConnection on a form, you can use build to create the connection string
and then copy it.

P.S. Why VB6, it's sadly out of date. You'd be better of getting C# or VB.Net. Visual studio express is free from MS.

Related Discussions

Related Forums