forums › forums › SQLyog › Using SQLyog › Can't Use Odbc Import Running Under Wine
- This topic is empty.
-
AuthorPosts
-
-
March 2, 2010 at 7:53 pm #11891angleetMember
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
-
March 3, 2010 at 5:24 am #30533KhushbooMember
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
-
March 3, 2010 at 7:37 am #30534angleetMember
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
-
March 3, 2010 at 1:03 pm #30535KhushbooMember
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
-
March 4, 2010 at 10:13 am #30536nithinMember
Hello,
The issue has got reproduced at our end.
We will look into this in detail and update you the progress.
Thank you
Nithin
-
March 10, 2010 at 12:41 pm #30537nithinMember
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
-
March 18, 2010 at 2:09 pm #30538nithinMember
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
-
-
AuthorPosts
- You must be logged in to reply to this topic.