Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

how to setup a connection to a sybase db

Status
Not open for further replies.

randall2nd

Programmer
Joined
May 30, 2001
Messages
112
Location
US
I know this is probably a stupid question, but i am going to ask anyway.

I need to connect to a sybase database, and then acces it through coldfusion.

I went through the coldfusion administrator and tried to create a data source. I am trying 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. I know that I should know this but I don't.

Can someone help me.
How do I find out the server name?
How do I locate the default database? Randall2nd
 
:( Ok lets try this again

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

I was told that it was originally being used by a power builder aplication, using sybase to connect.

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?

ANY HELP appreciated. Randall2nd
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top