Can't Use Odbc Import Running Under Wine

[angleet]

I am trying to import data from an ODBC database. I have set up freetds and can connect to my database using isql from the commandline.

When I try to connect from within SQLylog I get this error:

[unixODBC][Driver Manager]Can't open lib'/usr/lib/odbc/libtdsodbc.so': file not found

However, the file libtsdodbc.so IS there when I look.

I'm using the trial version of 2.2. This feature is an important factor in deciding if we are going to purchase.

Thank you,

angleet

[Khushboo]

Hi Angleet,

1. Please tell us your system configuration(Linux version, Wine version etc), you can paste the output of these commands:

a. uname -a

b. cat /etc/issue

c. wine –version

2. Please tell us the type of DSN you created (System, file or user).

Quote:

I'm using the trial version of 2.2.

Is it SQLyog 8.2 ? Please tell the correct SQLyog version.

Thanks & Regards,

Khushboo

[angleet]

Hi,

Yes, it is SQLYlog version 8.22

Here is the system info:

jonathant@jonathant-laptop:~$ uname -a

Linux jonathant-laptop 2.6.31-19-generic #56-Ubuntu SMP Thu Jan 28 02:39:34 UTC 2010 x86_64 GNU/Linux

jonathant@jonathant-laptop:~$ cat /etc/issue

Ubuntu 9.10 n l

jonathant@jonathant-laptop:~$ wine –version

wine-1.0.1

jonathant@jonathant-laptop:~$

This is a system DSN – the same one I am using with isql which is working:

jonathant@jonathant-laptop:~$ isql -v SERVER

+

---

+

| Connected! |

| |

| sql-statement |

| help [tablename] |

| quit |

| |

+

---

+

SQL>

And here is:

jonathant@jonathant-laptop:/etc$ cat odbcinst.ini

[FreeTDS]

Description = TDS driver (Sybase/MS SQL)

Driver = /usr/lib/odbc/libtdsodbc.so

Setup = /usr/lib/odbc/libtdsS.so

CPTimeout =

CPReuse =

FileUsage = 1

Both files above in /usr/lib/odbc are present.

And here is odbc.ini:

jonathant@jonathant-laptop:/etc$ cat odbc.ini

[SERVER]

Driver = FreeTDS

Description = ODBC connection via FreeTDS

Trace = No

Servername =

Database =

jonathant@jonathant-laptop:/etc$

The Servername (that I removed above) is configured in /etc/freetds/freetds.conf – it has the right host and port (hence iSQL is working – and is using tds version 7.0

Thanks for your help

'Khushboo' wrote on '02:

Hi Angleet,

1. Please tell us your system configuration(Linux version, Wine version etc), you can paste the output of these commands:

a. uname -a

b. cat /etc/issue

c. wine –version

2. Please tell us the type of DSN you created (System, file or user).

Is it SQLyog 8.2 ? Please tell the correct SQLyog version.

Thanks & Regards,

Khushboo

[Khushboo]

Hi,

Thanks for the information.

We will set up a similar environment and check the issue.

We will update the status once done.

Regards,

Khushboo

[nithin]

Hello,

The issue has got reproduced at our end.

We will look into this in detail and update you the progress.

Thank you

Nithin

[nithin]

Hello,

Regarding this issue I have made a post to Wine forum

http://forum.winehq.org/viewtopic.php?p=40954#40954

We will proceed as soon as we get a reply for this.

Regards

Nithin

[nithin]

Hello,

This issue could be related to Ubuntu package and wine.

Still there's no solution found for this.

And also this seems to be fine with other linux distribution(like RHEL 5)

We could not tell when we can solve this issue because solving/concluding this issue may require some more communication between Ubuntu, wine developers.

Thank you

Nithin

[Author]

Posts