Pervasive SQL v8 Updated from MS SQL Server 2000

[dcsoke]

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

 

[mirtheil]

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

 

[dcsoke]

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?

 

[MarkatLMFJ]

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

 

[mirtheil]

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