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.

How do I proxy MySql tables in ASE?

3 posts in General Discussion Last posting was on 2011-09-23 10:02:11.0Z
Kevin Eaves Posted on 2011-09-09 20:35:50.0Z
Sender: 23d1.4e67ccc5.1804289383@sybase.com
From: Kevin Eaves
Newsgroups: sybase.public.ase.general
Subject: How do I proxy MySql tables in ASE?
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4e6a78a6.6d84.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 9 Sep 2011 13:35:50 -0700
X-Trace: forums-1-dub 1315600550 10.22.241.41 (9 Sep 2011 13:35:50 -0700)
X-Original-Trace: 9 Sep 2011 13:35:50 -0700, 10.22.241.41
Lines: 5
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:30528
Article PK: 72707

I have a Mysql server and I want to create proxy table on a
ASE server.
How do I get the ASE server to connect to the Mysql server?

Thank you


Michael Peppler [Team Sybase] Posted on 2011-09-10 05:48:04.0Z
From: "Michael Peppler [Team Sybase]" <mpeppler@peppler.org>
Organization: Peppler Consulting SARL
Subject: Re: How do I proxy MySql tables in ASE?
User-Agent: Pan/0.14.2 (This is not a psychotic episode. It's a cleansing moment of clarity.)
Message-ID: <pan.2011.09.10.05.48.03.654271@peppler.org>
Newsgroups: sybase.public.ase.general
References: <4e6a78a6.6d84.1681692777@sybase.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Date: 9 Sep 2011 22:48:04 -0700
X-Trace: forums-1-dub 1315633684 10.22.241.152 (9 Sep 2011 22:48:04 -0700)
X-Original-Trace: 9 Sep 2011 22:48:04 -0700, vip152.sybase.com
Lines: 15
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:30529
Article PK: 72715


On Fri, 09 Sep 2011 13:35:50 -0700, wrote:

> I have a Mysql server and I want to create proxy table on a ASE server.
> How do I get the ASE server to connect to the Mysql server?

There is no official/direct way that I know of.

You need some form of gateway software between the two. Sybase sells a
product called DirectConnect, which does the interfacing between ASE and
other DBMS servers (Oracle, MS-SQL, etc).

So you might be able to get DirectConnect to work using an ODBC driver,
but I don't think it's supported/tested.

Michael


Cory Sane [TeamSybase] Posted on 2011-09-23 10:02:11.0Z
From: "Cory Sane [TeamSybase]" <cory!=sane>
Newsgroups: sybase.public.ase.general
References: <4e6a78a6.6d84.1681692777@sybase.com> <pan.2011.09.10.05.48.03.654271@peppler.org>
In-Reply-To: <pan.2011.09.10.05.48.03.654271@peppler.org>
Subject: Re: How do I proxy MySql tables in ASE?
Lines: 23
MIME-Version: 1.0
Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=original
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Windows Mail 6.0.6002.18197
X-MimeOLE: Produced By Microsoft MimeOLE V6.0.6002.18463
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4e7c5923$1@forums-1-dub>
Date: 23 Sep 2011 03:02:11 -0700
X-Trace: forums-1-dub 1316772131 10.22.241.152 (23 Sep 2011 03:02:11 -0700)
X-Original-Trace: 23 Sep 2011 03:02:11 -0700, vip152.sybase.com
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:30558
Article PK: 72733

Michael,
your idea should work... The only unsupported part would be the odbc driver to mysql.

--
Cory Sane
[TeamSybase]
Certified Sybase Associate DBA for ASE 15.0

"Michael Peppler [Team Sybase]" <mpeppler@peppler.org> wrote in message news:pan.2011.09.10.05.48.03.654271@peppler.org...
> On Fri, 09 Sep 2011 13:35:50 -0700, wrote:
>
>> I have a Mysql server and I want to create proxy table on a ASE server.
>> How do I get the ASE server to connect to the Mysql server?
>
> There is no official/direct way that I know of.
>
> You need some form of gateway software between the two. Sybase sells a
> product called DirectConnect, which does the interfacing between ASE and
> other DBMS servers (Oracle, MS-SQL, etc).
>
> So you might be able to get DirectConnect to work using an ODBC driver,
> but I don't think it's supported/tested.
>
> Michael