Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Ado connectivity to sql server
Message
From
25/03/2004 08:55:16
 
 
To
23/03/2004 07:42:25
Raoshan Kumar
Softinfo Systems Pvt. Ltd.
New Delhi, India
General information
Forum:
Visual Basic
Category:
Database DAO/RDO/ODBC/ADO
Miscellaneous
Thread ID:
00888799
Message ID:
00889561
Views:
17
This message has been marked as the solution to the initial question of the thread.
every database have to have user associated with it to access it.
You should create a login and assign it the access to the database. Otherwise you can use windows integrated security Or you can provide login and password of user "sa" in the connection string.

If you are able to access the database through your windows account then following would make the connection.
1. create a system DSN on your machine lets say "appDSN".
2. on next tab of dsn creation choose authentication as windows NT authentication and follow the next tabs and instructions(dont forget to choose the database).
3. In your code provide a connection string as "DSN=appDSN"

you should get the connection
Best Luck..
Nilesh
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform