![]() 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. In this tip, we cover how to create a 32-bit DSN on 64-bit machine. ![]() By: 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.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |