×
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

V8.6 Provider cannot be found. It may not be properly installed.

V8.6 Provider cannot be found. It may not be properly installed.

V8.6 Provider cannot be found. It may not be properly installed.

(OP)
Machine:
XP
Pervasive Workgroup V8.6
No domain controller / Workgroup is set up
P2P

Can't connect to a database on the server or locally on the machine.

Tried the following connection strings without any luck:
Provider=PervasiveOLEDB;Data Source=C:\Folder\Data;

Provider=PervasiveOLEDB.8.60;Data Source=DATA;LOCATION=SERVER

Driver={Pervasive ODBC Client Interface};ServerName=;dbq=DATA


RE: V8.6 Provider cannot be found. It may not be properly installed.

Can you connect to the database using the PCC?  If not, what error do you see?
What does your code look like (or what are you using to pass the connection string in)?  
Just to be clear, the line:
Driver={Pervasive ODBC Client Interface};ServerName=;dbq=DATA
needs a ServerName.  It can be localhost or the remote servername but there needs to be a name.  
Can you connect using the DEMODATA database (instead of yours)?

Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician
Custom VB and Btrieve development.
http://www.mirtheil.com

RE: V8.6 Provider cannot be found. It may not be properly installed.

(OP)
I can connect through PCC perfectly on both machines.

The connection string is: Driver={Pervasive ODBC Client Interface};ServerName=SERVER;dbq=DATA

I haven't tried the DEMODATA - will ask the client to test this and let you know.

Mostly the app can connect using the Provider=PervasiveOLEDB;Data Source=C:\Folder\Data; connection string
About 1 out of every 5 installations have to connect using one of the other connection methods.

The only difference I can see on this site is that they don't have a domain controller but a workgroup set up - not sure if this is relevant?

RE: V8.6 Provider cannot be found. It may not be properly installed.

PSQL doesn't need a domain controller.  What it does need is name resolution using either SPX, TCP/IP, or NetBios.  
If the PCC always works but the OLEDB doesn't, then my next question would be to find out how the OLEDB is being installed.  Is this PSQL 8.6 and is the install of PSQL being done by the Pervasive installer or a custom install?

Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician
Custom VB and Btrieve development.
http://www.mirtheil.com

RE: V8.6 Provider cannot be found. It may not be properly installed.

(OP)
I am not sure how Pervasive is installed, our app is an add on to an accounting system which installs all the required programmes.  Have requested the info from them.

How would I do the name resolution etc?

RE: V8.6 Provider cannot be found. It may not be properly installed.

Easiest way to do name resolution would be a HOSTS file (in C:\WINDOWS\system32\drivers\etc on a WinXP system).  Either that or make sure DNS is setup properly.

Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician
Custom VB and Btrieve development.
http://www.mirtheil.com

RE: V8.6 Provider cannot be found. It may not be properly installed.

(OP)
Thanks.

When installing Pervasive WGE, they call the Pervasive Installation

RE: V8.6 Provider cannot be found. It may not be properly installed.

Is it always PSQL V8.6?  

Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician
Custom VB and Btrieve development.
http://www.mirtheil.com

RE: V8.6 Provider cannot be found. It may not be properly installed.

(OP)
No some clients are running Pervasive 2000i, V8.1 or V8.6.

The client getting the connection error is running 8.6

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