[MSSQL] ODBC

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Marek Powichrowski (marekp_at_telbank.pl)
Date: 09/25/04 

Date: Sat, 25 Sep 2004 21:08:17 +0200

Hi all,

is it possibile to access two (or more) database tables using ODBC driver
for MSSQL 2000 ?

I have the select statement :

SELECT K.field1,
    O.field1,
    O.field2
    O.field3
    FROM ( table1 AS O
    LEFT OUTER JOIN other_database_name.table2 AS K ON O.id = K.id )
    WHERE O.field4 IS NULL or O.field4 = 0
    ORDER BY field1, field2, field3

When using OLEDB provider the this statement is executed without any errors.
But when this statement is executed using ODBC then MSSQL return error
message "Unknown object 'other_database_name.table'". What is wrong ?

Simple select statement (for one database) for the same connection string
runs OK when using ODBC connection (with the same connection string).

TIA,

Marek Powichrowski

Relevant Pages

  • Re: Cannot display ODBC login prompt - want to connect without DSN
    ... database without knowing anything beforehand except the driver name. ... need a connection string and different data sources use different connection ... ODBC, ADO, and VB Script. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Ad connection to HR Database
    ... Hilltop Lab - http://www.rlmueller.net ... The connection string ... the server name, instance name, and database name. ... to know what your opinion was about odbc connection or linking the ...
    (microsoft.public.windows.server.scripting)
  • Re: Cannot display ODBC login prompt - want to connect without DSN
    ... Depending on the database you are using, ... you need to know the basics of the connection string and can populate ... no. the login box which you are talking about was provided to ODBC ... When the user exits the dialog box, the driver connects ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: odbc settings
    ... incorrect in that it's not actually pointing to a SQL Server database. ... "Can not find a installable ISAM" I put the connection string code in the ... I have an odbc setup on my box and the connection works great. ...
    (microsoft.public.sqlserver.odbc)
  • Re: Cannot display ODBC login prompt - want to connect without DSN
    ... Depending on the database you are using, ... database without knowing anything beforehand except the driver name. ... you need to know the basics of the connection string and can populate ... no. the login box which you are talking about was provided to ODBC ...
    (microsoft.public.dotnet.framework.adonet)