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