Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2002
    Posts
    1

    Unanswered: odbc, linux, and mssql

    I'm not really experenced with databases or odbc but I have a need to connect to a mssql 2000 server for work. I have installed openlink odbc client on my Red Hat 7.3 box. The docs are very confusing and I'm really stumped on what I need here to connect. Any help here will keep me from pulling anymore of my hair out!

    I hope I am providing enough information.

    I'm using the the " OpenLink Generic ODBC Driver" and when I try to connect I get the following:


    Failed
    SQLDriverConnect on Client failed.
    DB_Connect Error
    [OpenLink][ODBC]RPC: Remote system error, SQLSTATE=08004
    [OpenLink][ODBC]Connection rejected by data source, SQLSTATE=08004
    my odbc.inc file looks like this:

    ; portfolio, please check out our web site at:
    ;
    ; http://www.openlinksw.com
    ;
    ; or contact us at:
    ;
    ; general.information@openlinksw.com
    ;
    ; If you have any technical questions, please contact our support
    ; staff at:
    ;
    ; technical.support@openlinksw.com
    ;
    [ODBC Data Sources]
    OpenLink = OpenLink Generic ODBC Driver
    trackit = OpenLink Generic ODBC Driver

    [Default]
    Driver = /usr/openlink/lib/oplodbc.so.1

    [OpenLink]
    Driver = /usr/openlink/lib/oplodbc.so.1
    ServerType = Oracle 8.1.x
    Username =
    Password =
    Database =
    Options =
    FetchBufferSize = 99
    ReadOnly = no
    DeferLongFetch = no
    Host = localhost
    Protocol = TCP/IP
    Description = Sample Oracle 8.1.x Connection

    [trackit]
    Description = Sample DSN
    Options = trackit
    Port = 5000
    Host = trackit.premdor.com
    UserName = JR
    ServerType = SQLServer 2000
    Protocol = TCP/IP
    Driver = /usr/openlink/lib/oplodbc.so.1
    Database = trackit
    ReadOnly = Yes
    NoLoginBox = No
    FetchBufferSize = 99

  2. #2
    Join Date
    Aug 2002
    Location
    Manila
    Posts
    10
    Hi,

    I haven't tried using this "open link ODBC driver" yet but i guess you need to use the 'SQL Server ODBC driver for Linux".

    hth!

  3. #3
    Join Date
    Aug 2002
    Location
    UK
    Posts
    87
    Your odbc.inc file does not include an entry for SQL server .....

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •