Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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
share|improve this question
    
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

1 Answer 1

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

share|improve this answer
    
Worth noting that OLE DB is being depreciated. msdn.microsoft.com/en-us/library/hh967418.aspx –  Shawn Melton Feb 1 at 3:26

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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