Solved

CF data connection error

Posted on 2011-09-27
19
274 Views
Last Modified: 2012-06-27
I am trying to setup my data source on a new computer through CF.  I get the error you see in the image.  I made sure my Java runtime is up to date.  Anybody have any ideas?

Thanks,
John Error
0
Comment
Question by:JohnMac328
  • 9
  • 8
  • 2
19 Comments
 
LVL 19

Expert Comment

by:erikTsomik
ID: 36710829
0
 

Author Comment

by:JohnMac328
ID: 36710948
Tried both suggestions - no luck
0
 
LVL 19

Expert Comment

by:erikTsomik
ID: 36710958
did you restart a coldfusion afterwards
0
 

Author Comment

by:JohnMac328
ID: 36710962
Yes
0
 
LVL 52

Expert Comment

by:_agx_
ID: 36710971
As mentioned, enabling RDS will do the trick. But ... you don't really need to use the applet. Simply enter the path to your file manually.  That works fine.
0
 
LVL 52

Expert Comment

by:_agx_
ID: 36710977
   >> As mentioned, enabling RDS will do the trick.

FYI they don't advise doing that on prod servers. My recommendation is enter the path manually.
0
 

Author Comment

by:JohnMac328
ID: 36710979
I tried that - I found this which I will try now - seems to be a problem with access 2010 64bit

http://www.cfexecute.com/post/access-dsns-in-64bit-coldfusion/
0
 
LVL 52

Expert Comment

by:_agx_
ID: 36710990
Oh, yeah.  Connecting to Access 2010 64bit is a totally different problem.
0
 

Author Comment

by:JohnMac328
ID: 36711039
It took the manual setting but still has problems.  I setup the DSN with Access drivers like always - I am not liking 64bit

Error Executing Database Query.  
[Macromedia][SequeLink JDBC Driver][ODBC Socket]internal error: The specified DSN contains an architecture mismatch between the Driver and Application  
0
Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

 

Author Comment

by:JohnMac328
ID: 36711043
I guess I better get the IIS working first - it has a problem with asp pages also
0
 
LVL 52

Expert Comment

by:_agx_
ID: 36711076
  > I am not liking 64bit

It is a pain at first ... learning all the quirks and tricks.  Unfortunately I've never set up 2010 64bit. So I can't help you there.
0
 

Author Comment

by:JohnMac328
ID: 36711092
No problem agx - what is driving me crazy is I have everything at home working fine for over a year - Win 7 - CF9 all 64bit and working fine.  Same thing at work and it's a mess - we just installed new computers yesterday.
0
 
LVL 52

Expert Comment

by:_agx_
ID: 36711408
Ugh.  I hate when that happens.  I had something similar all last week. I was about ready to toss the computer in the trash at one point ;-)
0
 

Author Comment

by:JohnMac328
ID: 36711425
I hear ya - I found this and was very hopeful but the same thing

http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=13255
0
 
LVL 52

Accepted Solution

by:
_agx_ earned 500 total points
ID: 36711494
So what setup do you have now?  You deleted all the old dsn's and created a new one with the 32bit odbc tool? Does it even verify through odbc?

      ie C:\Windows\SysWOW64\odbcad32.exe
0
 
LVL 52

Expert Comment

by:_agx_
ID: 36711546
Hm... I didn't realize there's both 32bit and 64bit versions of Access 2010...  Which are you using?
http://www.coldfusionmuse.com/index.cfm/2010/12/31/Access.on.64bit.ColdFusion
0
 

Author Closing Comment

by:JohnMac328
ID: 36711550
New server and new computers - too much too fast.  Using the 32bit from your link and setting up the DSN through there gets the manual connection to work through CF - now on to getting asp pages to work through IIS 7 -

Thanks again
0
 

Author Comment

by:JohnMac328
ID: 36711556
It is Office 2010 64bit but your link made it work
0
 
LVL 52

Expert Comment

by:_agx_
ID: 36713482
Ok. I was thinking it would be backward compatible, but wasn't sure. So thanks for satisfying my curiousity :)
0

Featured Post

Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

Join & Write a Comment

Recently while working on a project I got a very annoying cfdocument has no body error message. I had never seen this error before. So I checked the code. The code was pretty simple; it was Just showing me the cfdocumnt tag and inside that tag a …
If you don't have the right permissions set for your WordPress location in IIS, you won't be able to perform automatic updates. Here's how to fix the problem.
This Micro Tutorial will give you a introduction in two parts how to utilize Windows Live Movie Maker to its maximum editing capability. This will be demonstrated using Windows Live Movie Maker on Windows 7 operating system.
The viewer will learn how to successfully download and install the SARDU utility on Windows 7, without downloading adware.

758 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now