×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

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

Pervasive SQL v8 Updated from MS SQL Server 2000

Pervasive SQL v8 Updated from MS SQL Server 2000

Pervasive SQL v8 Updated from MS SQL Server 2000

(OP)
Hi everyone, I am having a very time consuming and frustrating problem. Hopefully someone out there has an answer to this.

1.)Microsoft SQL Server 2000 sp2
2.)Pervasive SQL v8 on seperate machine, running Timberline.

I need to create a linked server so that the MSSQL server can run scheduled jobs to export data from the MSSSQL server to the Pervasive DB. The job and packages are already setup in MSSQL and work fine when manually triggered to a test db on that local machine, but fail when executed with a test db on a mapped drive.  If I use Microsoft Excel I can pull data from the db on the mapped drive, but the MSSQL dts package always fails. I get an error message that says "no such database".

I am also told that a linked server will allow me to do this.  So....  Can anyone be of assistance in instructing me how to create the linked server?

Thanks

RE: Pervasive SQL v8 Updated from MS SQL Server 2000

What's the exact error message when DTS is run?  
Are you specifying a path in your linked server or a DSN?
If it's a DSN, is it a "Client" DSN? If it's a path, try a Client DSN.  

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

RE: Pervasive SQL v8 Updated from MS SQL Server 2000

(OP)
When I run the DTS package, there is no error but the package hangs while trying to input data into the Pervasive DB. The Pervasive table was completely empty so it should have no problem populating it, but 3hrs later I just cancel the execution because nothing is happening. I am specifying a System DSN at this time.

I'll be willing to create a linked server, but how is that any different than what I'm doing now?

RE: Pervasive SQL v8 Updated from MS SQL Server 2000

I'm having similar problems with a job (except I'm going from Pervasive to MS-SQL),  I think I've isolated the problem to that I do not have MS-SQL running as a domain user, it is using a local account and I need to switch that to a domain account so that when the job executes it has access to the other server since if I'm understanding pervasive correctly, there isin't really a TCP connection the client reads files off of a share? -- I have a FTI issues I have to conquer before I can change the MS-SQL account to a domain account.

Does anybody know a good Pervasive Online court, 3day to a week long course, good set of books?   I need get up to speed on pervasive SQL fast but I've grown up in the MS-SQL world and a bit of oracle....Pervasive is a whole different ball of wax.

--MAL

RE: Pervasive SQL v8 Updated from MS SQL Server 2000

As far as training, check out http://www.goldstar-sw.com/classes.asp.

Pervasive has a client and server piece that communicate using TCP/IP so the Pervasive client doesn't read files directly.  It opens a socket communication with the server and the PSQL server side listens on the proper port.  

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