Unsupported Screen Size: The viewport size is too small for the theme to render properly.

Can't Use Odbc Import Running Under Wine

forums forums SQLyog Using SQLyog Can't Use Odbc Import Running Under Wine

  • This topic is empty.
Viewing 6 reply threads
  • Author
    Posts
    • #11891
      angleet
      Member

      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

    • #30533
      Khushboo
      Member

      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

    • #30534
      angleet
      Member

      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

    • #30535
      Khushboo
      Member

      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

    • #30536
      nithin
      Member

      Hello,

      The issue has got reproduced at our end.

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

      Thank you

      Nithin

    • #30537
      nithin
      Member

      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

    • #30538
      nithin
      Member

      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

Viewing 6 reply threads
  • You must be logged in to reply to this topic.