Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
SQL Server 7.0 Connection String
- Thread starter JDPurtell
- Start date
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.
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.
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.
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.
- Status
Similar threads
