Linked server problems connecting to Merant database

I have tried all kinds of things to set up a Linked Server to our Merant
database and can't seem to get it to work. I am on a Win2K server using
SQL2000.
I used the following to try to set it up:
****************************************
*****
sp_addlinkedserver @.server = 'tomsvantage',
@.srvproduct = '',
@.provider = 'MSDASQL',
@.datasrc = 'vantage'
****************************************
*****
This seemed to work OK. "vantage" is an ODBC dsn. It works OK with DTC.
I then try to set up the login as:
****************************************
************************
exec sp_addlinkedsrvlogin 'tomsvantage',FALSE, 'odbcvdw','pass'
****************************************
***************************
I get the following error:
****************************************
***************************
Server: Msg 15067, Level 16, State 1, Procedure sp_addlinkedsrvlogin,
Line 56
'odbcvdw' is not a local user. Remote login denied.
****************************************
****************************
Does this mean I have to have an NT user of ODBCVDW as well as a logon
on SQL Server - or just a Logon on Sql Server?
Thanks,
Tom.Thomas Scheiderich wrote:

> I have tried all kinds of things to set up a Linked Server to our Merant
> database and can't seem to get it to work. I am on a Win2K server using
> SQL2000.
> I used the following to try to set it up:
> ****************************************
*****
> sp_addlinkedserver @.server = 'tomsvantage',
> @.srvproduct = '',
> @.provider = 'MSDASQL',
> @.datasrc = 'vantage'
> ****************************************
*****
> This seemed to work OK. "vantage" is an ODBC dsn. It works OK with DTC.
> I then try to set up the login as:
> ****************************************
************************
> exec sp_addlinkedsrvlogin 'tomsvantage',FALSE, 'odbcvdw','pass'
> ****************************************
***************************
> I get the following error:
> ****************************************
***************************
> Server: Msg 15067, Level 16, State 1, Procedure sp_addlinkedsrvlogin,
> Line 56
> 'odbcvdw' is not a local user. Remote login denied.
> ****************************************
****************************
> Does this mean I have to have an NT user of ODBCVDW as well as a logon
> on SQL Server - or just a Logon on Sql Server?
I think I just answered my own question. I was able to set the login up
using SQL Authentication.
Now when I try to set up a Stored Procedure to read a table I get an
error. I get the same error if I try it using Sql Query.
If I use the following:
select * from openquery(tomsVantage,'select * from GLACCT')
I get:
****************************************
*******************
Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'MSDASQL' reported an error.
[OLE/DB provider returned message: Specified driver could not be loaded
due to system error 126 (MERANT 3.60 32-BIT Progress SQL92 v9.1D).]
OLE DB error trace [OLE/DB Provider 'MSDASQL' IDBInitialize::Initialize
returned 0x80004005: ].
****************************************
******************************
I need to figure this out quickly as I am under the gun here.
Thanks,
Tom.

> Thanks,
> Tom.
>sql