Iodbc issue

Olivier Taylor olivier.taylor at gmail.com
Sun Sep 18 07:36:25 PDT 2005


Libiodbc installed from ports
Myodbc installed from ports

Any help is welcome :)



When using iodbctest, I get :
DSN                              | Driver
----------------------------------------------------------------------------
--
Asterisk                         | MySQL

Enter ODBC connect string (? shows list): DSN=Asterisk
1: SQLDriverConnect = [MySQL][ODBC 3.51 Driver]No DSN entered (516)
SQLSTATE=HYT00
1: ODBC_Connect = [MySQL][ODBC 3.51 Driver]No DSN entered (516)
SQLSTATE=HYT00


Odbcinst.ini
------------
[ODBC Drivers]
MySQL = Installed

[MySQL]
Description=ODBC for MySQL
Driver=/usr/local/lib/libmyodbc3_r-3.51.11.so


Odbc.ini
--------
[ODBC Data Sources]
Asterisk = MySQL

[Asterisk]
Driver          = /usr/local/lib/libmyodbc3_r-3.51.11.so
Description     = Asterisk
Host            = Server3.xxx.be
ServerType      = MySQL
Port            = 3306
FetchBufferSize = 99
User            = olivier
Password        = xxxxx
Database        = ser
ReadOnly        = no
Socket          = /tmp/mysql.sock
Trace=1
TraceFile=/root/odbc.log


[ODBC]
InstallDir=/usr/local/lib



More information about the freebsd-ports mailing list