Rob
My only experience with Sybase_ASE is on Mac OS X with CFMX but it
should apply to other systems too.
Yes, you need to have Sybase_ASE, installed and running.
You need to have the particular database running.
In my configuration, can use the admin to setup the datasource:
1) using Sybase as the driver
2) using Other as the driver, referencing a copy of the
macromedia_drivers.jar
placed in /Library/Java/Extensions
here's this datasource definition for one of the Sybase sample
databases, pubs2, as installed.
URL: jdbc:macromedia:sybase://TiBook:11222;DatabaseName=pubs2;
Driver: macromedia.jdbc.sybase.SybaseDriver
Name: SybaseJDBC
Userid: sa
Password: (blank)
Comment: Sybase Interface using Sybase JDBC Driver from CFMX
Note: I prefer to define all my datasources with the long form of the
datasource definition
and use a common JDBC driver (step 2, above). This allows
me to use the same
information when defining the datasource to a non-CF
program such as a GUI SQL
client such as ViennaSQL.
Sybase has a free trial version that you can download.
If you follow the install instructions, you should be able to access
the pubs2 database from CFMX.
HTH
Dick
On Wednesday, November 27, 2002, at 03:21 AM, Robert Shaw wrote:
> I have an app that I am trying to setup and the dB is a Sybase 12 .dat
> file.
> This may be a silly question but do I need to have Sybase ASE server
> loaded
> on the machine to connect to this? I've never worked with connecting to
> Sybase before so any help is appreciated.
>
> TIA,
> Rob
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com
