need to connect to a SQL Anywhere db 1

[randall2nd]

I need to connect to a SQL Anywhere database, and then acces it through coldfusion. It was originally being used by a power builder aplication, using sybase to connect.

I went through the coldfusion administrator and tried to create a data source. I am tryed to use the native driver for sybase 11. It is asking me for a server name and default database. I am not real sure what i am supposed to put here.

Can someone help me.
How do I find out the server name?
How do I locate the default database?

------Another way to look at it---------

I need to connect to a database file [*.db]

In windows ODBC datasources there is an "Adaptive Server Anywhere 6.0" connection to the database,under system DSN.
user name : dba
password : sql
Database name : MyAppV2
Database file : C:\apps\myapp\data\MyApp.db

I moved the file onto the server with ColdFusion

How do I connect to it ?
How do I setup the ColdFusion administrator to connect?
Can it be done DSN-less? How?

I just need to be able to connect to the db, ANY HELP appreciated. Randall2nd

 

[tleish]

I know this might sound like a silly question, but did you go through the CFDocs?

Connecting to Sybase System11 Databases

http://www.houseoffusion.com/cfdocs..._Server/3_Managing_Data_Sources/admin0322.htm

- tleish

 

[randall2nd]

Not as silly as the fact that i apperently did not throughly go through the CFDocs. DOHH!

Do you by chance know of a way to do it without loading software on the Server? Randall2nd

 

[tleish]

Which version of ColdFusion Server are you running? - tleish

 

[kirbs]

randall2nd - want me to send this as he's busy. They are using CF 5 server.

 

[randall2nd]

As kirbs said we are running ColdFusion Server 5.

This is all of the information I could find in the CFDocs for Sybase's Adaptive Server Anywhere, requires some software to loaded onto the server. To connect through ColdFusion ODBC an ODBC Data Source needs to be established on the OS, To use the Native Driver Sybase drivers need to be installed. Now it says that loading Sybase Open Client version 11.1.0 will work for this.

However I do not have any Sybase software and I am not trying to connect to any Sybase server.

All I have is a file "my_tables.db". I need to be able to SELECT,INSERT, and DELETE to the seven tables in that file.

Does anyone know any place to download drivers or software that will allow me to create an ODBC connection to this file. It needs to of course be free and preferebly not shareware.

any assitance appreciated Randall2nd

 

[tleish]

Is it a Sybase db file then, or another type of db? - tleish

 

[randall2nd]

Yes it is a Sybase db. Randall2nd

 

[tleish]

Wait a sec, did you say it's allready set up as a ODBC DataSource in the System DSN? - tleish

 

[randall2nd]

Well yes I did say that, BUT that is only on my local box. I have both Powerbuilder and the original application loaded onto my box, both of which probably allow a connection to the ".db" file. Unfortunately, Neither can be loaded on to the server. Randall2nd

 

[tleish]

The ODBC driver(s) have to be set up on the server, I don't see any other way around it. ODBC Drivers are what interperet sql commands from a script, without the correct interpreter, I don't see how it will work. - tleish

 

[randall2nd]

yea :-(

That is the conclusion i have come to also.

So, Does anyone know any place to download the ODBC drivers that will allow me to create an ODBC connection to this file.

It needs to of course be free and preferebly not shareware. Randall2nd

 

[tleish]

Don't they come with Powerbuilder?

They are difficult to find. Below are the four ways, I've read that others have gotten the drivers: [ul][li]Sybase expects you to get drivers from the product CD-ROM and that is the first place you should look. If you go to the Downloads section of their website, you will NOT find any driver downloads. [/li][li]Another way to get a driver is through an EBF (emergency bug fix) - basically a variation on Microsoft's service pack, which is really a variation of a bug fix. Find the latest EBF for your product, read the manifest (it's sybase-speak for readme.txt), make sure it includes the drivers, then download and install. [/li][li]Call Sybase tech support and ask for drivers. They are pretty friendly and will give you some FTP site to download from.[/li] [li]Download the NT evaluation of Sybase System 12. Keep in mind that the download is about 300 MB [/li][li]Go to the beta download section of the Linux 11.9.2 version and download the Sybase PC Client (35MB). At the time of writing this download is directly available here. [/li][li]If all else fails, go to Merant's web site and download their evaluation drivers. [/li][/ul] - tleish

 

[randall2nd]

Hmmm... that sounds familiar. I think i ran across that as well.

I guess I am back to have to load software and setup a windows odbc data source to connect to.

Well thanks for all your work and effort. It is very appreciated. :-D Randall2nd