Question

Locked

DATABASE CONNECTIVITY

By eblissbull ·
hi,
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.

2 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Answers

Collapse -

ADOConnection

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.

Back to Software Forum
2 total posts (Page 1 of 1)  

Related Discussions

Related Forums