objectGUID in a ms sql databse in a varchar(100) column HI I'm doing returnAsBinary = "objectGUID" in a <cfldap> query. I was thinking of storing this value returned by objectGUID in a ms sql databse in a varchar(10... 
Can't create datasource to SQL Server Hi Folks, I'm running ColdFusion 9 Trial Version (no hotfixes), SQL Express 2005, Windows XP SP3, IIS. Using ColdFusion Administrator, when I try to create a datasource to SQLExpress 2005 (SQL Server E... 
Finding the Oracle data source (ColdFusion application) I inherited a ColdFusion 10 application with an Oracle 11g back end. Recently, I began receiving java.sql.SQLSyntaxErrorException: [Macromedia][Oracle JDBC Driver][Oracle]ORA-00942: table or view does not exist ... 
Database access using windows authentication We are updating our Applications to use single sign on and are running into a problem with database access. We are using CF11 Enterprise and SQL Server 2008 on IIS 7.5. We have set up the ColdFusion Applicatio... 
Oracle 11g R2 and Oracle 12 Compatibility with ColdFusion 9 and 10 Is ColdFusion 9 certified/compatible with Oracle 11g R2? I cannot find the compatibiliy Matrix for CF9 anywhere on Adobe's site. In addition, does anyone know when/if will Oracle 12 be certified for ... 
JDBC connection error I'm trying to create a DSN in ColdFusion Standard v11 server using Sybase jConnect 6.05 JDBC driver connecting to a Sybase SQL AnyWhere 12 Server (running on another server machine). ColdFusion has been installed on a... 
If statement in update query I was wondering if you could have a cfif statement inside of a update query. See example below. Is there a better way of doing it? thanks. <cfquery DATASOURCE="xxx" name="update"> UPDATE pla... 
Specific instances not connecting to DSNs Very odd issue that has just started with our CF10 environment with 2 of our dev boxes.....I have a box for example that has been configured with 2 instances....dev-app and dev-admin. Randomly both instanc... 
CF11 - SQL Type Not Supported By This Driver on basic ORM Update We are testing out one of our web applications in CF11. We have a basic ORM entity update function that fetches an object, individually calls several setters, and then saves the entity inside a transaction tag... 
Connection verification failed for data source Hi, I'm trying to connect to a MS SQL2000 and a MYSQL server with CF11. System WIN7, Apache32, bit CF11 32 bit, the error message is. Connection verification failed for data source: picos java.sql.SQLExcepti... 
Very slow Oracle Stored Procedure in ColdFusion 11 Recently I installed ColdFusion 11 Developer version (on Windows 8 & IIS) to test the migration of a CF9 based website that uses Oracle as its underlying DB. 1 of the first problems I encountered are the PLSQL sto... 
No matching authentication protocol Oracle 12c Hi, we are working with ColdFusion 10 and Oracle 12c Database, but when we are trying to connect with the database across CF, we have the following message: java.sql.SQLException: [Macromedia][Oracle JDBC Dr... 
which driver best for DB connection Native driver vs jdbc drivers In ColdFusion we can create DSN in 2 ways. Either we can select the driver for the specific database or we can use the Other as the driver and we can create the DSN by specifying the connection string. Which is the be... 
how to connect to sql server 2012 multi-subnet failover clustering Hello, I am looking to connect to the last sql server 2012 multi-subnet failover clustering which requires to mention the connection string MULTISUBNETFAILOVER=Yes. Even though I have mention, its stil... Considering upgrading from CF8 up to CF11... notice in the CF11 support matrix that Sybase Adaptive Server Enterprise 15.0, 15.5 is not supported. While we primarily connect to Oracle DB, we do need to connect to Sybase DBs periodically. Is the plan to Considering upgrading from CF8 up to CF11... notice in the CF11 support matrix that Sybase Adaptive Server Enterprise 15.0, 15.5 is not supported. While we primarily connect to Oracle DB, we do need to con... 
What is the latest version of SQL Server which ColdFusion 7 supports? What is the latest version of SQL Server which ColdFusion 7 supports? For example can Cold Fusion 7 connect to SQL Server 2012 or 2008 without any problem? Thanks 
Having problems connecting Coldfusion10 with sql server express 2012 Hi, I am having problems setting up a datasource for a local sql express 2012 server. Its running as the default instance. Connections are working with ODBC and client told just not Coldfusion. When I ... 
Issues with CF9 and Oracle 11g R2? We have a need to upgrade our Oracle DB from 11g R1 to 11g R2 and are not in a posiition to move off of ColdFusion 9 yet. Has anyone run into any issues with 11G R2? I know it's not officially suppor... issues with data returned on application.cfc onRequeststart I have a shopping cart that works from main code with VD on IIS. So all the code is places in one directory, and for each store I create a Virtual directory on the IIS so a store link will look like this : www.sho... 
Concatenate date time and update SQL datetime field I have a form that captures date and time in 2 separate fields data and time. I need to combine these fileds and UPDATE a SQL database (datetime field) The date field is passed like this ... 
Sign in to follow, share, and participate in this community.