Currently I have an application in Visual Basic 6.

This application connects to a SQL Server 2000 server using a Data Link file (.UDL) through the OLE DB provider for SQL. The server will be migrated to SQL Server 2012.

Will the connection string that is currently used work for SQL Server 2012?

The connection string is something like:

Provider=SQLOLEDB.1;Password=XXX;Persist Security Info=True;User ID=XXX;
Initial Catalog=SQL2000DB;Data Source=SERVERNAME
  • It might be helpful to see the actual connection string. I would think it should work unmodified. – Max Vernon Dec 11 '13 at 21:00
  • Try to show here: connectionstrings.com – Joe Taras Dec 11 '13 at 21:33
  • My doubt arises with the use of SQLNCLI11 since my connection use SQLOLEDB.1. I understand that SQL 2012 native mode use SQLNCLI11. – James Dec 11 '13 at 21:38
  • It looks like this connection string should work. Having said that, I would certainly test it by installing SQL Server 2012 on a test server, and attempting to connect to it using the VB6 app. – Max Vernon Dec 11 '13 at 21:38
  • The OleDB provider should work; however it doesn't give you access to certain features such as failover mirroring, etc. – Max Vernon Dec 11 '13 at 21:39

As already stated, it should keep working. You should, if possible, test this using a development server running SQL Server 2012.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.