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