IntroductionThis article explains how to connect to Microsoft SQL Server with ODBC from Windows 10. Show
It covers the following topics:
Connect to Microsoft SQL Server [top]We strongly recommend using connection objects to connect to databases, and this is what we demonstrate in the code samples. Follow these steps to connect:
Setup ODBC [top]Note: Iguana may not always support the very latest version of the Microsoft SQL Server ODBC drivers, so you can simply download an earlier version if necessary. This is particularly true if you are not able to use the the latest version of Iguana. If you need to know which versions of Microsoft SQL Server are supported by the version of Iguana you are using please contact us at . To set up a new ODBC data source for Microsoft SQL Server:
If you need to modify the ODBC source follow these steps:
Troubleshooting [top]
If you need more help please contact us at . More Information [top]
How do I create a System DSN for Microsoft SQL Server?Article Body. Create an empty database in SQL Server.. Choose Start > Control Panel > System and Security.. Click Administrative Tools.. Double-click Data Sources (ODBC). ... . Click the System DSN tab and then click Add. ... . Select the SQL Server driver and click Finish. ... . Enter a unique Name.. How do I create a DSN file in Windows 10?From Windows:. In Control Panel go to Administrative Tools > Data Sources ODBC (exact name differs based on version of SQL Server). Select File DSN tab.. Click Add.. Select SQL Native Client if your ODBC source relies on this DB engine. ... . Name the file data source.. How do I find the SQL Server DSN?Information. Open the library.. Right click in the library and choose Properties.. In the "Data Source" tab, review the "Primary data source" field to see which DSN is being used. ... . Choose Start (> Settings, on Windows XP or Windows 10) > Control Panel > Administrative Tools > Data Sources (ODBC). How do I find my DSN on Windows 10?Click the Windows "Start" button and then click "Control Panel." Click "System and Security." Click "Administrative Tools" in the list of utilities. Double-click the icon labeled "Data Sources (ODBC)." A list of DSNs display.
How do I create an ODBC connection for SQL Server in Windows 10?Get the connection string with an app. Search for or browse to the ODBC Data Sources (64-bit) applet in the Start Menu or Control Panel. ... . Launch the applet. ... . Now go to the File DSN tab of the applet. ... . In the Create New Data Source dialog box, select your driver in the list, and then click Next.. What is SQL DSN?A data source name (DSN) is a data structure that contains the information about a specific database that an Open Database Connectivity ( ODBC ) driver needs in order to connect to it.
|