Solved Vb6 And Sql2008 Connection Issues Experts Exchange Find answers to vb6 and sql2008 connection issues from the expert community at experts exchange. I have old application, written on vb6. after migrating it from windows 7 to windows 10, the application cannot connect to the old sql server. in sql server logs: login failed for user ' '. reason: password did not match that for the login….
Solved Data Control Connection To Sql In Vb6 Experts Exchange I'm moving a vb6 app that has been used with sql 2000 to sql 2008. it connect, is functional, but very slow. things that would take less than a second take a minute. I had to migrate recently a vb6 with dao application from sql7 to sql 2016, and the process was almost straight forward. i didn't change anything in code, except old sql syntax that is obsolete now. As you aren't aware of it, i presume you are (automatically) using your windows login details in which case you should add " trusted connection=yes; " to the connection string, so that your program will do the same. When i am trying to connect to other tables using the same connection, which have just 100 rows, i am not getting this error and i am able to fetch all the data with no problem.
Solved Data Control Connection To Sql In Vb6 Experts Exchange As you aren't aware of it, i presume you are (automatically) using your windows login details in which case you should add " trusted connection=yes; " to the connection string, so that your program will do the same. When i am trying to connect to other tables using the same connection, which have just 100 rows, i am not getting this error and i am able to fetch all the data with no problem. This has gone mostly smoothly. the local machines running win xp and the vb6 application are working. one machine (only one i can get to directly) runs win server 2003 and it works ok. however, the workstations at the remote location are running the vb6 app on windows 2000. those do not work. Here is a string i use in one of my projects which connects to sql server, tested with sql server 6.5 2008 using ado. i have used both of these in several projects and never had an issue. i would recommend the top one as it does not require you to create a dsn. I need a connection string between an old but necessary vb6 (current service pack) program and sql server 2008 r2. since the vb6 program will not run on w7, it runs on an xp box, sql server is running on a windows 7 x86 box. I have an application that intermittently has a break in the connection between it and the sql server instance it requires to function. what is a good way to go about troubleshooting this type of problem.
Solved Sql 2000 On Windows 2003 Standard Edition Connection Error This has gone mostly smoothly. the local machines running win xp and the vb6 application are working. one machine (only one i can get to directly) runs win server 2003 and it works ok. however, the workstations at the remote location are running the vb6 app on windows 2000. those do not work. Here is a string i use in one of my projects which connects to sql server, tested with sql server 6.5 2008 using ado. i have used both of these in several projects and never had an issue. i would recommend the top one as it does not require you to create a dsn. I need a connection string between an old but necessary vb6 (current service pack) program and sql server 2008 r2. since the vb6 program will not run on w7, it runs on an xp box, sql server is running on a windows 7 x86 box. I have an application that intermittently has a break in the connection between it and the sql server instance it requires to function. what is a good way to go about troubleshooting this type of problem.
Comments are closed.