Questions[unixodbc](server)

I have installed unixODBC from source and mysql-odbc connector from .dmg installer on Mac OSX Lion. This was done a while ago, and at that time I successfully installed a data source (let's call it foo). Now I am trying to add another data source (DSN). I've done this through both ODBC Manager and the command-line tool myodbc-installer given with the tar bundle of the mysql-odbc connector from the mysql website. An entry shows up in /Library/ODBC/odbc.ini, which looks like this:

[ODBC Data Sources]
bar = MySQL ODBC 5.1 Driver

[ODBC]
Trace         = 0
TraceAutoStop = 0
TraceFile     = 
TraceLibrary  = 

[myodbc]
Driver = /usr/local/lib/libmyodbc5.so
SERVER = localhost
PORT   = 3306

[bar]
Driver      = /usr/local/lib/libmyodbc5.so
Description = 
DATABASE    = bar

However, isql fails to find it:

anitya:Preferences neil$ isql bar bar bar -v
[IM002][unixODBC][Driver Manager]Data source name not found, and no default driver specified
[ISQL]ERROR: Could not SQLConnect

Weird thing is, the old DSN foo, which is not to be seen in /Library/ODBC/odbc.ini or /etc/odbc.ini, works fine:

anitya:Preferences neil$ isql foo foo foo
+---------------------------------------+
| Connected!                            |
|                                       |
| sql-statement                         |
| help [tablename]                      |
| quit                                  |
|                                       |
+---------------------------------------+
SQL> 

I'm miffed about where the DSN entries need to be entered on OSX Lion to be found by isql. Thanks in advance for your help!

Having a heck of a time trying to isolate an issue on a new server install:

I've installed MySQL, unixODBC and the MySQL Connector for ODBC, setup odbc.ini and odbcinst.ini as I have on my other 32-bit systems, but having an issue with applications (except PHP) receiving garbled data after a query.

For control purposes, here is what a MySQL direct query returns:

mysql> select id,username from users limit 3;
+------+----------+
| id   | username |
+------+----------+
|  786 | 101010   |
|  587 | 1234     |
| 1124 | 123456   |
+------+----------+
3 rows in set (0.00 sec)

mysql>

The same command in isql via ODBC returns this garbled result, only the first piece of data gets returned:

SQL> select id,username from users limit 3;
+-----------+---------------------------------+
| id        | username                        |
+-----------+---------------------------------+
| 786       |
|
|
+-----------+---------------------------------+
SQLRowCount returns 3
3 rows fetched
SQL>

My applications like isql are not able to return more than one piece of data. Strangely PHP scripts seem to work fine, but unfortunately my applications are not PHP based. Here is formatted PHP output:

ID: 786  Username:  101010
ID: 587  Username:  1234
ID: 1124  Username:  123456

odbc.ini

[site-db]
Description     = MySQL ODBC Site DB
Driver          = MySQL
User            = root
Password        = password
Database        = test
Option          = 3
Socket          = /var/lib/mysql/mysql.sock

odbcinst.ini

[MySQL]
DRIVER          = /usr/lib64/libmyodbc3.so
UsageCount              = 1

System Info:

OS: CentOs 5.7 x86_64
MySQL: Server version: 5.5.20-log MySQL Community Server (GPL) by Remi x86_64
MySQL Connector: v3.51.30-0 x86_64
unixODBC: 2.2.11 x86_64

If anybody can make some suggestions as to how I might be solved this issue, it would be greatly appreciated.

I have my freetds.conf set up thusly. Notice that I specifically have set up the database as myawesomedb:

[EXAMPLE_CONF]
driver = /usr/lib64/libtdsodbc.so
host = example.org
database = myawesomedb
port = 5150
tds version = 8.0
;client charset = UTF-8

Similarly, I've set up the odbc.ini like so:

[EXAMPLE_CONF]
Description = SQL Server 2005
Driver      = FreeTDS
Database   = myawesomedb
Servername  = EXAMPLE_CONF
TDS_Version    = 8.0

However when I connect using tsql, it seems to ignore that I've set the database:

$ tsql -S EXAMPLE_CONF -U jordan
locale is "en_US.UTF-8"
locale charset is "UTF-8"
Password: 
1> select db_name()
2> go

master

This is what I want to happen:

$ tsql -S EXAMPLE_CONF -U jordan
locale is "en_US.UTF-8"
locale charset is "UTF-8"
Password: 
1> select db_name()
2> go

myawesomedb

I assume I'm just missing something in the configuration?

Here is the relevant version info:

FreeTDS version: 0.64 release: 11.el5.centos

unixODBC: version: 2.2.11 release: 7.1

Looking at http://www.unixodbc.org/odbcinst.html it looks like this is a compile-type option only.

I am trying to configure our web server (RHEL 5.4 x86) to connect to an Oracle database using unixODBC. I have installed unixODBC-2.2.11-7.1.1, which yum tells me is the latest version. I have also installed the Oracle InstantClient 11.2 and the Oracle InstantClient ODBC library.

I have symlinked the all the .so files in /usr/lib/oracle/11.2/client/lib to /usr/lib. I have set $LD_LIBRARY_PATH to /usr/lib/, $ORACLE_HOME to /usr/lib/oracle and $TNS_ADMIN to the directory containing my (valid) Tnsnames.ora file. Here are the contents of my /etc/odbcinst.ini file:

[Oracle]
Description = Oracle ODBC Connection
Driver = /usr/lib/libsqora.so.11.1
Setup =
FileUsage =

and my /etc/odbc.ini file:

[Oracle]
Application Attributes = T
Attributes = W
BatchAutocommitMode = IfAllSuccessful
CloseCursor = F
DisableDPM = F
DisableMTS = T
Driver = Oracle
EXECSchemaOpt =
EXECSyntax = T
Failover = T
FailoverDelay = 10
FailoverRetryCount = 10
FetchBufferSize = 64000
ForceWCHAR = F
Lobs = T
Longs = T
MetadataIdDefault = F
QueryTimeout = T
ResultSets = T
ServerName = //<host>:<port>/<db>
SQLGetData extensions = F
Translation DLL =
Translation Option = 0
UserID =

(ServerName has been edited...host, port, and db are actually there, and correct)

When I run isql I get

$ isql -v Oracle
isql: symbol lookup error: /usr/lib/libsqora.so.11.1: undefined symbol: SQLGetPrivateProfileStringW

And running dltest gives me

$ dltest Oracle SQLConnect
[dltest] ERROR dlopen: Oracle: cannot open shared object file: No such file or directory

If anyone has any insights I would be grateful, I've been trying to get this to connect for about 5 hours now...

I am going home for the night, but will gladly provide more details, if necessary, tomorrow morning, to anyone willing to help...