INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

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.

Jobs

Create Linked Server in MS SQL Server

Create Linked Server in MS SQL Server

(OP)
THere are a number of similar posts, but I've been unable to successfully create a Pervasive linked server in MS SQL Server.  I've got Peachtree running Pervasive v9.1.

I've successfully created an ODBC connection on the server that houses SQL Server.  The DSN for the ODBC connection is Peachtree.  

The DNS of the ODBC connection is Peachtree.  The linked server is set up as Product Name: Peachtree, Data source: Peachtree (very clever naming convention, huh?), provider string: MSDASQL.

When I attempt to use the linked server, I get the following error:
"Error 7399: OLE DB provider 'MSDASQL' reported an error.
Invalid connection string attribute]
OLE DB error trace [OLE/DB Provider 'MSDASQL' ID8Initialize::Initialize returned... ]
 

RE: Create Linked Server in MS SQL Server

Is there any more to the error?  
Also, what did you do to create the linked server?  
What version of MS SQL Server are you using?  
 

Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician
http://www.mirtheil.com

RE: Create Linked Server in MS SQL Server

(OP)
In reverse order:
3.SQL Server 2000
2.I used Enterprise Manager to create the linked server.  I created is as a "Microsoft OLE DB Provider for ODBC Drivers"
1. the only thing I left off the error message is "0x80004005:", which followed "Initialize returned".

Laignappe: THe ODBC driver is "Pervasive ODBC CLient Interface", v 9.11.45.00

Thanks.

 

RE: Create Linked Server in MS SQL Server

It should work although I'm wondering if the 0x80004005 is a permissions error.  It's possible the SQL Server process can't read either the ODBC DSN registry entries or possibly the PSQL DLLs.   

Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician
http://www.mirtheil.com

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!

Resources

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