Using an ODBC connection within TSQL 
Author Message
 Using an ODBC connection within TSQL

I am trying to use an ODBC connection to a system that allows TSQL commands.  I have the ODBC connection established and working.  I now am wanting to establish what I believe to be a "linkedserver" connection to use commands directly from my query window to connect through the ODBC connection to access the other server.  I do not understand exactly what I need to accomplish this though.

I have the following that is available and necessary.

System DSN:  Defined
System Data Source Name:  CONNEX32
System Data Source Driver:  CONNX32
User Name for logon:  logonname
User Password for logon:  logonpassword

Thanks
Duane

*** Sent via Developersdex http://www.***.com/ ***
Don't just participate in USENET...get rewarded for it!



Wed, 20 Aug 2003 03:26:45 GMT
 Using an ODBC connection within TSQL

Try using a OLE DB connection.  You cannot use a ODBC connection within TSQL
to do this.  The best method to do what your looking to do is to use linked
servers (assuming your using SQL 7.0 or higher).  Refer to BOL for these two
methods of queries.  If you need specific help, repost.

HTH


I am trying to use an ODBC connection to a system that allows TSQL commands.
I have the ODBC connection established and working.  I now am wanting to
establish what I believe to be a "linkedserver" connection to use commands
directly from my query window to connect through the ODBC connection to
access the other server.  I do not understand exactly what I need to
accomplish this though.

I have the following that is available and necessary.

System DSN:  Defined
System Data Source Name:  CONNEX32
System Data Source Driver:  CONNX32
User Name for logon:  logonname
User Password for logon:  logonpassword

Thanks
Duane

*** Sent via Developersdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!



Fri, 22 Aug 2003 23:38:07 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Connection ID within TSQL

2. Possible to connect to ODBC within TSQL?

3. TSQL Connection via ODBC to remote MSSQL Server

4. Creating a connection with ODBC and Enterprise manager threw TSQL

5. Clearing All Active Connections to a database using TSQL

6. Using ODBC call rather than TSQL execute to call a stored procedure

7. ODBC connection using Trusted Connection

8. ODBC connection using Trusted Connection

9. ODBC Error in Control Panel (ODBC - Test Connection) using Filemaker Oracle8 Driver

10. Copy BLOB within TSQL ?

11. Backup TSQL within a sproc ...

12. exporting xml within TSQL


 
Powered by phpBB® Forum Software