I was able to set up a linked server from MS SQL 2000 to pervasive sql
2000

but when I run the sp_catalogs command on the query analyzer I get the
following error message:

Server: Msg 7399, Level 16, State 1, Procedure sp_catalogs, Line 4
OLE DB provider 'UNKNOWN' reported an error. One or more arguments were
reported invalid by the provider.
[OLE/DB provider returned message: The parameter is incorrect.]
[OLE/DB provider returned message: [Pervasive][ODBC Client
Interface][LNA][Pervasive][ODBC Engine Interface]Driver not capable.]

What do I need to do to correct this?

Thanks,

- d

I do not think that the sp_catalogs command will work. When you link
to the Pervasive side, you must use the Pervasive format of the
statements, and their system stored procedures weren't added until
Pervasive PSQL v9.

Try this:
SELECT * FROM X$File
This should give you all the tables. Query X$Field for field data, and
so on. See the Pervasive online manuals for more exact details and
info on joining the tables.
Goldstar Software Inc.
Building on Btrieve(R) for the Future(SM)
Bill Bach
BillBach (AT) goldstarsoftware (DOT) com
http://www.goldstarsoftware.com
*** Sydney: Pervasive.SQL Service & Support Class - 02/27-03/02/2006
***
*** Chicago: Pervasive.SQL Service & Support Class - 03/27-03/30/2006
***

datenisis wrote:

Hi Bill,

I tried this and it works for other tables

ie select * from DEMODATA.DEMODATA..BILLING

but when I do "select * from DEMODATA.DEMODATA..X$FILE" I get the
following:

OLE DB provider 'MSDASQL' returned an unexpected data length for the
fixed-length
column '[DEMODATA].[DEMODATA]..[X$FILE].Xf$Reserved'. The expected data
length is 10, while the returned data length is 0.

Is this possible to fix?

Thanks,

-d

datenisis wrote:

The Xf$Reserved field is simply reserved space. Since it is
uninitialized, it might be giving fits to the SQLServer driver if
"unexpected" data gets returned for it. If you're having problems
getting that data into SQLServer, just skip it! Try this instead:
SELECT Xf$Id, XF$Name, XF$Loc FROM X$File
If this works, then you'll just need to avoid this one field.
Goldstar Software Inc.
Building on Btrieve(R) for the Future(SM)
Bill Bach
BillBach (AT) goldstarsoftware (DOT) com
http://www.goldstarsoftware.com
*** Sydney: Pervasive.SQL Service & Support Class - 02/27/06 ***
*** Chicago: Pervasive.SQL Service & Support Class - 03/27/06 ***