What drivers are u using to connect to Sybase and what platform?
Cant you link tables from Access using ODBC? Create DSN on NT/2000
to Sybase and use access to link the tables?
Or
doesnt Sysbase have an Export DB/Tables Utility.. Almost all DB's(SQL,ORACLE
etc)
have this feature.. i would be surprised.. if Sybase lacks this.
Joe
- Original Message -
From: Allen Hudson [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Thursday, June 06, 2002 1:16 PM
Subject: DB Compatibility Sybase SQL Anywhere
A colleague has a situation that I am sure has crossed the brow of someone
else before.
She has a Coldfusion development Web Application tied to a Sybase SQL
Anywhere database (reason being that is what our government webhosting
department supports). This is the first time that she or I have worked
with
this type of database. This database comes with a utility (I am told)
that
will convert most other db formats to Sybase format to be able to be used.
She cannot find anything as yet that would allow the data in the Sybase db
to be exported or transported to an alternative format like Access 2000.
Just so you know, the majority of clients that we deal with, use Access
since their data requirements are not extensive.
The question: how would one go about getting the data in the Sybase db
into
an alternative format (specifically Access 2000) or any other for that
matter? I am also posing this question in the general sense as well to be
prepared for future web app requirements.
Thank you for your help
Al Hudson
__
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists