Showing posts with label located. Show all posts
Showing posts with label located. Show all posts

Wednesday, March 21, 2012

ODBC connection

I am trying to connect to SQL Server using a 3rd party report generating software (dbextra). Everything is located on my local box. I am trying to establish connection through ODBC. Is this installed during setup or is this a function I have to manually set up and configure?

ODBC connections are defined in the "Data Sources (ODBC)" option in the system's "Administrative Tools". You have to set these up manually. Once done, you point the software to the "name" of the ODBC data source you've created.

-Ryan / Kardax

|||

You can connect using ODBC right out of the box through two different paths:

MDAC is already on your Windows computers, you write a normal ODBC connection string for SQL. This typcially uses TCP/IP, so you will need to enable the TCP/IP protocol in SQL Server (it's off by default) using SQL Configuration Manager.