[unixODBC-support] odbc.ini question

Daniel Corbe daniel.junkmail at gmail.com
Thu Aug 25 19:29:07 BST 2005


Hello,

I resolved my issue and I found this document to be exremely helpful. 
Thanks for all the replies:

http://www.unixodbc.org/doc/FreeTDS.html

-Daniel

On 8/25/05, Daniel Corbe <daniel.junkmail at gmail.com> wrote:
> I've tried Driver = TDS as well (I'm using FreeTDS and I've set it up
> according to their documentation)
> 
> -Daniel
> 
> 
> On 8/25/05, Bill Mullin <bill.mullin at gmail.com> wrote:
> > 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
> >
> > _______________________________________________
> > unixODBC-support mailing list
> > unixODBC-support at easysoft.com
> > http://mail.easysoft.com/mailman/listinfo/unixodbc-support
> >
>




More information about the unixODBC-support mailing list