Re: Linked Server MS SQL 2000 and Pervasive 7.82

Yeah. If I remember the OLE DB Provider didn't work with MS SQL
Linked server stuff until Pervasive.SQL 2000i SP4 or thereabouts.
In fact there are some OLE DB specific notes on the SP4 download page:
http://www.pervasive.com/support/updates/2000i_sp4.asp

I believe you can use the generic ODBC driver for connectivity.

Leonard

On Wed, 04 Jan 2006 21:23:28 -0600, "Bill Bach"
<goldstar@xxxxxxxxxxxxx> wrote:

>datenisis@xxxxxxxxx wrote:
>
>> let me rephrase, the error only shows " Error 7399: OLE DB Provider
>> 'MSDASQL' Reported an error."
>>
>> It doesn't have the datasource not found part on it.
>
>Well, you got me now. Not being a SQLServer person, I've never had the
>"pleasure" of struggling with linked servers.
>
>Can someone else chime in???

.

Relevant Pages

  • OLE DB Provider for ODBC and Oracle
    ... I created a linked server for MS SQL Server 2005 Express to an Oracle ... database using the OLE DB Provider for ODBC. ... I'm using the OLE DB Provider for ODBC instead of the Oracle OLE DB ...
    (comp.databases.ms-sqlserver)
  • Re: Linked server to as400 - for the love of god please help.
    ... > There is an ODBC DSN on the server machine. ... Creating a linked server using ... > OLE DB provider 'MSDASQL' reported an error. ... > So i instead create a linked server using IBM's own OLEDB provider. ...
    (microsoft.public.sqlserver.server)
  • RE: Oracle Computed column datatype
    ... The column weight is defined ... If I use the local MS OLE DB Oracle driver, ... If I use a linked server connection, ...
    (microsoft.public.data.ado)
  • Re: DTS Import From AS/400 DB2
    ... DB2 with no success. ... Server or MS Host Integration Server to configure the data source for the OLE ... DB provider. ... I was able to create a linked server using ...
    (microsoft.public.sqlserver.dts)
  • Delete via linked server
    ... I am trying to delete records in a table pointing via linked server to Sybase ... OLE DB provider 'MSDASQL' could not delete from table '"dbo"."all_metric"'. ... OLE DB error trace [OLE/DB Provider 'MSDASQL' IRowsetChange::DeleteRows ...
    (microsoft.public.sqlserver.server)