Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Link Server Example Pls

Link Server Example Pls

Link Server Example Pls


Please provide a sample on how to set up a link server from a ms sql server to a pervasive sql server.



RE: Link Server Example Pls

What have you tried?  Are you getting an error?
I haven't done it myself (no need) but have seen it and might be able to offer suggestons.

Certified Pervasive Developer
Certified Pervasive Technician

RE: Link Server Example Pls

Hi Mirtheil

I've searched on the net and tried this:

exec sp_addlinkedserver @server='PSQLDEMODATAODBC',
@srvproduct='',@provider='MSDASQL', @datasrc='Demodata',

but I get the following message: Error 7399: OLE DB Provider 'MSDASQL' Reported an error."

- d

RE: Link Server Example Pls

sp_addlinkedserver 'PSQLDEMODATAODBC', ' ', 'MSDASQL', 'DEMODATA'
When you specify the "MSDASQL", you don't need the providerstring or location values.

Certified Pervasive Developer
Certified Pervasive Technician

RE: Link Server Example Pls

Hi Mirtheil,

Your suggestion works, thanks for your help!

- D

RE: Link Server Example Pls

Hi Mirtheil,

After I created the linked server I wanted to test out some simple queries on the database.

I looked to the net for more help and it led me to perform the sp_catalogs to get the name of the db I'm connecting to:

sp_catalogs @server_name = 'DEMODATA'

I executed it and got 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.]

From the error message it looks bad... "Driver Not Capable" Is it a simple thing that I'm missing, ie downloading a driver or a syntax issue, or something more complicated?

If you want to know which version I'm running, on the About for the Control Center it States



Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close