Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

accessing windows ADS from Linux ODBC

2 posts in ODBC Last posting was on 2011-04-12 14:56:49.0Z
Chris Curvey Posted on 2011-04-12 13:37:29.0Z
Date: Tue, 12 Apr 2011 09:37:29 -0400
From: Chris Curvey <chris@chriscurvey.com>
User-Agent: Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10.6; en-US; rv:1.9.2.13) Gecko/20101207 Thunderbird/3.1.7
MIME-Version: 1.0
Newsgroups: Advantage.ODBC
Subject: accessing windows ADS from Linux ODBC
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 96.242.124.51
Message-ID: <4da4558e@solutions.advantagedatabase.com>
X-Trace: 12 Apr 2011 06:37:18 -0700, 96.242.124.51
Lines: 26
Path: solutions.advantagedatabase.com
Xref: solutions.advantagedatabase.com Advantage.ODBC:1923
Article PK: 1133300

I'm going to give this another shot. (Has anyone ever gotten this working?)

I never was able to get this working with the 9.1 ODBC driver, and it
does not come in a 64-bit version anyway, so I'm going to try the 10.1
driver (to talk to a 9.1 server).

I'm running on a 64-bit Ubuntu 10.10 server. I've installed the
Advantage ODBC drivers via setup.pl, and I have the ODBCConfig utility
running. I create my new data source

Name: MainSystem_Backup
Description: MainSystem_Backup
Driver: /usr/local/ads/odbc/redistribute/libadsodbc.so
Driver64: /usr/local/ads/odbc/redistribute/x64/libadsobc.so

now I come to "setup" and "setup64". The ODBCConfig says that these
files usually end with "S.so", but there are no files like that.

the help files that came with the ODBC driver say that on Windows there
is an "adsset.dll" that allows you to "configure the Advantage ODBC
driver via the GUI setup utility. No equivalent file exists for Linux"

If I leave the fields blank, I get an error message saying "Could not
construct a property list for (MainSystem_Backup)"

So, am I just up the creek, or do I have to set up /etc/odbc.ini manually?


Alex Wong Posted on 2011-04-12 14:56:49.0Z
Date: Tue, 12 Apr 2011 14:56:49 +0000 (UTC)
Message-ID: <9d1879956a8e8cdc706b1b0f858@devzone.advantagedatabase.com>
From: Alex Wong <someone@sybase.com>
Subject: Re: accessing windows ADS from Linux ODBC
Newsgroups: Advantage.ODBC
References: <4da4558e@solutions.advantagedatabase.com>
MIME-Version: 1.0
Content-Transfer-Encoding: 8bit
Content-Type: text/plain; charset=iso-8859-1; format=flowed
X-Newsreader: JetBrains Omea Reader 1098.1
NNTP-Posting-Host: 10.6.193.123
X-Trace: 12 Apr 2011 07:56:37 -0700, 10.6.193.123
Lines: 40
Path: solutions.advantagedatabase.com
Xref: solutions.advantagedatabase.com Advantage.ODBC:1924
Article PK: 1133298

Hi Chris,

I do not know about the setup problem but it may be moot anyway. You cannot
use 10.x driver to talk a 9.1 server.

--
Alex

> I'm going to give this another shot. (Has anyone ever gotten this
> working?)
>
> I never was able to get this working with the 9.1 ODBC driver, and it
> does not come in a 64-bit version anyway, so I'm going to try the 10.1
> driver (to talk to a 9.1 server).
>
> I'm running on a 64-bit Ubuntu 10.10 server. I've installed the
> Advantage ODBC drivers via setup.pl, and I have the ODBCConfig utility
> running. I create my new data source
>
> Name: MainSystem_Backup
> Description: MainSystem_Backup
> Driver: /usr/local/ads/odbc/redistribute/libadsodbc.so
> Driver64: /usr/local/ads/odbc/redistribute/x64/libadsobc.so
> now I come to "setup" and "setup64". The ODBCConfig says that these
> files usually end with "S.so", but there are no files like that.
>
> the help files that came with the ODBC driver say that on Windows
> there is an "adsset.dll" that allows you to "configure the Advantage
> ODBC driver via the GUI setup utility. No equivalent file exists for
> Linux"
>
> If I leave the fields blank, I get an error message saying "Could not
> construct a property list for (MainSystem_Backup)"
>
> So, am I just up the creek, or do I have to set up /etc/odbc.ini
> manually?
>