SQL Server 7.0 Connection String

[JDPurtell]

Currently I have the below line using the sa password with no password.

Const MAL_Driver = "Provider=sqloledb;Data Source=usmbcusmwpweb01;Initial Catalog=MAL;User Id=sa;Password=; "

Does any one know if I can use NT authetication for this connection?

 

[chiph]

We're using NT authentication (via Active Directory) and all we do is:

Provider=SQLOLEDB;UID=vvvv;PWD=xxxx;DATABASE=yyyy;SERVER=zzzz

The user is created in Active Directory with very few operating system privledges (can't log in, can't dial-in, etc), but we do set up the SQL2000 privledges via Enterprise Manager so they can work in their database and query/update their tables.

Hope this helps.
Chip H.

 

[peairs01]

In Windows right click on your desktop and go to new Microsoft Data Link

In NT find the Create New Microsoft Data Link tool
it may be in the system or winnt folder.
use the wizard to setup and test your connection
once you connect successfully.
save this connection to a file
open this file in notepad and
then copy the connection string into your code.
quick and easy way to get your connection string.