Ms Access odbc configartion but data not connceted

Discussion in 'HOWTO-Related Questions' started by chowdary, Nov 5, 2011.

  1. chowdary

    chowdary New Member

    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
     

Share This Page