Monday, March 12, 2012

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 = 99Hi,

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!|||Your odbc.inc file does not include an entry for SQL server ....

No comments:

Post a Comment