Results 1 to 2 of 2

Thread: libmdbodbc1

  1. #1
    Join Date
    Oct 2012
    Beans
    1

    libmdbodbc1

    Running 12.04 precise and libmdodbc1 with unix odbc.

    when running 'isql -v testdb' it returns

    "[IM002][unixODBC][Driver Manager]Data source name not found, and no default driver specified
    [ISQL]ERROR: Could not SQLConnect"

    /etc/odbc.ini
    Code:
    [testdb] 
    Description = test 
    Driver = MDBToolsODBC 
    Database = /root/test.mdb
    /etc/odbcinst.ini
    Code:
    [MDBToolsODBC] 
    Description = MDB Tools ODBC drivers 
    Driver = libmdbodbc.so.1
    Setup = libmdbodbc.so.1
    FileUsage = 1 
    Usage Count = 1
    odbcinst -j
    unixODBC 2.2.14
    DRIVERS............: /etc/odbcinst.ini
    SYSTEM DATA SOURCES: /etc/odbc.ini
    FILE DATA SOURCES..: /etc/ODBCDataSources
    USER DATA SOURCES..: /root/.odbc.ini
    SQLULEN Size.......: 8
    SQLLEN Size........: 8
    SQLSETPOSIROW Size.: 8


    ~# odbcinst -q -d
    [MDBTools]

    ~# odbcinst -q -s
    [testdb]



    ~# find / -name 'libmdbodbc*'
    /usr/lib/x86_64-linux-gnu/odbc/libmdbodbc.so.1.0.0
    /usr/lib/x86_64-linux-gnu/odbc/libmdbodbc.so.1
    /usr/share/doc/libmdbodbc1
    /usr/share/lintian/overrides/libmdbodbc1
    /var/lib/dpkg/info/libmdbodbc1:amd64.list
    /var/lib/dpkg/info/libmdbodbc1:amd64.prerm
    /var/lib/dpkg/info/libmdbodbc1:amd64.postinst
    /var/lib/dpkg/info/libmdbodbc1:amd64.shlibs
    /var/lib/dpkg/info/libmdbodbc1:amd64.md5sums
    /var/lib/dpkg/info/libmdbodbc1:amd64.symbols
    /var/cache/apt/archives/libmdbodbc1_0.7~rc1-4_amd64.deb


    no sure where to go from here.

  2. #2
    Join Date
    Mar 2010
    Beans
    1

    Re: libmdbodbc1

    unixODBC needs to know the full path to libmdbodbc.so.1

    Code:
    Description = MDB Tools ODBC drivers 
    Driver = /usr/lib/x86_64-linux-gnu/odbc/libmdbodbc.so.1
    Quote Originally Posted by jbaum View Post
    Running 12.04 precise and libmdodbc1 with unix odbc.

    when running 'isql -v testdb' it returns

    "[IM002][unixODBC][Driver Manager]Data source name not found, and no default driver specified
    [ISQL]ERROR: Could not SQLConnect"

    /etc/odbc.ini
    Code:
    [testdb] 
    Description = test 
    Driver = MDBToolsODBC 
    Database = /root/test.mdb
    /etc/odbcinst.ini
    Code:
    [MDBToolsODBC] 
    Description = MDB Tools ODBC drivers 
    Driver = libmdbodbc.so.1
    Setup = libmdbodbc.so.1
    FileUsage = 1 
    Usage Count = 1
    odbcinst -j
    unixODBC 2.2.14
    DRIVERS............: /etc/odbcinst.ini
    SYSTEM DATA SOURCES: /etc/odbc.ini
    FILE DATA SOURCES..: /etc/ODBCDataSources
    USER DATA SOURCES..: /root/.odbc.ini
    SQLULEN Size.......: 8
    SQLLEN Size........: 8
    SQLSETPOSIROW Size.: 8


    ~# odbcinst -q -d
    [MDBTools]

    ~# odbcinst -q -s
    [testdb]



    ~# find / -name 'libmdbodbc*'
    /usr/lib/x86_64-linux-gnu/odbc/libmdbodbc.so.1.0.0
    /usr/lib/x86_64-linux-gnu/odbc/libmdbodbc.so.1
    /usr/share/doc/libmdbodbc1
    /usr/share/lintian/overrides/libmdbodbc1
    /var/lib/dpkg/info/libmdbodbc1:amd64.list
    /var/lib/dpkg/info/libmdbodbc1:amd64.prerm
    /var/lib/dpkg/info/libmdbodbc1:amd64.postinst
    /var/lib/dpkg/info/libmdbodbc1:amd64.shlibs
    /var/lib/dpkg/info/libmdbodbc1:amd64.md5sums
    /var/lib/dpkg/info/libmdbodbc1:amd64.symbols
    /var/cache/apt/archives/libmdbodbc1_0.7~rc1-4_amd64.deb


    no sure where to go from here.

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •