Ms Access odbc configartion but data not connceted

[chowdary]

HI,

I am configure unixodbc,MDB Tool for MS ACCESS FOR ODBC DSN SETTINGS but my php site is opening but not getting the data . I use this files for connection purpose /etc/odbcinst.ini for driver, /etc/odbc.ini for connecting .mdb files.





Thanks & Regards
SURESH

[zombykillah]

Hi, what's unixodbc for?

Why don't you open it direct?
PHP: odbc_connect - Manual

Do you have log entry's?
Does your php script showing you any errors or warnings?
Do you use a productive or test environment?

[ihsan]

I suggest you to read these tutorials:
www howtoforge com/php5_mssql_debian_etch_free_tds_unix_odbc
lo-fi.at/node/330

Edit the urls, because I haven't made 15 posts in linuxforums

[chowdary]

Hi all,

i am give the configuration which i have done for ms access DSN Odbc settings with help of UNIX ODBC, MDBTOOLS.


/etc/odbcinst.ini

# Example driver definitions
[ODBC]
Trace = Yes
TraceFile = /tmp/sql.log

[MDBToolsODBC]
Description = Driver ODBC pour bases Access
Driver = /usr/lib/libmdbodbc.so.0
Setup =
FileUsage = 1
CPTimeout =
CPReuse =
UsageCount = 6
Trace = Yes
TraceFile = /tmp/sql.log

# Driver from the postgresql-odbc package
# Setup from the unixODBC package
#[PostgreSQL]
#Description = ODBC for PostgreSQL
#Driver = /usr/lib/psqlodbc.so
#Setup = /usr/lib/libodbcpsqlS.so
#Driver64 = /usr/lib64/psqlodbc.so


/etc/odbc.ini

[Shopping]
Description = "Base de Donnees ACCES"
Driver = MDBToolsODBC
Database = /var/www/html/proweb/reservation_FRAME.mdb
Servername = localhost
Trace: Yes
TraceFile: qualite.log
Username =
Password =
port = 5432

[shopping2]
Description = "Base de Donnees ACCES"
Driver = MDBToolsODBC
Database = /var/www/html/proweb/PVDBN09.MDB
Servername = localhost
Trace: Yes
TraceFile: qualite.log
Username =
Password =
port = 5432

Thanks & Regards
SURESH