Multiple data-sources not working

"Chris Ralph" <[email protected]>
Newsgroups gmane.comp.db.mdb-tools.devel
Message-ID <002501c71e2d$f4883fc0$6700a8c0@skeletonman>
Hi,

I installed mdbtools along with  unixODBC to connect to ms access databases
via odbc.  The problem is that regardless how many data sources I add in
odbc.ini, it always uses the first database in the list..

odbcinst.ini:
----------------------
[MDBToolsODBC]
Description             = MDB Tools ODBC drivers
Driver          = /usr/local/lib/libmdbodbc.0
----------------------


odbc.ini:
----------------------
[FTP]
Description             = FTP list
Driver          = MDBToolsODBC
Database                = /home/skeleton-man/public_html/water/ftp.mdb
Servername              = localhost
UserName                =
Password                =

[Water]
Description             = Water Module
Driver          = MDBToolsODBC
Trace           = Yes
TraceFile               = /var/log/sql.log
Database                = /home/skeleton-man/public_html/water/water.mdb
Servername              = localhost
UserName                =
Password                =
-----------------

In the above example you can clearly see I'm referencing two different
databases, but regardless what I change, the second datasource (Water)
always connects to ftp.mdb instead of water.mdb.  If I were to swap the
order of the data sources and put Water at the top, then both data sources
would point to water.mdb and ftp.mdb would be ignored.

I am running the latest versions of both mdbtools (0.6pre1) and unixODBC and
at first thought this might've been a php bug, but the "isql" tool produces
exactly the same results.

I tried the unixODBC mailing list and they seemed to think it was a driver
issue..  Any ideas ?

Chris


-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys - and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.