User Login: Change to user billsmith with password something-secret.These are the two most common things to change:.If you need to modify the ODBC source follow these steps: If it does not work speak to your DBA about how to login to the database (user authentication).Database: You can specify the database that you want to use by default.Use Integrated Security: Sometimes you might want to use a SQL Server user and password.Speak to your DBA (database administrator) about changing these if necessary. There are two settings that you may need to change: Use Integrated Security and Database. The ODBC source will use all the standard defaults which will work in most cases. This will open the the ODBC Microsoft SQL Server Setup dialog box that lists the chosen settings:.Click Finish to create the ODBC data source:.Note: If you are unsure of the name ask your DBA (database administrator). Enter the Network Name of the SQL Server in the Server field:.Use any Name and Description you prefer.Choose the latest SQL Server ODBC driver and click Finish:.Right Click and choose Run as Administrator:.Search for ODBC and choose ODBC Data Sources (64 bit):.Windows 10 (64 bit version) supports 32 and 64 bit ODBC sources - always use the 64 bit ODBC Administrator. Run the installer and accept the defaults.Download the latest drivers from the Microsoft ODBC download site.Install the latest Microsoft SQL Server ODBC drivers:.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 set up a new ODBC data source for Microsoft SQL Server: This is particularly true if you are not able to use the the latest version of Iguana. 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. The name is the name of an ODBC source that you create using the ODBC Administrator.If your script uses connection object methods conn:query Your channel will need a From/To Translator or a Filter component. Name: DB SQL Server Connection (or similar).Create a new channel to try out the code:.We strongly recommend using connection objects to connect to databases, and this is what we demonstrate in the code samples.

We recommend using system DSNs (available to all users). Configure ODBC using the ODBC Data Source Administrator:.How to connect to Microsoft SQL Server (with code samples).This article explains how to connect to Microsoft SQL Server with ODBC from Windows 10.

Odbc driver for sql server 17