SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2005 Forums
 Other SQL Server Topics (2005)
 Version Connection Error (SQL2000 to SQL2005)
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

andre.ceccarelli
Starting Member

2 Posts

Posted - 03/23/2012 :  11:14:54  Show Profile  Reply with Quote
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 - 04/04/2012 :  10:11:44  Show Profile  Reply with Quote
The conflict was resolved: connection manager changed to SQLOLEDB and DLL SQLNCLI10.dll registered.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000