Board index » delphi » ODBC connections under Delphi doesn't work!?

Carl-Fredrik Neikter

Delphi Developer
Wed, 13 Jan 1999 03:00:00 GMT

ODBC connections under Delphi doesn't work!?

Anyone who has got an ODBC connection to work properly under Delphi 2? I
need to access a WATCOM 4.0 database, and that works great under Delphi
1. :-/ The problem is that the BDE Configuration Utility shows me an
error message when I'm pushing New ODBC driver. This error message means
(Help later pushed):

"The BDE Configuration Utility could not use the ODBC dynamic link
library (IDODBC32.DLL). The file is either corrupted or not installed
correctly."

I have reinstalled but nothing works. Please help me!

Best Regards,
Carl-Fredrik Neikter, c...@bonsa.se

 
Jeremy D Kapla

Delphi Developer
Fri, 15 Jan 1999 03:00:00 GMT

Re:ODBC connections under Delphi doesn't work!?


Quote
On Sat, 27 Jul 1996, Carl-Fredrik Neikter wrote:
> Anyone who has got an ODBC connection to work properly under Delphi 2? I
> need to access a WATCOM 4.0 database, and that works great under Delphi
> 1. :-/ The problem is that the BDE Configuration Utility shows me an
> error message when I'm pushing New ODBC driver. This error message means
> (Help later pushed):

> "The BDE Configuration Utility could not use the ODBC dynamic link
> library (IDODBC32.DLL). The file is either corrupted or not installed
> correctly."

> I have reinstalled but nothing works. Please help me!

I had this very problem with the ODBC driver for Paradox, while trying to
establish a connection from ERWin to a Delphi app I have.  The driver was
a Microsoft driver and was on a beta disc.  No matter how many times I
tried to set up the connection I got related error messages either from
Delphi or from ERWin.  I finally gave up and parsed a painfully ugly ascii
file representation rather than try to mess with the ODBC quagmire.

Dov

//////////////////////////////////////////////////////////////////////////
// J Dov Kaplan, programmer, CMI, student, University of Arizona, Csc   //
// home: (520) 624-9335    work: (520) 621-4761                         //
// kap...@lectura.cs.arizona.edu                                        //
// j...@aol.com                                                         //
//////////////////////////////////////////////////////////////////////////

J

Delphi Developer
Sat, 16 Jan 1999 03:00:00 GMT

Re:ODBC connections under Delphi doesn't work!?


In article <31FA2611.3...@bonsa.se>, c...@bonsa.se says...

Quote

>Anyone who has got an ODBC connection to work properly under Delphi 2? I
>need to access a WATCOM 4.0 database, and that works great under Delphi
>1. :-/ The problem is that the BDE Configuration Utility shows me an
>error message when I'm pushing New ODBC driver. This error message means
>(Help later pushed):

>"The BDE Configuration Utility could not use the ODBC dynamic link
>library (IDODBC32.DLL). The file is either corrupted or not installed
>correctly."

>I have reinstalled but nothing works. Please help me!

>Best Regards,
>Carl-Fredrik Neikter, c...@bonsa.se

Check that you have a 32 bit odbc driver installed rather than a 16 bit
driver.  You can check this by running the 32 bit odbc admin program
rather than the 16 bit odbc admin program

Fire up the 32 bit odbc administrator and see if the driver appears.  If
it doesn't then it is probably because you have a 16 bit driver installed.
 (To verify this, you can of course fire up the 16 bit odbc admin).

32 bit odbc admin = odbcad32.exe
16 bit odbc admin = odbcadm.exe or possibly odbccnf.exe

Ciao
Jo

Roger Weis

Delphi Developer
Sat, 16 Jan 1999 03:00:00 GMT

Re:ODBC connections under Delphi doesn't work!?


Quote
> Carl-Fredrik Neikter <c...@bonsa.se> wrote in article

<31FA2611.3...@bonsa.se>...

Quote
> ... The problem is that the BDE Configuration Utility shows me an
> error message when I'm pushing New ODBC driver. This error message means
> (Help later pushed):

> "The BDE Configuration Utility could not use the ODBC dynamic link
> library (IDODBC32.DLL). The file is either corrupted or not installed
> correctly."

Have you considered doing native ODBC access to your database and
bypassing the BDE?  Check out
ODBC Express for Delphi at http://www.adam.co.za.

Roger Weiss.
rog...@iafrica.com.

Other Threads

1. Oracle connection (SQLPlus works - Delphi doesn't)

2. Delphi+ODBC+BDE+SqlServer doesn't work

3. QReport doesn't work when native connection to MS Access 97 is used

4. Access connection doesn't work???

5. Delphi doesn't read ODBC Field Defaults.

6. WORKING DIRECTORY: Doesn't work

7. Post doesn't work with Indy, works with ICS

8. why filecopy(string,'test.txt',err) doesn't work

9. Delphi 2.0 - Data Pump doesn't work......

10. LookUp and Fill, Why Doesn't it work in Delphi(Like in DBDT)