Adobe Community : All Content - Database Access

objectGUID in a ms sql databse in a varchar(100) column

forums_noreply@adobe.com — Tue, 07 Jul 2009 12:33:45 GMT

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(100) column as a primary key. Can you see any pitfalls with this method?

Can't create datasource to SQL Server

forums_noreply@adobe.com — Wed, 05 May 2010 18:49:33 GMT

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 Express), using the SQL Server driver, I get the following error:

Connection verification failed for data source: AMT
java.sql.SQLException: [Macromedia][SQLServer JDBC Driver]The requested instance is either invalid or not running.
The root cause was that: java.sql.SQLException: [Macromedia][SQLServer JDBC Driver]The requested instance is either invalid or not running.

The "instance", which I take to mean the database instance, is "machinename\SQLExpress" (This is a so-called "named instance".) This is what I enter into the "Server" field of the form (Data & Services -> Datasources -> Microsoft SQL Server).

On the other hand, I am able to create an ODBC datasource name in Windows using the Microsoft SQL Server Native Client Version 09.00.3042 driver and using the same instance, "machinename\SQLExpress".

Does anybody have any ideas as to what's wrong?

Finding the Oracle data source (ColdFusion application)

forums_noreply@adobe.com — Fri, 24 Oct 2014 16:32:16 GMT

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 error message when attempting to access the application on my Test server. Since it is a gov't application, I do not have direct access to CF Admin or the database. The gov't SysAdmin has verified the CF Admin connection is valid and connected. The DBA has verified the data source exists and the database is up and running. Thoroughly confused as to what is going on. I posted on the Adobe ColdFusion support forum and they suggested I post it here to get database eyes on the issue. The thread is here: https://forums.adobe.com/message/6854985#6854985

Thank you in advance.

Database access using windows authentication

forums_noreply@adobe.com — Tue, 16 Sep 2014 14:21:53 GMT

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 Application Service to run under an AD service account and have created the data sources in CFAdmin leaving the username and password blank. The data sources verify and all seems good. The problem comes when running a query. The credential passed to the database is the service account and not the windows authenticated user. As such the query fails. What are we missing to get CF to pass the Windows Authenticated user credential instead of the service account?

Thanks

Tim

Oracle 11g R2 and Oracle 12 Compatibility with ColdFusion 9 and 10

forums_noreply@adobe.com — Mon, 17 Mar 2014 11:24:56 GMT

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 ColdFusion 9 and/or 10?

JDBC connection error

forums_noreply@adobe.com — Thu, 31 Jul 2014 11:02:40 GMT

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 brand new Windows 2012 (Standard) Server and uses IIS 8 for the web server.

I have done everything mentioned on this page (of course, the driver class and other details have been modified) ColdFusion MX: Configuring the Sybase jConnect 5.5 driver

When I try to verify the connection in CF Administrator, it throws the following error:

Connection verification failed for data source: ars_jdbc

java.sql.SQLException: The method com.sybase.jdbc3.jdbc.SybDatabaseMetaData.getJDBCMajorVersion() has not been completed and should not be called.

The root cause was that: java.sql.SQLException: The method com.sybase.jdbc3.jdbc.SybDatabaseMetaData.getJDBCMajorVersion() has not been completed and should not be called.

I know that, all the connection parameters are correct because I have been able to create a DSN on another CF instance (CF 9) to the same database that I am trying to create a DSN for from CF 11. Please guide me in the right direction to fix the problem.

Thanks.

Milind

If statement in update query

forums_noreply@adobe.com — Tue, 22 Jul 2014 20:02:23 GMT

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.

UPDATE plant_gen_info

SET levels_complete = #URL.var0#

,Q1_answer = #URL.var13#

</cfif>

WHERE ID = #session.member_id#

</cfquery>

Specific instances not connecting to DSNs

forums_noreply@adobe.com — Fri, 18 Jul 2014 16:03:09 GMT

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 instances will have issues talking to our DSN's , the main coldfusion admin http://localhost/CFIDE/administrator communicates no problem with the same set of DSN's. I have 2 boxes out of 15 acting like this....they are all setup exactly the same in terms of virtulization, firewall, etc

Specific error I receive is

Connection verification failed for data source: cc_core
java.sql.SQLException: Timed out trying to establish connection
The root cause was that: java.sql.SQLException: Timed out trying to establish connection

I am at a loss why these boxes are suddenly popping up with these DSN timeouts....I have even rebuilt one of the boxes as far as CF goes but still same issue.....it might work again but I can't have it soo flaky.

CF11 - SQL Type Not Supported By This Driver on basic ORM Update

forums_noreply@adobe.com — Wed, 07 May 2014 22:32:39 GMT

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 in cfscript. We are working with Microsoft SQL 2012 Standard edition. This worked under CF9 and CF10.

Under CF11, we get the following error:

Error: An exception occurred when committing the transaction. The root cause of this exception was: coldfusion.orm.hibernate.HibernateSessionException: [macromedia][SQLServer JDBC Driver]The specified SQL type is not supported by this driver..

The line of code throwing the error is whatever the last line inside the transaction {} block is.

The SQL being run follows. This is super basic. What is going on here?

Hibernate log:

05/07 17:21:04 [ajp-bio-8014-exec-1] HIBERNATE DEBUG - update dbo.registrations set childID=?, registered=?, dropped=?, droppedBy=?, droppedDate=?, neverPlayed=?, WL=?, WLRemoveDate=?, WLRemoveBy=?, sexdiv=?, age_calc=?, Scholarship=?, VIP=?, PlayerSchool=?, Grade=?, PlayerHeight=?, PlayerWeight=?, PlayerEmail=?, PlayerCellPhone=?, LBrother=?, RecentlyMoved=?, submitterID=?, submitType=?, comments=?, RegistrationComments=?, CommentsDivDir=?, DroppedComments=?, RegistrarOnly=?, MedicalInsCarrier=?, MedCond=?, Mediprobs=?, PhysicianName=?, DoctorFull=?, EmergencyContact=?, EmergencyPhone=?, seasonID=?, moveUp=?, moveUpStatus=?, moveUpAsked=?, MoveUpOldDiv=?, PlayedLastYear=?, MethodOfPayment=?, Fee=?, RefundAmount=?, RefundDate=?, AmountPaid=?, InvoiceNo=?, Div=?, batchNum=?, sexdivNextYear=?, email_other=?, dateCreated=?, dateModified=?, lastModifiedBy=?, playerNum=?, refund=?, refundBy=?, donation=?, isAYSOExtra=?, yearbooksGiven=?, yearbooksOrdered=?, noPracticeDay=?, coed=?, clientID=?, seasonUID=? where registrationID=?

05/07 17:21:04 [ajp-bio-8014-exec-1] HIBERNATE TRACE - binding parameter [1] as [VARCHAR] - 37F22B1B-066D-45CB-BBDA-677D8059159D

05/07 17:21:04 [ajp-bio-8014-exec-1] HIBERNATE TRACE - binding parameter [2] as [BOOLEAN] - true

05/07 17:21:04 [ajp-bio-8014-exec-1] HIBERNATE TRACE - binding parameter [3] as [BOOLEAN] - false

05/07 17:21:04 [ajp-bio-8014-exec-1] HIBERNATE TRACE - binding parameter [4] as [VARCHAR] - <null>

05/07 17:21:04 [ajp-bio-8014-exec-1] HIBERNATE TRACE - binding parameter [5] as [TIMESTAMP] - <null>

05/07 17:21:04 [ajp-bio-8014-exec-1] HIBERNATE TRACE - binding parameter [6] as [BOOLEAN] - false

05/07 17:21:04 [ajp-bio-8014-exec-1] HIBERNATE TRACE - binding parameter [7] as [BOOLEAN] - false

05/07 17:21:04 [ajp-bio-8014-exec-1] HIBERNATE TRACE - binding parameter [8] as [TIMESTAMP] - <null>

05/07 17:21:04 [ajp-bio-8014-exec-1] HIBERNATE TRACE - binding parameter [9] as [VARCHAR] - <null>

05/07 17:21:04 [ajp-bio-8014-exec-1] HIBERNATE TRACE - binding parameter [10] as [VARCHAR] - B19

05/07 17:21:04 [ajp-bio-8014-exec-1] HIBERNATE TRACE - binding parameter [11] as [INTEGER] - 6

05/07 17:21:04 [ajp-bio-8014-exec-1] HIBERNATE TRACE - binding parameter [12] as [BOOLEAN] - false

05/07 17:21:04 [ajp-bio-8014-exec-1] HIBERNATE TRACE - binding parameter [13] as [BOOLEAN] - false

05/07 17:21:04 [ajp-bio-8014-exec-1] HIBERNATE TRACE - binding parameter [14] as [VARCHAR] - Test

05/07 17:21:04 [ajp-bio-8014-exec-1] HIBERNATE TRACE - binding parameter [15] as [VARCHAR] - 3

05/07 17:21:04 [ajp-bio-8014-exec-1] HIBERNATE TRACE - binding parameter [16] as [VARCHAR] - 23

05/07 17:21:04 [ajp-bio-8014-exec-1] HIBERNATE TRACE - binding parameter [17] as [VARCHAR] - 44

05/07 17:21:04 [ajp-bio-8014-exec-1] HIBERNATE TRACE - binding parameter [18] as [VARCHAR] -

05/07 17:21:04 [ajp-bio-8014-exec-1] HIBERNATE TRACE - binding parameter [19] as [VARCHAR] -

05/07 17:21:04 [ajp-bio-8014-exec-1] HIBERNATE TRACE - binding parameter [20] as [VARCHAR] -

05/07 17:21:04 [ajp-bio-8014-exec-1] HIBERNATE TRACE - binding parameter [21] as [BOOLEAN] - false

05/07 17:21:04 [ajp-bio-8014-exec-1] HIBERNATE TRACE - binding parameter [22] as [VARCHAR] - 75F5114C-B32A-4BDA-A125-93FAB7EB3834

05/07 17:21:04 [ajp-bio-8014-exec-1] HIBERNATE TRACE - binding parameter [23] as [VARCHAR] - Father

05/07 17:21:04 [ajp-bio-8014-exec-1] HIBERNATE TRACE - binding parameter [24] as [VARCHAR] - test

05/07 17:21:04 [ajp-bio-8014-exec-1] HIBERNATE TRACE - binding parameter [25] as [VARCHAR] - test

05/07 17:21:04 [ajp-bio-8014-exec-1] HIBERNATE TRACE - binding parameter [26] as [VARCHAR] - <null>

05/07 17:21:04 [ajp-bio-8014-exec-1] HIBERNATE TRACE - binding parameter [27] as [VARCHAR] - <null>

05/07 17:21:04 [ajp-bio-8014-exec-1] HIBERNATE TRACE - binding parameter [28] as [VARCHAR] - test

05/07 17:21:04 [ajp-bio-8014-exec-1] HIBERNATE TRACE - binding parameter [29] as [VARCHAR] - BCS

05/07 17:21:04 [ajp-bio-8014-exec-1] HIBERNATE TRACE - binding parameter [30] as [BOOLEAN] - false

05/07 17:21:04 [ajp-bio-8014-exec-1] HIBERNATE TRACE - binding parameter [31] as [VARCHAR] -

05/07 17:21:04 [ajp-bio-8014-exec-1] HIBERNATE TRACE - binding parameter [32] as [VARCHAR] -

05/07 17:21:04 [ajp-bio-8014-exec-1] HIBERNATE TRACE - binding parameter [33] as [VARCHAR] -

05/07 17:21:04 [ajp-bio-8014-exec-1] HIBERNATE TRACE - binding parameter [34] as [VARCHAR] - LK

05/07 17:21:04 [ajp-bio-8014-exec-1] HIBERNATE TRACE - binding parameter [35] as [VARCHAR] - 302-555-1212

05/07 17:21:04 [ajp-bio-8014-exec-1] HIBERNATE TRACE - binding parameter [36] as [INTEGER] - 9

05/07 17:21:04 [ajp-bio-8014-exec-1] HIBERNATE TRACE - binding parameter [37] as [SMALLINT] - 1

05/07 17:21:04 [ajp-bio-8014-exec-1] HIBERNATE TRACE - binding parameter [38] as [INTEGER] - 0

05/07 17:21:04 [ajp-bio-8014-exec-1] HIBERNATE TRACE - binding parameter [39] as [BOOLEAN] - false

05/07 17:21:04 [ajp-bio-8014-exec-1] HIBERNATE TRACE - binding parameter [40] as [VARCHAR] - <null>

05/07 17:21:04 [ajp-bio-8014-exec-1] HIBERNATE TRACE - binding parameter [41] as [BOOLEAN] - <null>

05/07 17:21:04 [ajp-bio-8014-exec-1] HIBERNATE TRACE - binding parameter [42] as [VARCHAR] - Credit Card - Automated

05/07 17:21:04 [ajp-bio-8014-exec-1] HIBERNATE TRACE - binding parameter [43] as [DOUBLE] - 100.0

05/07 17:21:04 [ajp-bio-8014-exec-1] HIBERNATE TRACE - binding parameter [44] as [DOUBLE] - <null>

05/07 17:21:04 [ajp-bio-8014-exec-1] HIBERNATE TRACE - binding parameter [45] as [TIMESTAMP] - <null>

05/07 17:21:04 [ajp-bio-8014-exec-1] HIBERNATE TRACE - binding parameter [46] as [DOUBLE] - <null>

05/07 17:21:04 [ajp-bio-8014-exec-1] HIBERNATE TRACE - binding parameter [47] as [VARCHAR] - 7176

05/07 17:21:04 [ajp-bio-8014-exec-1] HIBERNATE TRACE - binding parameter [48] as [SMALLINT] - 8

05/07 17:21:04 [ajp-bio-8014-exec-1] HIBERNATE TRACE - binding parameter [49] as [VARCHAR] - <null>

05/07 17:21:04 [ajp-bio-8014-exec-1] HIBERNATE TRACE - binding parameter [50] as [VARCHAR] - B8

05/07 17:21:04 [ajp-bio-8014-exec-1] HIBERNATE TRACE - binding parameter [51] as [VARCHAR] -

05/07 17:21:04 [ajp-bio-8014-exec-1] HIBERNATE TRACE - binding parameter [52] as [TIMESTAMP] - 2013-07-19 12:29:50.0

05/07 17:21:04 [ajp-bio-8014-exec-1] HIBERNATE TRACE - binding parameter [53] as [TIMESTAMP] - {ts '2014-05-07 19:21:04'}

05/07 17:21:04 [ajp-bio-8014-exec-1] HIBERNATE TRACE - binding parameter [54] as [VARCHAR] - 75F5114C-B32A-4BDA-A125-93FAB7EB3834

05/07 17:21:04 [ajp-bio-8014-exec-1] HIBERNATE TRACE - binding parameter [55] as [INTEGER] - 18973

05/07 17:21:04 [ajp-bio-8014-exec-1] HIBERNATE TRACE - binding parameter [56] as [BOOLEAN] - false

05/07 17:21:04 [ajp-bio-8014-exec-1] HIBERNATE TRACE - binding parameter [57] as [VARCHAR] - <null>

05/07 17:21:04 [ajp-bio-8014-exec-1] HIBERNATE TRACE - binding parameter [58] as [DOUBLE] - <null>

05/07 17:21:04 [ajp-bio-8014-exec-1] HIBERNATE TRACE - binding parameter [59] as [BOOLEAN] - false

05/07 17:21:04 [ajp-bio-8014-exec-1] HIBERNATE TRACE - binding parameter [60] as [SMALLINT] - 0

05/07 17:21:04 [ajp-bio-8014-exec-1] HIBERNATE TRACE - binding parameter [61] as [SMALLINT] - 0

05/07 17:21:04 [ajp-bio-8014-exec-1] HIBERNATE TRACE - binding parameter [62] as [VARCHAR] - Wednesday

05/07 17:21:04 [ajp-bio-8014-exec-1] HIBERNATE TRACE - binding parameter [63] as [BOOLEAN] - false

05/07 17:21:04 [ajp-bio-8014-exec-1] HIBERNATE TRACE - binding parameter [64] as [VARCHAR] - 2BDE1C40-A442-46D0-AD11-2E9E9F078069

05/07 17:21:04 [ajp-bio-8014-exec-1] HIBERNATE TRACE - binding parameter [65] as [VARCHAR] - 8FD74B93-990E-4DFE-8D0A-352EA5461180

05/07 17:21:04 [ajp-bio-8014-exec-1] HIBERNATE TRACE - binding parameter [66] as [VARCHAR] - 42E5F844-1310-41CE-BDD6-BB4E6FB8D847

05/07 17:21:04 [ajp-bio-8014-exec-1] HIBERNATE ERROR - [macromedia][SQLServer JDBC Driver]The specified SQL type is not supported by this driver.

Connection verification failed for data source

forums_noreply@adobe.com — Tue, 08 Jul 2014 09:08:27 GMT

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.SQLException: [Macromedia] [SequeLink JDBC driver] [ODBC socket] internal error: the data source name not found and no default driver specified

The root cause what that: java.sql.SQLException: [Macromedia] [SequeLink JDBC driver] [ODBC socket] internal error: the data source name not found and no default driver specified

What can I do? Thank you for an answer.

friendly greetings

Jochen Vetter

Very slow Oracle Stored Procedure in ColdFusion 11

forums_noreply@adobe.com — Thu, 03 Jul 2014 20:03:14 GMT

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 stored procedures that seem to be very slow, like 10-50 times slower than with CF9. So I did a test where I execute the exact same SQL statement, which returns ~11000 rows, with both cfstoredproc and cfquery. The processing time of the stored procedure is 111645ms while the processing time of the cfquery is 362ms. The query doesn't return any (C)LOBs, per row there are 4 columns returned, 3 having a number, 1 having a varchar2 with a max size of 256 characters. I uninstalled CF11 several times but everytime I get the same results, no matter what I try in the CFIDE. Maybe I'm missing something obvious here, but for now I don't see it...

No matching authentication protocol Oracle 12c

forums_noreply@adobe.com — Sat, 01 Feb 2014 18:15:33 GMT

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 Driver][Oracle]ORA-28040: No matching authentication protocol

Does anybody know how can we work with Oracle 12c? Is necessary an update to fix that?

Thank you.

which driver best for DB connection Native driver vs jdbc drivers

forums_noreply@adobe.com — Thu, 26 Jun 2014 14:24:56 GMT

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 best way in terms of the performance for apps. Any idea.

Here I am looking to create the DSN to SQL Server 2012 and I have create 2 DSN's, one with SQL Server driver and one with other and mentioned the connection string. I don't see any difference as of now. Please advise which one to user.

how to connect to sql server 2012 multi-subnet failover clustering

forums_noreply@adobe.com — Mon, 19 May 2014 16:18:59 GMT

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 still failing to create the DSN, I am able to connect to it from SQL Server Management Studio. Does any able to connect it. do i need to install any JDBC drivers for this to success.

Here I am using ColdFusion 9 enterprise edition.

Thanks

Srinivas

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

forums_noreply@adobe.com — Fri, 13 Jun 2014 20:32:34 GMT

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 for CF11 to support Sybase again in the near future?

What is the latest version of SQL Server which ColdFusion 7 supports?

forums_noreply@adobe.com — Wed, 16 Apr 2014 01:02:49 GMT

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

forums_noreply@adobe.com — Fri, 28 Mar 2014 18:33:44 GMT

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 try to set up a connection using the sql driver I get this error:

Connection verification failed for data source: Leaf

java.sql.SQLNonTransientConnectionException: [Macromedia][SQLServer JDBC Driver]Error establishing socket to host and port: 127.0.0.1:1433. Reason: Invalid argument: connect

The root cause was that: java.sql.SQLNonTransientConnectionException: [Macromedia][SQLServer JDBC Driver]Error establishing socket to host and port: 127.0.0.1:1433. Reason: Invalid argument: connect

When I try a Socket connection with an ODBC connection I setup in windows I get this error:

Connection verification failed for data source: LeafDB

java.sql.SQLException: [Macromedia][SequeLink JDBC Driver]Internal network error, connection closed.

The root cause was that: java.sql.SQLException: [Macromedia][SequeLink JDBC Driver]Internal network error, connection closed.

Any ideas?

Thanks,

Issues with CF9 and Oracle 11g R2?

forums_noreply@adobe.com — Tue, 18 Mar 2014 12:16:07 GMT

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 supported by Adobe, but I don't think we will have much choice in the matter.

issues with data returned on application.cfc onRequeststart

forums_noreply@adobe.com — Tue, 18 Mar 2014 01:02:54 GMT

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.shoppingcart.com/store/XXXXX
when the xxx is the prefix of that store.
in the application.cfc ONREQUERSTSTART I take the last part of the URL and match it with the PREFIX I in the list of stores on the DB.
to get the prefix I do this :

Then to get the right store info I used to do this :
<cfset qreadStoreInfo = application.cfc.StoreDetails.read(filterStorePrefix request.store. prefix)>

It all worked well (for over 4yrs) till about 2-3 moths ago (or at least then one of the client complained) when we start seeing the WRONG output of store info, like stores were "mixed" some how – totally randomly.

After following it for a few days I noted that the query that is returned from the CFC is for the wrong store.

At first I thought it’s the request.store.prefix not "stored" by the time I get to the query line so I changed this :

Yet I still get the wrong value back from the Query, and when looking at the Query I can see that the VALUE been sent in is wrong, even that I know for sure that I sent in the right value, since in the email I do an out put of the info on the page.

Did any one encountered any thing like this before ?
Any leads on how to maybe start handling ?

Is there a way that if the client is looking at 2 site at the same time thus queries can get "mixed", even that they are done on the ONREQUEST part of the application.cfc (IE each page should be processed on its own)

Concatenate date time and update SQL datetime field

forums_noreply@adobe.com — Tue, 11 Mar 2014 17:19:04 GMT

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 DSDATE={ts '2013-11-18 00:00:00'}

The time field is passed like this TIME_IN1=14:05

How do I concatenate DSDATE AND TIME_IN1 so that I can insert like this 2013-11-18 14:05:00.000 ?

Executing the SQL statement is not allowed - Error

forums_noreply@adobe.com — Wed, 03 Mar 2010 18:20:09 GMT

I am getting "Executing the SQL statement is not allowed" for an INSERT cfquery that I'm running. I checked the usual suspects:

- DSN allows INSERT

- I've seen reports online where certain field names or values are considered key words, so for protection CF blocks the query in this way (it would be nice if there was a different error message when it gets blocked this way vs. the DSN doesn't allow INSERT error message). The field names and values were all benign strings, so it didn't seem like that.

I took the same string for the query and ran it on another page and it ran fine (same DSN, too).

Oracle error ORA-01461when trying to insert into an ORACLE BLOB field

forums_noreply@adobe.com — Wed, 05 Mar 2014 22:32:19 GMT

I am getting Oracle error ‘ORA-01461: can bind a LONG value only for insert into a LONG column' when trying to insert into an ORACLE BLOB field. The error occurs when trying to insert a large BLOB (JPG), but does not occur when inserting a small (<1K) picture BLOB.(JPG). Any ideas?

BTW, when using a SQL Server datasource using the same code.... everything works with no problems.

ORACLE version is 11.2.0.1

The ORACLE datasource is JDBC using Oracle's JDBC driver ojdbc6.jar v11.2.0.1 (I also have tried ojdbc5.jar v11.2.0.1; ojdbc5.jar v11.2.0.4; and ojdbc6.jar v11.2.0.4 with the same error result.)

Here is my code:

INSERT INTO test_images

(

image_blob

)

SELECT

FROM dual

</cfquery>

Query in an Access database executing a function defined in a module

forums_noreply@adobe.com — Sat, 01 Mar 2014 17:31:13 GMT

Hi all,

I have an Access 2003 database in which some function is defined in a module.
I also have a query defined which calls this function with no problem.
Both the query and the function work well when the query is executed from Access.
But when I try to execute the same query from ColdFusion, I get an error claiming that the function is not defined.

Any Idea ?

The requested instance is either invalid or not running

forums_noreply@adobe.com — Sun, 16 Feb 2014 13:47:54 GMT

I try to set up a datasource to SQL server 2008 Express.

And I get always that message :

The requested instance is either invalid or not running.

I spent a full day looking at all forums threads, I have learn a lot,

Looking through all Google return on that subject, but it still not working.

I ask for help to solve this situation.

Here is my situation :

- Windows server 2008 R2 - CF9.0 - SQL server Express 2008

- Working through TSE (terminal server)

- on SQL server , I can acces the management studio, connect, create DB, anything

- I can Stop/Restart the SQL server service throuh the SQLconfig manager

- I have enable TCP/IP in SQLserver for 2 IPs : 127.0.0.1 and the server externel IP on which I connect through TSE, both on port 1433

- SQL server Express 2008 is installed on Hard Disk D: (not on C:) (C is small for diskspace)

- The SQL server Instance showed in SQL management Studio is : LARDE\SQLEXPRESS

- Authentification in SQL server : SQL server and Windows

- the CF datasource is declared as follow :

Driver : Microsoft SQL server

datasource name : any

database : the accesible SQL database name where i created a new table

server : LARDE\SQLEXPRESS port : 1433

no login

And I get this error in CF admin datasource : The requested instance is either invalid or not running

- I tried also with a new connection on SQLserver (username/password),
add it in the datasource declaration (user login)

same error.

It seems to me that it is a question of Coldfusion access to that instance of SQLserver

I have the same config at home on local, all is working fine. (difference is TSE)

Thanks for any idea, help.

Last modified date of DB

forums_noreply@adobe.com — Tue, 04 Feb 2014 13:10:27 GMT

Using Access databases, (.mdb files , lighter than accdb)

How can I know when the mdb file have been last modified ?

Looking for a simple way.

If possible, by querying something ?

Thanks for any suggestion,

Pierre.

Access 2010 Tricks: Ghost Tables

forums_noreply@adobe.com — Thu, 06 Feb 2014 01:47:26 GMT

I am working on upgrading a client from CF5 to CF10 as well as Access 2010 to SQL Server Express 2012.

I suspect they recently moved from Access 2000 to 2010 based on some message I came across. Don't know if that is germaine to this conversation or not, so I thought I'd throw that in.

In the new CF10 environment, I had a query fail. At first glance, it appeared that one table didn't come across in the conversion.

Checked my copy of the Access database backup -- that table is not there.

Tested the production (CF5 running Access) system and this program works.

Looked in the production Access database -- and the table is NOT there, either!

What is this magic? I see no stored procedures, and it's not a cursor (CF5 didn't have that capability).

Here's the query:

SELECT *

FROM validate_jobnumber

</cfquery>

How is it possible to query an Access table that doesn't exist? Where should I look for this mythical creature?

RLS

Access 2010 to SQL Express 2012

forums_noreply@adobe.com — Thu, 30 Jan 2014 05:58:45 GMT

I'm upgrading a client from CF5 to CF10. They are using Access 2010 and I need to get it to SQL Server Express 2012 as part of the upgrade.

This should be simple enough, right?

I have access to SQL Server 200 / enterprise manager, SQL Express 2005 / 2008 / 2010 / 2012.
I have access to a couple flavors of Access.
I have access to a 32 bit Vista machine, a 64 bit Windows 7 machine, a 32 bit Windows Server, a 64 bit Windows server, and more that I won't bore you with.
Of course, I have CF5, CF6.1, CF7, CF8, CF9, CF10

Got all the tools I should need, right?

Tried to import Access from SQL 2012; errors due to data.
Tried to push (export) Access to SQL 2012; errors.
Tried using every version to push and pull the data, always a couple errors keep it from being clean.

Let's be honest, here. There are so many databases, tables and columns, the last thing I want to do is data-map each and every field in every table in every database. I'm a programmer, right? I can do this.

I installed the Access database engine and get my Access databases connected in CF per some obscure instructions I found for 64 bit CF. Wrote a program that would inspect each database, each table, each field and tell me what's missing and what won't fit.

All Access and SQL connections verify in the CF datasource. I'm good to go!

Program won't run. CF doesn't like the 32 bit Access driver. "[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver]Optional feature not implemented", error code 106.

Okay, let's try the 64 bit version based on what my Google search about this found.

Huh. Installation failed because the client has some 32 bit MS Office programs loaded. Same with my local machine.

Oh, turns out I was trying to use CFDBINFO against the Access database. So, don't do that, but now my easy diagnoses of the databases, tables, and columns is out the window on the Access side.

Every which way I turn around, it seems something prevents me from importing, exporting, or connecting via DSN in order to write a program to handle the problem.

I seriously considered plunking down $300 for Spectral Core's Full Convert 6. Their trial worked for me, but buying programs goes against the grain when it's (normally) in my wheelhouse.

Found an article (http://www.coldfusionmuse.com/index.cfm/2005/8/26/access_metadata) that helped me mine Access the old fashioned way, once I learned how to exposed the MSysObjects table (Navigation Options) and allow them to be read (File, Users and Permissions, User and Group Permissions, select MSysObjects table and enable read).

Now to cycle through the tables and identify what's missing, set the new columns up and copy the data over.

I think I might be on my way, but this is still reeking of "the hard way to do it".

And my wife wonders why I suffer from indigestion.

Thoughts?

Connection verification failed for data source

forums_noreply@adobe.com — Sat, 25 Jan 2014 14:44:03 GMT

I am running windows7, cf8 entrprise, and have setup several databses successfully. For some reason this one isn't working.

Datasource: colcadbase

Driver: other

CF Data Source Name:colcadbase

JDBC URL: jdbc:mysql://localhost:3306/colcadbase

Driver Class: com.mysql.jdbc.Driver

When I try to verify the dbase, I get the following error:

Connection verification failed for data source: colcadbase

java.sql.SQLException: Timed out trying to establish connection

The root cause was that: java.sql.SQLException: Timed out trying to establish connection

Any ideas what is happening here?

Change Default Connection Properties for SQL Server / ColdFusion 7

forums_noreply@adobe.com — Wed, 25 Jun 2008 13:49:40 GMT

Change Default Connection Properties for SQL Server / ColdFusion 7

I've started working with indexed views in my Microsoft SQL Server 2005 database. Whenever a SQL statement alters a field ( INSERT, UPDATE, DELETE ) used by the index on an indexed view certain connection settings must be set.

SET ANSI_NULLS ON
SET ANSI_PADDING ON
SET ANSI_WARNINGS ON
SET CONCAT_NULL_YIELDS_NULL ON
SET NUMERIC_ROUNDABORT OFF
SET QUOTED_IDENTIFIER ON
SET ARITHABORT ON

When ColdFusion connects to SQL server the ARIHABORT setting is OFF causing SQL statements to fail.

I currently have two workarounds for this:

1. Use a stored procedure created with the required settings.

2. Run a cfquery containing the required settings before the UPDATE, INSERT, or DELETE cfquery statement.

Questions:

1. Is it possible to configure ColdFusion's connection to set ARITHABORT ON by default?

2. Does Microsoft's JDBC driver use this setting by default?

My environment:
Microsoft SQL Server 2005
ColdFusion 7.0.2
Windows 2003
Using the SQL Server drivers bundled with CF7

References:
Improving Performance with SQL Server 2005 Indexed Views
http://www.microsoft.com/technet/prodtechnol/sql/2005/impprfiv.mspx

PRB: Error "INSERT Failed" When You Update Table Referenced in an Indexed View
http://support.microsoft.com/kb/305333

Any help is appreciated.

Local SQL Server 2012 (express) ColdFusion 10 Datasource will not connect?

forums_noreply@adobe.com — Wed, 15 May 2013 15:41:15 GMT

Hello

There are several methods to do this out there, not one has worked for me. First, configuring SQL Server by

enabling TCIP connections

Setting IP1 & IP2 Address to 127.0.0.1

setting all TCP Ports to 1433 (IP1 through IP7)

Leave all TCP Dynamic Ports blank

enable Named Pipes

restart SQL Server

Then in Studio:

Security tab under the DB you want to connect to

create a new user

give user a user name and login name

default Schema- dbo

Then in CF Admin:

Server: 127.0.0.1

Port: 1433

User Name: login name from above

Connection verification failed for data source: appraiseriLOCAL

java.sql.SQLInvalidAuthorizationSpecException: [Macromedia][SQLServer JDBC Driver][SQLServer]Login failed for user 'Nu-PC\Nu'.

The root cause was that: java.sql.SQLInvalidAuthorizationSpecException: [Macromedia][SQLServer JDBC Driver][SQLServer]Login failed for user 'Nu-PC\Nu'.

Any help with this will prevent more hair-pulling.

Thanks

Please help, regarding 'content copying'

forums_noreply@adobe.com — Mon, 20 Jan 2014 00:33:59 GMT

I have signed up for Adobe (non-paying memeber). Im using PDF and want to edit the security settings so that content copying of my document is disallowed. I don't know how/ seem to be unable to do so, please will you be so kind to help?

Appologies for asking help with what im sure is a simple matter, regards

Query problem when switching from Access to MS SQL

forums_noreply@adobe.com — Fri, 15 Nov 2013 17:37:27 GMT

I have this query which worked great in Access

SELECT e.wall +l.wall As wall2yr, e.lall +l.lall As lall2yr, l.TEAMID, l.TEAMNAME, l.GY AS LaterGY, l.finalrating AS LaterFinalRating, e.finalrating AS EarlyFinalRating, e.GY AS EarlyGY, LaterFinalRating+EarlyFinalRating AS twoyear FROM TEAMSEASONRATINGINFO AS e INNER JOIN TEAMSEASONRATINGINFO AS l ON l.teamID = e.TeamID AND l.GY = e.GY+1 WHERE l.GY =#url.GY# AND e.finalrating > 0

AND l.DIVISION = #url.DIVISION#

ORDER BY e.finalrating+ l.finalrating DESC

Now I have switched to MS SQL and I am geting this error

[Macromedia][SQLServer JDBC Driver][SQLServer]Invalid column name 'LaterFinalRating'.

Is there something different the way MSSQL handles INNER JOINS or aliases?

ColdFusion 10 - No MS Access with Unicode driver

forums_noreply@adobe.com — Tue, 04 Jun 2013 22:39:19 GMT

I'm setting up a new server to test ColdFusion 10 (will be upgrading from 8) and I don't have the option for MS Access with Unicode from the driver list when adding a new DSN. Based on this referrence (http://help.adobe.com/en_US/ColdFusion/10.0/Admin/WSc3ff6d0ea77859461172e0811cbf364104-7fe 6.html) it looks like it should still be included, but I'm not seeing it. Any ideas how to get the option back?

UNION Query

forums_noreply@adobe.com — Fri, 15 Nov 2013 17:54:44 GMT

I have a union query like this that gets info from 2 different tables

Like this

SELECT ID,CityName, SUM(people) AS sump FROM table 1

GROUP by ID,CityName

UNION

SELECT ID,CityName, SUM(people) AS sump FROM table 2

GROUP by ID,CityName

ORDER BY SUM(people)

</cfquery>

So what I want is the sums from both tables but what I get is the sums of each table.

For example I get

ID-CityName-sump

1- New York -3

1-New York- 4

2-Chicago -5

2-Chicago -6

What I want is
ID-CityName-sump

1-New York- 7

2-Chicago -11

Do I need to do another query after the union query?

reinstall elements

forums_noreply@adobe.com — Fri, 22 Nov 2013 18:44:04 GMT

can i install elements 12 on more than 1 pc

Goa female ℰScoℛTs{{ +919833959165}} Goa companions

forums_noreply@adobe.com — Fri, 15 Nov 2013 12:20:05 GMT

{{ +919833959165}}independent Goa ℰScoℛTs{{ +919833959165}} Goa airhostess ℰScoℛTs, Goa companions, pakistani ℰScoℛTs in Goa

Goa ℰScoℛTs service{{ +919833959165}}Goa ℰScoℛTs agency

forums_noreply@adobe.com — Fri, 15 Nov 2013 12:18:11 GMT

pakistani ℰScoℛTs in Goa, high profile lady ℰScoℛTs Goa{{ +919833959165}} Goa sℰxy ℰScoℛTs,, Goa college ℰScoℛTs, ℂall giℛls in Goa {{ +919833959165}}ℰScoℛTs in Goa, high profile ℰScoℛTs in Goa, cheap ℰScoℛTs in Goa, Goa ℰScoℛTs mobile number

Goa esℂor𝒕s services {{ 00919833959165 }} high profile lady esℂor𝒕 Goa, Goa sexy ℰScoℛTs

forums_noreply@adobe.com — Fri, 15 Nov 2013 12:15:54 GMT

Goa college esℂor s {{ 009833959165 }} ℂall gi ls Goa, esℂor s in Goa, high profile esℂor s in Goa { 009833959165 }!*!*!*!*! cheap ℰScoℛTs in Goa

Goa model esℂor𝒕s {{ +919833959165}} esℂor𝒕 Goa, indian esℂor𝒕s in Goa

forums_noreply@adobe.com — Fri, 15 Nov 2013 12:14:57 GMT

independent Goa esℂor s {{ +919833959165}} Goa esℂor s, Goa airhostess esℂor s {+919833959165}!*!*!*!*! Goa companions, pakistani Esco ts in Goa

Goa esℂor𝒕s {{ +919833959165}} esℂor𝒕 Goa, Goa esℂor𝒕s service

forums_noreply@adobe.com — Fri, 15 Nov 2013 12:13:41 GMT

Goa esℂor s agency {{ +919833959165}} esℂor Goa, Goa independent esℂor s { +91-9833959165 }!*!*!*!*! Goa ℂall gi ls, Goa female Esco ts

NVARCHAR(MAX) string gets truncated when displayed in CF

forums_noreply@adobe.com — Mon, 23 Sep 2013 20:01:08 GMT

Hi, all. I have a stored procedure that returns a NVARCHAR(MAX) string of about 35,500 characters. When I execute the stored Procedure using Sql Server Manager, all 35,500 characters appear. However, when I try to display this string or store this in a Cold Fusion Variable on a .cfm page, only the first 32,000 characters get displayed.

Could someone please help me?

Thank you!

How do I get the Quick Select Tool to be more accurate?

forums_noreply@adobe.com — Fri, 08 Nov 2013 23:52:10 GMT

How do I get the Quick Select Tool to be more accurate?

linking dynamic data records to URL

forums_noreply@adobe.com — Sun, 27 Oct 2013 06:14:39 GMT

I created a record set then use the record the record set to create a dynamic data to display all the records of that table from the database.

I want to know how to link each record from the table to different URL when displaying

I have like five fields in the the table i wan to use the name of each record as a link to anothe different url'Thanks

Remote database connection error

forums_noreply@adobe.com — Sat, 26 Oct 2013 18:40:26 GMT

I have at least 10 sites set up on the same server, using the same settings and one site is giving me the error that the testing server is not mapped to mysite.com/_mmServerScripts/MMHTTPDB.php

I will call the problem site siteX

If I remove the testing server completely I get an unidentified error therefore something is communicating since it knows the difference is I have the remote server set up or not.

I can connect to ftp files just fine. I can also connect to the database using navicat.

I am testing on the live server NOT local.

I changed the ftp info to another site that IS working just to see it if would connect to the database using another sites FTP and I could succesfully connect siteX's database using the other sites FTP credentials.

Database not able to connect via ftp

forums_noreply@adobe.com — Mon, 14 Oct 2013 13:18:27 GMT

While working on various feature with adobe the database access suddenly couldn't connect, I've seen same issue on other sites such as http://stackoverflow.com http://moverstovirginia.com http://utteraccess.com.

any solution?

Trouble creating mySQL tables

forums_noreply@adobe.com — Mon, 14 Oct 2013 10:58:00 GMT

I am running CF9 64bit on windows 7. I created the database on mySQL 5.6 server. I created the datasource, theough the CF Admin, for kalendar and it verified. I then tried using the following code to create 2 table, but I recevied an error that just says "Error!" when I tried running the script. I posted the script on mySQL forums and was told the code ran fine. What am I not seeing?

CREATE TABLE tblkalendar (

EventID varchar(100) NOT NULL,

CategoryID int(10) NOT NULL,

IsDeleted tinyint(1) NOT NULL default '0',

IsPublished tinyint(1) NOT NULL default '0',

IsFeatured tinyint(1) NOT NULL default '0',

DateTimeCreated timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,

StartDate datetime NOT NULL,

EndDate datetime NOT NULL,

StartTime varchar(50) default NULL,

EndTime varchar(50) default NULL,

ContactPhone varchar(50) default NULL,

ContactName varchar(100) default NULL,

ContactEmail varchar(50) default NULL,

Title varchar(150) NOT NULL,

Location varchar(150) default NULL,

Teaser varchar(350) default NULL,

ExternalURL varchar(500) character set utf8 default NULL,

Description longtext NOT NULL,

PRIMARY KEY (EventID),

KEY IX_tblKalendar (StartDate,EndDate),

KEY FK_tblKalendar_tblKalendarCategories (CategoryID)

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

CREATE TABLE tblkalendarcategories (

CategoryID int(10) NOT NULL auto_increment,

CategoryName varchar(50) NOT NULL,

CategoryBGColor varchar(7) NULL,

CategoryTextColor varchar(7) NULL,

PRIMARY KEY (CategoryID)

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

</cfquery>

How do I change the column name in mySQL when it has a space in it?

forums_noreply@adobe.com — Wed, 09 Oct 2013 20:10:34 GMT

I know I can use the following line to change the column name: alter table tablename change "First Name" (Parenthesis used for clarification only) FirstName varchar (10) ;

my problem is the column name has a space in it, ie: First Name . So mySQL thinks it is changing "First" to "Name" then it hits the name I want it changed to and goes berserk. How can I change this? I can't even delete it. It happened when I imported Microsft SQL into mySQL database.

cfloop create new divs

forums_noreply@adobe.com — Thu, 10 Oct 2013 17:55:23 GMT

I am wanting to know if I can use CFLOOP through a query and if a field is not empty create a new div for each of the database records content. Is this possible or do I need to use just the normal cfoutput?

How to connect Mysql DB via SSH Tunneling in coldfusion

forums_noreply@adobe.com — Wed, 09 Oct 2013 14:14:31 GMT

I am working on a Project where i have to connect to different DB via SSH tunneling in coldfusion.

Can any one help me how to connect it.

Thank you

Santosh

Baffled by date query

forums_noreply@adobe.com — Thu, 26 Sep 2013 15:20:39 GMT

It's been awhile since I've done any CF and I'm baffled by the results I'm getting. I want to select all the records where the date is greater than or equal to today. This is with CF8 and an Access database. There are records for 9/25 thru 9/30. I can't get the record for today to show.

<cfoutput>DateToday: #DateFormat(dateToday,'yyyy-mm-dd')#</cfoutput><br />

<br />

SELECT *

FROM Images

WHERE StartDate >= <cfqueryparam value="#DateToday#" cfsqltype="cf_sql_timestamp" />

</cfquery>

#startdate#<br />

</cfoutput>

DateToday: 2013-09-26

Results:

2013-09-27 00:00:00.0

2013-09-29 00:00:00.0

2013-09-28 00:00:00.0

2013-09-30 00:00:00.0

Furthermore, if I eliminate the GT sign and have "StartDate =" today, there are no results.