Connect to MS SQL database server from UBUNTU

Discussion in 'Server Operation' started by gits1134, Apr 24, 2009.

  1. gits1134

    gits1134 New Member

    here's my scenario.
    i'm running a personal program which runs in windows platform and its database is from another computer. i already installed the program thru wine. my problem now is the program fails to start because of the absence of the database. is

    Q1: possible to connect to MS SQL server for from ubuntu?
    Q2: what do i need and how to it set-up.

    tks!:confused:
     
  2. topdog

    topdog Active Member HowtoForge Supporter

    Yes you can connect from linux to ms sql using the freetds libraries but since you are running a custom program on wine i am not sure how you will get that to work may be you need to install the mysql db connection libraries inside your wine system.
     
  3. tebokkel

    tebokkel New Member

    For a regular Windows-Windows database connection, you probably need an ODBC-definition on your client-box. I just don't know the current state of ODBC-support for Wine, but it appears it should be possible:
    http://ubuntuforums.org/showthread.php?t=759011

    Paul
     
  4. gits1134

    gits1134 New Member

    thanks for the tips! i made a test using jaunty (forgot to mention i used intrepid). using freeTDS, UnixODBC and winetricks to install MDAC 2.8, i got a step up to my experiment.
    i can now get to the login window of my program BUT when i supply my credentials and it takes so long, the message below is "... waiting for authentication"

    it thought of this has something to do with my network credentials. so i installed samba and likewise-open for me to be able to login using windows AD user.

    another problem has arise.
    - i don't have the install apps in my Wine C:\
    - can't install the prog using the domain user

    any idea?
     
  5. hotdog019

    hotdog019 New Member

    sorry all, problem with courier-imap-4.4.1.tar.bz2

    Sorry all

    I am the newest member, so i dont know where post my thread, so I am so sorry post my problem here.

    I read topic "Perfect server centos 5.2 (ISPconfig 3)" and step by step excution, but i have a trouble with installation courier-imap-4.4.1.tar.bz2.
    when i excute command: sudo rpmbuild -ta courier-imap-4.4.2.tar.bz2, an error display as:
    error: File /tmp/courier-imap-4.4.2.tar.bz2 does not appear to be a specifile.

    I hope someone help me solve passed this problem. Thanks for your help!
     
  6. falko

    falko Super Moderator ISPConfig Developer

    Please open a new thread.
     

Share This Page