PrestwoodBoards: www.PrestwoodBoards.com

www.prestwoodboards.com

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)  
Yesid.B
-- --

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>";
exit;


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.

About Yesid.B -Collapse +Expand
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.

Post ID #17425, 1 replies
Thread Started 2/13/2019 7:43:54 AM
View Counter=534
Last Reply Posted 2/17/2020 12:41:38 AM)
Location=-- -- 
Joined=8/12/2016   MB Posts=4  
Most Recent Post
Suleman
Solutions Corporation
-- USA

It is a file-based database system with each table in a separate file or files.

high-performance metal detector

About Suleman -Collapse +Expand
Visit Profile
Membership pending.
Member subscribes to this thread with a verified email.
Member pending approval.
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html, social networking links, message board signature, company profile, etc.

Post ID #17901 (Level 1.1)  Reply to 17425
Thread Started 2/17/2020 12:40:52 AM
Location=-- USA 
Joined=2/17/2020   MB Posts=2  
www.prestwoodboards.com
Copyright (C) Prestwood IT Solutions.
All Rights Reserved.
Printed 7/12/2020