Friday, 4 November 2011

Ms Access odbc configartion but data not connceted

Ms Access odbc configartion but data not connceted

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

No comments:

Post a Comment