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.
>