Hi All

I am new to the world of SQL but I am getting there, I have a problem setting up a linked server to a Sage Line 100 database.

First off I installed the Sage Line 100 ODBC drivers on the SQL server. I then use Enterprise Manager to create a New Linked Server.

I have filled in the following details:-

Linked Server Name = SAGE
Other datasource selected.
Provider Name = Microsoft OLE DB Provider for ODBC Driver
Product Name = Sage Line 100
Data Source = SageLine132 (This is the System DSN name of the driver when I installed it onto the SQL Server)
Security ----
Be made using this security context selected, then I entered the correct Sage Username and Password into the login details.

Unfortuantly just can get this to work, I always get an authentication error when I try to browse the tables or views..

Error 7399: OLE DB Provider 'MSDASQL' reported an error. Authentication Failed.

Cheers

Douglas Bell

It is quite possible that the MSDASQL is not adequate. Have you tried the other options for authentication? I recently compared MSDASQL with Microsoft Jet 4.0 for MS Access and found that MSDASQL is not as good. I don't have a SAGE Line 100 DB, otherwise I would have given a more useful advice. Can you try to set up a linked server in MS Access with the same DSN and try?