Solved

CF data connection error

Posted on 2011-09-27
19
279 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
Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

 

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

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Lync server 2013 or Skype for business Backup Service Error ID 4049 – After File Share Migration
The recent Microsoft changes on update philosophy for Windows pre-10 and their impact on existing WSUS implementations.
This Micro Tutorial will teach you the basics of configuring your computer to improve its speed. It will also teach you how to disable programs that are running in the background simultaneously. This will be demonstrated using Windows 7 operating…
The Task Scheduler is a powerful tool that is built into Windows. It allows you to schedule tasks (actions) on a recurring basis, such as hourly, daily, weekly, monthly, at log on, at startup, on idle, etc. This video Micro Tutorial is a brief intro…

914 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

12 Experts available now in Live!

Get 1:1 Help Now