wine users - Mar 2010 - Windows API to connect UnixOdbc is not functional in Wine

Hello,

I have configured Wine in Ubuntu 9.04 to use the built-in odbc32.dll which in
turn uses the Linux's unixodbc package.

When I am trying to run my windows application which actually uses Windows API
connecting to Unix ODBC is not working.

The API uses is SQLDriverConnect (), that returns me error
[unixODBC][Driver Manager]Can't open lib '/usr/lib/libtdsodbc.so'
file not found.

Since wine is clone to Windows API any application using that API should run
also in Wine. Please let me know if wine windows API has any issues with
unixODBC. Please advise how should I proceed here.

Warm Regards

Nithin

On Wed, 2010-03-10 at 05:53 -0600, nithin wrote:
> I have configured Wine in Ubuntu 9.04 to use the built-in odbc32.dll
> which in turn uses the Linux's unixodbc package. 
>
> When I am trying to run my windows application which actually uses
> Windows API connecting to Unix ODBC is not working. 
> 
> The API uses is SQLDriverConnect (), that returns me error
> [unixODBC][Driver Manager]Can't open lib
'/usr/lib/libtdsodbc.so' file
> not found.
> 
My guess is that you haven't installed it.

In a Fedora installation /usr/lib/libtdsodbc.so is part of the freetds
(Tabular DataStream) package. I've not installed or used it, but it
seems to be equivalent to an ODBC driver, so must be explicitly
installed.


Martin

Thanks for the reply

The 'freetds' is already installed.

I will paste the details here:

# cat /etc/odbc.ini
[SERVER]
Driver = FreeTDS
Description = ODBC Connection using FreeTDS
Trace = No
Server = 192.168.1.79
Port = 1433
Database = Northwind

# cat /etc/odbcinst.ini 

[FreeTDS]
Description		= TDS Driver
Driver		= /usr/lib/odbc/libtdsodbc.so
Driver64		= 
Setup		= /usr/lib/odbc/libtdsS.so
Setup64		= 
UsageCount		= 1
CPTimeout		= 
CPReuse		= 

# ls libtds*
libtdsodbc.so  libtdsS.so

If I use 'Isql' command I am able to connect using the  same dsn which I
use to connect with our application

# isql SERVER sa 1100zz
+---------------------------------------+
| Connected!                            |
|                                       |
| sql-statement                         |
| help [tablename]                      |
| quit                                  |
|                                       |
+---------------------------------------+

Thank you