Hi,
How can I easily covert our sql server application to sql server localDB application without much changes. We basically use uniCOnnection all over the place to connect to SQL Server. Now we want to use same application on laptop using LocalDB . Also is there any easy way to convert SQL Server Db to LocalDB?
Please advice.
Thank You.
SQL Server Express LocalDB
Re: SQL Server Express LocalDB
Hi,
To connect to SQL Server LocalDB using UniDAC, you should use SQL Native Client provider. For this, in the connection options, set TUniConnection.SpecificOptions.Values['OLEDBProvider'] := 'prNativeClient'.
In addition, you should use Windows Authentication in a SQL Server LocalDB connection. For this, set the TUniConnection.SpecificOptions.Values['Authentication'] option to 'auWindows'.
To connect to SQL Server LocalDB using UniDAC, you should use SQL Native Client provider. For this, in the connection options, set TUniConnection.SpecificOptions.Values['OLEDBProvider'] := 'prNativeClient'.
In addition, you should use Windows Authentication in a SQL Server LocalDB connection. For this, set the TUniConnection.SpecificOptions.Values['Authentication'] option to 'auWindows'.