I.T. Discussion Community!
-Collapse +Expand
Search PHP Group:

-Collapse +Expand PHP Store

Prestwood eMagazine

March Edition
Subscribe now! It's Free!
Enter your email:

   ► MB LobbyPHP & Delphi for PHP BoardPHP Topic   Print This     

PHP connecting through ODBC for Paradox table(.db)

PHP connecting through ODBC for Paradox table(.db) in PHP topic (part of our PHP & Delphi for PHP group).

Quick Search: connecting   through   Paradox   PHP connecting   PHP connecting through   ODBC Paradox   table( db)  
Most Recent Post
-- --
Rank: Cadet 3rd Year

Hi, I am trying to connect to a Paradox table in PHP using the INTERSOLV 3.11 32-BIT ParadoxFile (*.db) driver. I have the DSN setup properly; however I am not able to connect with the following code:

if (!$connect = odbc_connect($dsn, "", "")) {
        $messages .= "Failed connected to ODBC. DSN ".$dsn.". Error - ".odbc_errormsg().".";
} else {
        $messages .= "Successfuly connected to ODBC. Database ".$dsn.".";
echo $messages."<br>";

and I receive the following error: SQL error: [Microsoft][ODBC Driver Manager] Driver's SQLAllocHandle on SQL_HANDLE_ENV failed, SQL state IM004 in SQLConnect

I have tried restarting the server as well as reinstalling the MySQL ODBC Driver. I am able to connect to these tables using the set up DSNs through classic ASP, so I am confussed as to why I am not able to connect through PHP. Any help would be greatly appreciated. Thank you.

 Posted 40 days ago (Thread Starter)
Comment Quote
About Yesid.B -Collapse +Expand
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.

Post ID #17425, No Replies Be the first!
Thread Started 2/13/2019 7:43:54 AM
View Counter=72
Location=-- -- 
Joined=31 months ago   MB Posts=4  
Write a Comment...
Full Editor
Sign in...

If you are a member, Sign In. Or, you can Create a Free account now.

Anonymous Post (text-only, no HTML):

Enter your name and security key.

Your Name:
Security key = P1252A1
Enter key:
Icon: A Post    Thread    Idea    Important!    Cool    Sad    No    Yes    Includes a Link...   
Thread #17425 Counter
Since 2/13/2019
   Contact Us!
PrestwoodBoards.com was developed and is maintainted by me. Do you have a question or suggestion? Do you see a problem? Contact me now. My goal is to build an ad-free and spam-free source of I.T. information with many contributers (ok to promote your website/company in your bio). Yes, my company Prestwood IT Solutions is mentioned in my bio which shows with every post, but you can contribute and promote your pet project too!

2,043 People Online Now!!  
Sign In to see who's online now!  Not a member? Join now. It's free!
Show more stats...

©1995-2019 PrestwoodBoards  [Security & Privacy]
Professional IT Services: Coding | Websites | Computer Tech