[unixODBC-support] odbc.ini question

Bill Mullin bill.mullin at gmail.com
Thu Aug 25 16:38:21 BST 2005


Driver cite looks wrong
 Driver          = /usr/local/freetds/lib/libtdsodbc.so

I believe that it should be on the order of:
Driver = Mysql 

or some such thing not a call to yo the .so


On 8/25/05, Daniel Corbe <daniel.junkmail at gmail.com> wrote:
> So why doesn't my setup work?  What am I doing wrong?
> 
> snmp01# odbcinst -j
> unixODBC 2.2.11
> DRIVERS............: /usr/local/etc/odbcinst.ini
> SYSTEM DATA SOURCES: /usr/local/etc/odbc.ini
> USER DATA SOURCES..: /root/.odbc.ini
> 
> All odbc/odbcinst files are exactly the same.
> 
> On 8/25/05, Martin J. Evans <martin.evans at easysoft.com> wrote:
> > Run odbcinst -j and it tells you:
> >
> > /usr/local/easysoft/unixODBC//bin/odbcinst -j
> > unixODBC 2.2.12
> > DRIVERS............: /etc/odbcinst.ini
> > SYSTEM DATA SOURCES: /etc/odbc.ini
> > USER DATA SOURCES..: /home/martin/.odbc.ini
> >
> > Martin
> > --
> > Martin J. Evans
> > Easysoft Ltd, UK
> > Development
> >
> >
> > On 25-Aug-2005 Daniel Corbe wrote:
> > > I recently installed UnxODBC out of freebsd ports and I have a question
> > >
> > > Where the bloody hell am I suppoed to put the odbc.ini file?  I have
> > > it in several obvious locations but it doesn't seem to work!
> > >
> > > snmp01# isql -v PRODSQLCLUSTERdsn dcorbe XXXXXXXX
> > > [IM002][unixODBC][Driver Manager]Data source name not found, and no
> > > default driver specified
> > > [ISQL]ERROR: Could not SQLConnect
> > >
> > > This is my odbc.ini file locate in:
> > > /etc/odbc.ini
> > > /usr/local/etc/odbc.ini
> > > /usr/local/etc/ODBCDataSource/odbc.ini
> > > /usr/local/spool/sql/ini/odbc.ini
> > > ~/.odbc.ini
> > >
> > > snmp01# cat /etc/odbc.ini
> > > [ODBC Data Sources]
> > >  PRODSQLCLUSTERdsn = Microsoft SQL Server ODBC DSN
> > >
> > > [PRODSQLCLUSTERdsn]
> > >  Driver          = /usr/local/freetds/lib/libtdsodbc.so
> > >  Description     = Microsoft SQL Server ODBC DSN
> > >  Trace           = No
> > >  Servername      = PRODSQLCLUSTER
> > >  Database        = NOC_Monitor
> > >
> > > [Default]
> > >  Driver          = /usr/local/freetds/lib/libtdsodbc.so
> > >
> > > What am I doing wrong?
> > >
> > > _______________________________________________
> > > unixODBC-support mailing list
> > > unixODBC-support at easysoft.com
> > > http://mail.easysoft.com/mailman/listinfo/unixodbc-support
> > _______________________________________________
> > unixODBC-support mailing list
> > unixODBC-support at easysoft.com
> > http://mail.easysoft.com/mailman/listinfo/unixodbc-support
> >
> 
> _______________________________________________
> unixODBC-support mailing list
> unixODBC-support at easysoft.com
> http://mail.easysoft.com/mailman/listinfo/unixodbc-support
> 


-- 
William P. Mullin
Agentware Systems
186 E. Main St
Suite 300
Northville Mi. 48167
wpmullin at agentwaresystems.com
248-789-5716




More information about the unixODBC-support mailing list