Skip to Content
0
Former Member
Apr 30, 2014 at 10:24 PM

Data services on Linux to MS SQL ODBC connection

694 Views

We have DS 4.1 SP2 running on Linux and trying to connect to MS SQL database via odbc. The admin guide tells you to modify the ds_odbc.ini file with an entry like this:

[test_Microsoft_SQL_SERVER]

Driver = /lib/ libodbc.so

RebrandedLib = TRUE

where install location is location of datadirect ODBC driver. But the problem is there is no libodbc.so in this library. There is a libodc.a file there instead.


Secondly, it also tells us to modify the file referenced by $ODBCINI with the following entry. In my case, ODBCINI also references to ds_odbc.ini under /dataservices/bin folder !!. Also, below it tells you to enter the /lib/DAmsssxx.so file location. But there is no such file under datadirect/lib folder. There is a DAsql25.so instead.

[test_Microsoft_SQL_SERVER]

Driver= /lib/[DA][DD] msssxx.so

Description=DataDirect <current version number> SQL Server Wire Protocol

AlternateServers=

AnsiNPW=Yes

ConnectionRetryCount=0

ConnectionRetryDelay=3

Database=<database_name>

EnableQuotedIdentifiers=1

HostName=<SQL_Server_host>

LoadBalancing=0

LogonID=

Password=

PortNumber=<SQL_Server_server_port>

QuotedId=No

ReportCodePageConversionErrors=0

DriverExpirationBehavior=1

What should I do ? which file do I need to modify exactly and with which library ?? I don't have to modify the odbc.ini file at all ??

Do I need to install the Data direct drivers first ?? if so, how ?

Thanks

BV