Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
texas1992
Starting Member
21 Posts |
 Posted - 2012-08-02 : 11:11:37
|
| I have been given the task of connecting an old application written in VB6.0, installed on a Win7 machine, to a SQL 2000 server. The Native SQL 10.0 driver has been installed on the win7 machine.I need to connect via a DSNless connection. I have not done this in a long time so I need some help. Here is the current connection string:OpenConnection("Export", dbDriverNoPrompt, True, "ODBC;DRIVER=SQL Server;SERVER=<server>;DATABASE=<database>;UID=<user>;PWD=<password>;DSN=''")Thanks. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
texas1992
Starting Member
21 Posts |
Posted - 2012-08-02 : 11:41:14
|
| Thanks for your reply.I made the change, DRIVER=SQLNCLI10, but still can not connect. According to the link you gave me this change should work. Do you have any suggestions?So far, the application works until I get to the point where I am trying to connect to the database. |
 |
|
|
texas1992
Starting Member
21 Posts |
Posted - 2012-08-13 : 10:50:02
|
| I am still having trouble connecting to the database. I have converted the application to the .NET platform but still can not connect.Any help would be appreciated.Thanks. |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2012-08-13 : 11:17:26
|
| Are you getting an error message? Are you sure the server is available? User and password correct? |
|
|
|
|
|
|
Connecting to SQL 2000