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 |
|
andre.ceccarelli
Starting Member
2 Posts |
 Posted - 2012-03-23 : 11:14:54
|
| I’ve developed a program in VB6 (.exe) that access a database on a server with SQL2000 installed. In this case, any computer access the database normally.I’ve changed the program to access another server, this with SQL2005 installed. I’ve replicated the database from the old server (SQL2000) to the new server (SQL2005). But when the program try to establish connection with the new server, gives me the following message: "Encryption not supported on the client." This message appears only on computers that do not have SQL 2005 installed. If the program is installed, the connection is established normally.The change in the program (VB6) was:SQL 2000: CN = "UID = uid; PWD = pw; Driver = {SQL Server}; Server = ip; Database = Database;"TO SQL 2005: CN = "Provider = SQLNCLI; Server = 10188744166; Database = Database, uid = Uid, Pwd = pw"What could be the conflict? |
|
|
andre.ceccarelli
Starting Member
2 Posts |
Posted - 2012-04-04 : 10:11:44
|
| The conflict was resolved: connection manager changed to SQLOLEDB and DLL SQLNCLI10.dll registered. |
 |
|
|
|
|
|
Version Connection Error (SQL2000 to SQL2005)