Adobe Community : Unanswered Discussions - Database Access

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

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...

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.

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?

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

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)

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?

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 ?

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 ?

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.

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.

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?

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

reinstall elements

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

can i install elements 12 on more than 1 pc

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?

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

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>

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 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.

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.

How do we set up an encrypted connection with Oracle?

forums_noreply@adobe.com — Tue, 24 Sep 2013 17:18:01 GMT

We have CF7 and CF8 servers that connects to an Oracle 11g database. We would like to set up an encrypted connection between the servers. Where do we enter the parameters to tell CF7 and CF8 to use an encrypted connection using the Oracle JDBC database driver?

Mark R.

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!

cfselect passing mutiple field values to database

forums_noreply@adobe.com — Wed, 04 Sep 2013 23:06:35 GMT

I have a table that lists a class schedule and a table for people who register for a class. I use a query to populate the cfselect drop-down. My question is: Can I pass fields from the session query into the registration table when the form submits??? Thank you:)

SELECT Class, date1, date2, location, message

from mobilitySchedule

where dropDate >= Now()

order by ID desc

</cfquery>

When a user selects a class I want the location and message fields submitted to the database when the form is submitted. Right now only the class selected is submitted. Is this possible? I am beg - int in coldfusion. Thank you

<---form select--->

<label for="name">SESSION:</label>

<option selected="selected">Select a class</option>

<option value="#Class#">#Class# </option>

</cfoutput>

</cfselect>

Creating a COM object with CF9 32-bit on Windows Server 2008 R2 64-bit machine

forums_noreply@adobe.com — Sat, 24 Aug 2013 17:02:46 GMT

I'm using a 32-bit version of CF9 and it's installed on a Windows Server 2008 R2 machine (64-bit). The problem I'm running into is that it won't allow me to create a COM object - it gives me the error, "no ntvinv in java.library.path null" when I try to run,

Then when I run it a 2nd time, I get "An exception occurred when instantiating a COM object. The cause of this exception was that: java.lang.RuntimeException: Can not use native code: Initialisation failed."

Can you help me?

mySQL on cf9. need mysql-connector-java-gpl-5.1.2?.jar

forums_noreply@adobe.com — Sat, 17 Aug 2013 09:12:23 GMT

does anybody have a raw copy of mysql-connector-java-gpl-5.1.22.jar file.

can be 5.1.22 to 5.1.26

i have cf 9 and msSQL and they won't work together without it.

i try to install with .msi file and nothing happens..

please send to old.dog.ster69@gmail.com

tnx in advance

Inserting datetime using cfqueryparam in a SQL_Server database.

forums_noreply@adobe.com — Thu, 08 Aug 2013 00:12:36 GMT

Yields the error:

[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC SQL Server Driver][SQL Server]Conversion failed when converting datetime from character string.

I have also tried:

and numerous other variations to no avail.

BUT

Inserting:

#NOW()#

Improve Poor Performace with SQL 8 database

forums_noreply@adobe.com — Wed, 10 Jul 2013 01:48:04 GMT

I just migrated my last MS Access database over to SQL Server 8 database.

I have tables with 100-20,000 rows in them.

My question is what can I do to improve performance (page load time)?

I have pages that are taking 10 seconds to load that took 2 seconds with Access...I expected improvement with MSSQL.

I have indexed tables etc...

Is there something in the CF code I need to modify also.

I am using CF9

Performing ORM and non-ORM transactions in one request.

forums_noreply@adobe.com — Mon, 10 Jun 2013 18:56:09 GMT

During the processing of a request, we need to perform an ORM statement and a non-ORM cftransaction on 2 different data sources.

Example:

# Note, 'someObject' is a persistent CFC with a datasource attribute of 'DSN1'.

</cftransaction>

INSERT INTO ...

</cfquery>

</cftransaction>

Whenever we hit the 2nd cftranaction block, we get the following error:

Message=A transaction cannot be started on more than one datasource.

This works in CF 9.0.1, but fails on CF 9.0.1 HF3, CF 9.0.2, and on CF 10.

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?

call from same DB, different fields

forums_noreply@adobe.com — Tue, 28 May 2013 14:46:08 GMT

The subject may seem confusing, but it is very simple really. I am new to CF and I am trying to utilize the same DB, but call different values based on where the content is on the page. I have found a way for it to work, but it seems clumsy and extraneous at best. This is the way I have found to do it:

SELECT gameID, gameName, gameDev, gameYear, gameConsole

FROM tblGames

WHERE gameID = 25

</cfquery>

SELECT gameID, gameName, gameDev, gameYear, gameConsole

FROM tblGames

WHERE gameID = 24

</cfquery>

SELECT gameID, gameName, gameDev, gameYear, gameConsole

FROM tblGames

WHERE gameID = 23

</cfquery>

......

<div class="showcaseText"><p><h1>#gameID#. #gameName#</h1></p></div>

<table>

<tr>

<td>Developer:</td><td>#gameDev#</td>

</tr>

<tr>

<td>Dev Year:</td><td>#gameYear#</td>

</tr>

<tr>

<td>Console:</td><td>#gameConsole#</td>

</tr>

</table>

</cfoutput>

	<cfoutput query="getGame24">
	<div class="showcaseText"><p><h1>#gameID#. #gameName#</h1></p></div>
	<table>
	<tr>
	<td>Developer:</td><td>#gameDev#</td>
	</tr>
	<tr>
	<td>Dev Year:</td><td>#gameYear#</td>
	</tr>
	<tr>
	<td>Console:</td><td>#gameConsole#</td>
	</tr>
	</table>

...you get the idea..

I am wondering if there is a better way ( a cfloop perhaps) that would cut down on the amount of code and the multiple queries to the DB based on wanting to pull just that specific ID for a specific table. Thanks in advance!

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

SQL Server 2012 Enterprise R2 CF Issue

forums_noreply@adobe.com — Mon, 29 Apr 2013 14:38:12 GMT

Installed SQL 2012 a few weks ago and finally have it running several scripts. I have a CF developer that is getting this error:

Connection verification failed for data source: orgs
java.sql.SQLInvalidAuthorizationSpecException: [Macromedia][SQLServer JDBC Driver][SQLServer]Login failed for user 'XXXX'.
The root cause was that: java.sql.SQLInvalidAuthorizationSpecException: [Macromedia][SQLServer JDBC Driver][SQLServer]Login failed for user 'XXXX'

Replaced userame with 'XXXX'

I have read some of the posts on SQL 2008 and was hoping there was a solution that could fix this error.

I have gone so far as to make the user a full admin in SQL, I'll back these rights down once I can get connected, that has to be first.

Any help would be appreciated.

pass grid row values to a form

forums_noreply@adobe.com — Thu, 18 Apr 2013 21:30:24 GMT

New to grids.--- Can you select a row in a grid and pass those field values to a registration form? or use an href in each row to pass field values to an action page containing a fom? Thank you --- jim

Set up FileMaker DSN is Cold Fusion administrator

forums_noreply@adobe.com — Thu, 11 Apr 2013 15:49:38 GMT

I am trying to set up a dsn to filemaker pro 11 database in the cf administrator.

I am at the Datasources > Other screen

and there are questions there that I know I dont have answered correctly.

Here is the error message I get.

"No suitable driver available for xxxx, please check the driver setting in resources file, error"

I am using CF9.

I have already successsfully setup the dsn in the 32bit ODBC Data Source administrator and successsfully connected to the Filemaker Server.

But to use it in CF pages I need to set it up inthe CF administrator, Right?