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

Error Loading component - Creating ODBC Client Datasource

Error Loading component - Creating ODBC Client Datasource

Error Loading component - Creating ODBC Client Datasource

(OP)
As part of the BusinessVision accounting packaging I get a Btrieve database engine and odbc components.

** I have a few problems listed below, underneath my problems I have listed the version #'s I think are relevant.

Prob #1
Error:
Msgbox Title: Pervasive ODBC Client DSN Setup

error: Failed to connect to server. Error Loading component
-----
Trying to create a Pervasive Odbc Engine Interface yields this error:

Cannot connect to Pervasive.sql server or Pervasive Workstation Engine. Make sure that the Pervasive.Sql Server is started or Pervasive Sql Workstation is enabled.

Prob 3: May be the root cause of problems 1 & 2 but I am not sure..

Running the Pervasive System Analyzer yields this result

Failed to Load Dynamic Link Library w3dbav80.dll or one of the files it requires.

Can someone point me to a detailed FAQ or KB article that details :
- All ENV settings I need.
- All ODBC .dll's, dependencies etc

Versions:
Pervasive ODBC 8.60.192.30
BusinessVision 7.3

Thanks in advance for any and all help

RE: Error Loading component - Creating ODBC Client Datasource

The only environment setting is the path. You need to make sure PVSW\BIN (or where PSQL is installed) is in the system path.  THat'll cause problem #1.  Problem #2 is caused if you don't have a WGE/Server engine on the local machine (or it's not running).  Where's the data?  

Did you install PSQL as part of BusinessVision or was it separate?  If it was separate, how did you run it?  Also, what OS are you on?  

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

RE: Error Loading component - Creating ODBC Client Datasource

(OP)


I reinstalled the program but before and after I ran the Pervasive analyzer and deleted all of the current and previous versions.

Thanks for your response.

I can confirm that BV version 7 (7.3) does install what is required to setup Pervasive ODBC Data sources,

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