connecting ms access with sybase

[bala]

hi access guru's

there is a requirement wherein i have to connect ms access frontend
with sybase (backend). the data from the frontend should be saved in
the table in sybase databae thro rational suite of tools.

any hints, pointers regarding the above situation would be veri
helpful.

thanx, have a great week ahead

regards
bala

[Larry Linson]

I'm sorry, but you have lost me when you said "the data from the frontend
should be saved in the table in sybase databae thro rational suite of
tools". I have, in the past, used an Access (matter of fact, an Access 2.0)
client to access Sybase SQL Server and Sybase SQL Anywhere. In both cases,
that was using ODBC drivers. I do not know the brand of ODBC drivers that
were used to access Sybase SQL Server, but InterSolv drivers were used to
access SQL Anywhere. Seems to me that I heard InterSolv had been bought out,
but you might do a Google search.

Then again, maybe your Rational suite has ODBC drivers? I know of people who
use Rational software for application modeling for implementation in other
languages, but have never heard of any of their tools being used with
Access.

Larry Linson
Microsoft Access MVP
"bala" <ba*******@yahoo.com> wrote in message
news:b6**************************@posting.google.c om...

hi access guru's

there is a requirement wherein i have to connect ms access frontend
with sybase (backend). the data from the frontend should be saved in
the table in sybase databae thro rational suite of tools.

any hints, pointers regarding the above situation would be veri
helpful.

thanx, have a great week ahead

regards
bala

[Pieter Linden]

ba*******@yahoo.com (bala) wrote in message news:<b6**************************@posting.google. com>...

hi access guru's

there is a requirement wherein i have to connect ms access frontend
with sybase (backend). the data from the frontend should be saved in
the table in sybase databae thro rational suite of tools.

any hints, pointers regarding the above situation would be veri
helpful.

thanx, have a great week ahead

regards
bala

Check this out (watch the wrap... it's all one address!):
http://www.able-consulting.com/MDAC/...ServerAnywhere

[bala]

hi larry

thanx for the information regarding odbc driver for sybase. i just
wanted to know if there was any other work around other than intersolv
(datadirect).

regarding rational suite of tools, well i am confounded too cos i
don't have any further information regarding it and the exact usage.

anyway thanx again for the information provided, have a great day

regards
bala

[bala]

hi Pieter

thanx for the link, have a great day

regards
bala

[Jan Csisko]

Hi Bala,

you might want to have a look at the FreeTDS based
Single-Tier Driver available at http://www.openlinksw.co.uk.

You will be surprised by its performance which you can also benchmark
using a tool which you can download from the very same site.

Hth,
Regards,
Jan

ba*******@yahoo.com (bala) wrote in message news:<b6**************************@posting.google. com>...

hi larry

thanx for the information regarding odbc driver for sybase. i just
wanted to know if there was any other work around other than intersolv
(datadirect).

regarding rational suite of tools, well i am confounded too cos i
don't have any further information regarding it and the exact usage.

anyway thanx again for the information provided, have a great day

regards
bala

[bala]

hey jan

thanx for the information veri much. the backend was switched from
sybase to ms sql server and using ADP so the problem is solved but
definitely it is good to know the way in and out regarding connecting
to sybase

regards
bala