Database connection to Oracle 1

[evergrean100]

I am going to work with MX 7 on a Unix server and was wondering how I connect to the database where I wont have a DSN connection like the standard way:

<cfquery name="dbdata" datasource="mydsnName">
SELECT * FROM table
</cfquery>

How would the database connection look if this is the following info:

Host = myhostname:1234
Sid = myabc
Username = "jones"
Password = "baseball"

I know I cant do it this way and need help on it:

<cfquery name="dbdata" datasource="myhostname:1526:myabc", "jones", "baseball");">
SELECT * FROM table
</cfquery>

Thanks.

 

[Sarky78]

This should work for you:

<cfquery dbname="myabc" dbserver="myhostname:1234" username="jones" password="baseball" name="dbdata">
	SELECT *
	FROM table
</cfquery>

Hope this helps!

Tony

 

[evergrean100]

Thanks