pasterfan.blogg.se

• #Microsoft sql server client 64 bit windows 8 how to

Any idea why user DSN does n't work in 64- it system. Recently we are doing migration from windows 2003 server to windows 2008 server (32- bit to 64- bit).Īfter installing application in new server, it is not pinging the DB, faced problem in ODBC connection.Could you explain me why we need to create this system DSN? We were using User DSN in 32- bit system but it didn't work now. As you may have noticed, the real trick is running the 32-bit version of the ODBC Data Source Administrator.Document the DSN details for the application connectivity.

Select the desired application database from drop down list and click Next.Ĭlick on Finish and test the data source connectivity. For SQL authentication, specify the SQL login name and password. Select the authentication mode as per the requirement. Specify the data source name, description and the SQL Server instance name. Select the SQL Server Native Client 10.0 from the list and click on the Finish button. Select the System DSN tab and click on the Add. Open C:\WINDOWS\SYSWOW64\odbc32.exe or type %systemdrive%\Windows\SysWoW64\Odbcad32.exe in the Run window. On the 64-bit machine where the application is installed, open the Microsoft Windows ODBC Data Source Administrator using one of the methods shown below. īelow are the steps to create a 32-bit DSN on a 64-bit machine.

You can install the SQL Server native client either from the SQL Server media or by downloading it from. Solutionīefore creating the DSN make sure the SQL Server Native client component is installed on the machine.

#Microsoft sql server client 64 bit windows 8 how to

In this tip, we cover how to create a 32-bit DSN on 64-bit machine. Create a 32-bit DSN on 64-bit machine for SQL Serverīy: Jugal Shah | Updated: | Comments (9) | Related: More > SQL Server Configurationsĭuring the install of an application on a 64-bit Windows machine, the application was unable to list the ODBC System DSN because it had been setup as a 64-bit DSN and the application needed a 32-bit system DSN for connectivity to SQL Server.