User (Legacy) Posted October 23, 2001 Report Share Posted October 23, 2001 Iam trying to trial the ChartFX Internet product in a Coldfusion development environment and Iam hitting severe problems with database connectivity. I have managed to successfully run the example on the SoftwareFX web site for accessing the CfxSrv datasource from Coldfusion, however when I try to modify the code to use a connection to our Oracle database I encounter a "[Microsoft][ODBC driver for Oracle][Oracle]ORA-01017: invalid username/password; logon denied" error from the Microsoft ODBC driver. Using Coldfusion's native method of connecting to the database (CFQUERY) using the same DSN works fine. Whats more of a mystery is that I can't find any information on the arguments used in the example for "Conn.Open" method. I assume specifying UID=?;PWD=? is correct, but what are the other parameters? I have stripped the Coldfusion template down to the very bare bones and as you can see it's very much just a question of creating the connection object and trying to open it. Any advice or assistance would be of great help Cheers Mike ------ Sample CFM file stripped to the bare bones for establishing a connection to the Database ------- <body> <!--- Create the connection object ---> <CFOBJECT ACTION="CREATE" NAME="Conn" CLASS="ADODB.Connection"> <!--- Open the connection to the database ---> <CFSET Conn.Open("DSN=dev3;UID=MCT;PWD=MCT","","0","0")> <!--- More stuff to come ---> </body> Link to comment Share on other sites More sharing options...
User (Legacy) Posted August 6, 2002 Author Report Share Posted August 6, 2002 Did you ever get an answer to this question? "Mike Taylor" <mct@uniport.co.uk> wrote in message news:xyWEvs9WBHA.1684@webserver1.softwarefx.com... > Iam trying to trial the ChartFX Internet product in a Coldfusion development > environment and Iam hitting severe problems with database connectivity. > > I have managed to successfully run the example on the SoftwareFX web site > for accessing the CfxSrv datasource from Coldfusion, however when I try to > modify the code to use a connection to our Oracle database I encounter a > "[Microsoft][ODBC driver for Oracle][Oracle]ORA-01017: invalid > username/password; logon denied" error from the Microsoft ODBC driver. > > Using Coldfusion's native method of connecting to the database (CFQUERY) > using the same DSN works fine. Whats more of a mystery is that I can't find > any information on the arguments used in the example for "Conn.Open" method. > I assume specifying UID=?;PWD=? is correct, but what are the other > parameters? > > I have stripped the Coldfusion template down to the very bare bones and as > you can see it's very much just a question of creating the connection object > and trying to open it. > > Any advice or assistance would be of great help > > Cheers > > Mike > > > ------ Sample CFM file stripped to the bare bones for establishing a > connection to the Database ------- > <body> > > <!--- Create the connection object ---> > <CFOBJECT ACTION="CREATE" NAME="Conn" CLASS="ADODB.Connection"> > > <!--- Open the connection to the database ---> > <CFSET Conn.Open("DSN=dev3;UID=MCT;PWD=MCT","","0","0")> > > <!--- More stuff to come ---> > > </body> > > Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.