new to Pervasive, know nothing
new to Pervasive, know nothing
(OP)
Hi. I'd like a brief intro to obtaining data via ODBC from a Pervasive database. The production software we purchased is on Pervasive. The reports are difficult to get, and time is a serious concern right now to learn the reporting tools of this system.
I'm familiar with SQL Server and Access but haven't ever connected to a Pervasive database. I have to find the raw data in our system. What do I need?
I tried once a while ago to open an ODBC connection on another product we use, and got an error about limited users = 1 so I didn't go any further.
I can get security priviledges, or at least I've been instructed to inform the Executives if the guy in charge of PSQL won't let me in.
Any ideas to help me get started?
I'm familiar with SQL Server and Access but haven't ever connected to a Pervasive database. I have to find the raw data in our system. What do I need?
I tried once a while ago to open an ODBC connection on another product we use, and got an error about limited users = 1 so I didn't go any further.
I can get security priviledges, or at least I've been instructed to inform the Executives if the guy in charge of PSQL won't let me in.
Any ideas to help me get started?
RE: new to Pervasive, know nothing
Also you can visit www.pervasive.com and download the documentation on the various methods of accessing the data. If your limited to 1 user you may have to purchase more licenses from Pervasive or a reseller of Pervasive.
Gil
RE: new to Pervasive, know nothing
RE: new to Pervasive, know nothing
Another option is to load up my workstation with the Pervasive stuff and replicate the database. Do you think this would work? Is that what the paragraph below says?
I have a document for this company's software package that one part says "with the current version you cannot by standard access pervasive data using ODBC. This only works with data replicated in a database or by setting up a Pervasive.SQL database." It refers to a configuration document.
thanks
RE: new to Pervasive, know nothing
Loading Pervasive on your workstation raises an issue with licensing: do you have a valid license to install Pervasive on your workstation?
Have you considered contacting the software vendor and inquiring about your options to access the data?