7:26 PM [unixODBC][Driver Manager] Data source name not found |
When attempting to use DBI with freetds from your Perl script you may see: [unixODBC] [Driver Manager] Data source name not found, and no default server specified (SQL-IM002) That error wording maybe misleading. It sounds like a DSN is missing or misspelled in /etc/odbc.ini, but in fact it also maybe Driver string having a non-exec/non-conforming parameter. DSNs from /etc/odbc.ini may rely on driver declarations from /etc/odbcinst.ini: For example, this piece from /etc/odbc.ini [dsn_example] ... Driver = SQL ..
[unixODBC] [Driver Manager] Data source name not found, and no default server specified (SQL-IM002)
To remedy the error you may either, [dsn_example] ... Driver = /usr/lib/libtdsodbc.so.0 .. If you need to debug more, see Troubleshooting ODBC connections. These 3 tools: tsql, isql, osql are indispensable. I did identify that Driver issue with the help of osql. |
|
Total comments: 0 | |