-1

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:

[oledb]
Provider=SQLOLEDB.1;Password=XXX;Persist Security Info=True;User ID=XXX;
Initial Catalog=SQL2000DB;Data Source=SERVERNAME
6
  • It might be helpful to see the actual connection string. I would think it should work unmodified.
    – Hannah Vernon
    Dec 11, 2013 at 21:00
  • Try to show here: connectionstrings.com
    – Joe Taras
    Dec 11, 2013 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, 2013 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.
    – Hannah Vernon
    Dec 11, 2013 at 21:38
  • The OleDB provider should work; however it doesn't give you access to certain features such as failover mirroring, etc.
    – Hannah Vernon
    Dec 11, 2013 at 21:39

1 Answer 1

2

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

1

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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