Hello Friends
I'm trying to use your odbc driver to attach a DBISAM database to my Sql Sever 2008 as a linked server. Then i could wrote a sql script to migrate the my
old data to my fresh new sql server database (same structure).

I instaled the odbc driver (trial version) and create the odbc datasource. When i try to connect with the sql server i get this message:

OLE DB provider "SQLNCLI10" for linked server "xxxx" returned message "Invalid authorization specification".
Msg 7399, Level 16, State 1, Line 1
The OLE DB provider "SQLNCLI10" for linked server "xxxx" reported an error. Authentication failed.
Msg 7303, Level 16, State 1, Line 1
Cannot initialize the data source object of OLE DB provider "SQLNCLI10" for linked server "xxxx".

Any help would be appreciated.

Thank you

Claudio

Claudio,

<< I instaled the odbc driver (trial version) and create the odbc
datasource. When i try to connect with the sql server i get this message:

OLE DB provider "SQLNCLI10" for linked server "xxxx" returned message
"Invalid authorization specification".
Msg 7399, Level 16, State 1, Line 1
The OLE DB provider "SQLNCLI10" for linked server "xxxx" reported an error.
Authentication failed.
Msg 7303, Level 16, State 1, Line 1
Cannot initialize the data source object of OLE DB provider "SQLNCLI10" for
linked server "xxxx". >>

You should be using the MSDASQL linked server provider in order to use the
OLE DB Provider for ODBC Drivers.  You should basically only have to specify
the DSN name when creating the linked server, and then it should work just
fine.

A good way to test this would be just use OPENQUERY() like this:

SELECT * FROM OPENQUERY(DBISAM, 'SELECT * FROM MyTable')

where 'DBISAM' is the linked server name that you have already created, and
'MyTable' is the name of the table in the DSN that you want to query.

That will at least make sure that you can access the DSN before you actually
try to start using four-part names to access the data directly.

--
Tim Young
Elevate Software
www.elevatesoft.com