Re: [Firebird-odbc-devel] ODBC driver

[Salgado, E. <esa...@tv...>]

Paul,
=20
  I went ahead and downloaded the source to the driver and found out
that the connection string is case-sensitive.  It works with:
=20
DRIVER=3D{Firebird/Interbase(r) driver}; DBNAME=3DC:\Data\MyData.GDB;}
=20
  I am now able to connect, but I get an "unspecified error" when try =
to
do a simple SELECT statement on the dataset using the ADOExpress
components.
=20
  Back to the drawing board.  Thanks again for all your help.
=20
Later,
=20
Ed Salgado
Senior Developer
TvSCAN - A Division of BuyMedia, Inc.
800-476-7226
esa...@Tv... <mailto:esa...@Tv...>=20
=20
=20

----- Original Message -----=20
From: Paul  <mailto:pa...@wa...> Beach=20
To: Salgado, Ed <mailto:esa...@tv...> =20
Cc: Paul Reeves <mailto:pa...@fl...> =20
Sent: Wednesday, August 01, 2001 9:55 AM
Subject: Re: [Firebird-odbc-devel] ODBC driver

What exactly are you trying to connect with / to / through?
=20
Regards
Paul Beach
Main Tel (UK):+44 (0) 1844 354465
Mobile: (UK): +44 (0) 7764 188603=20
http://www.ibphoenix.com <http://www.ibphoenix.com>=20

----- Original Message -----=20
From: Salgado,  <mailto:esa...@tv...> Ed=20
To: fir...@li...
<mailto:fir...@li...> =20
Sent: Wednesday, August 01, 2001 3:44 PM
Subject: Re: [Firebird-odbc-devel] ODBC driver

Paul,
=20
  Thanks for the reply.  I am using Win2K with the new IBPhoenix =
driver.
I tried several different connection strings to no avail.  Here's a =
few:
=20

Driver=3D{Firebird/Interbase(r) driver}; DBName=3DC:\Data\MyData.GDB;}
=20
Driver=3D{Firebird/Interbase(r) driver}; =
Database=3DC:\Data\MyData.GDB;}
=20

Driver=3D{Firebird/Interbase(r) driver}; DB=3DC:\Data\MyData.GDB;}
=20
Driver=3D{Firebird/Interbase(r) driver}; DBQ=3DC:\Data\MyData.GDB;}
=20
I'm pretty sure it's the data base key that's not getting set properly
but I just don't know what else to try.
=20
Thanks,
=20
Ed Salgado
Senior Developer
TvSCAN - A Division of BuyMedia, Inc.
800-476-7226
esa...@Tv... <mailto:esa...@Tv...>=20
=20
=20
----- Original Message -----=20

From: Paul  <mailto:pa...@wa...> Beach=20
To: Salgado,  <mailto:esa...@tv...> Ed ;
fir...@li...
<mailto:fir...@li...> =20
Sent: Wednesday, August 01, 2001 9:25 AM
Subject: Re: [Firebird-odbc-devel] ODBC driver

Linux ODBC.INI from the Linux Distribution Kit:
=20
#please do not edit this file.  Doing so may disable
#the admin console.. Use the admin console to add or edit
#DSN's
=20
[ODBC Data Sources]
Employees=3DInterBase 1.0 InterBase Driver
=20

[Employees]
Driver=3D/opt/odbc/lib/ivInterBase00.so
Description=3DInterBase
DbName=3D/opt/interbase/examples/employee.gdb
User=3DSYSDBA
Password=3Dmasterkey
JdbcDriver=3D/opt/odbc/lib/IscDbc00.so
=20
=20
Regards
Paul Beach
Main Tel (UK):+44 (0) 1844 354465
Mobile: (UK): +44 (0) 7764 188603=20
http://www.ibphoenix.com <http://www.ibphoenix.com>=20

----- Original Message -----=20
From: Salgado,  <mailto:esa...@tv...> Ed=20
To: fir...@li...
<mailto:fir...@li...> =20
Sent: Wednesday, August 01, 2001 2:46 PM
Subject: [Firebird-odbc-devel] ODBC driver

All,
=20
  I just downloaded and installed the IBPheonix ODBC driver.  What is
the connection string parameters?  I have tried:
=20
Driver=3D{Firebird/Interbase(r) driver}; Database=3DC:\Data\MyFile.GDB;
Uid=3Dsysdba; Pwd=3Dmiata;
=20
I assume the "Database" key is not supported.  I have also tried "DB"
and "DBQ" to no avail.
=20
Thanks,
=20
Ed Salgado
Senior Developer
TvSCAN - A Division of BuyMedia, Inc.
800-476-7226
esa...@Tv... <mailto:esa...@Tv...>=20