Connect to Oracle DB using Connection String

[CFRAM]

:confused; Please help me out here. I want to connect to Oracle 9i / 10g
database using connection string defined in the application.cfm to create a on
demand database connection and not using Data Sources in the CF Admin. Also I
am using the DB for storing Client variables..... Thanks in Advanve CFRAM

[vkunirs]

Hi

Try this:

"Provider=OraOledb.Oracle.1;User Id=Scott;Password=Tiger;"

this was to use in the vb. i dont know whether it will works or not ... as i can't check as i dont have oracle.

[CFRAM]

Hi, I did something like this it did not work with Oracle 9i <cfquery
dbtype='dynamic' provider='OraOledb.Oracle.1;User Id=cp;Password=change'
name='sample'> select * from agent </cfquery> <cfoutput query='sample'>
#agent_code# </cfoutput>

[vkunirs]

Hi

try this :

"Provider=MSDAORA.1;User Id=Scott;Password=Tiger;"

[CFRAM]

Did not work any better idea.

Thanks