Products

Evoq Content Overview Content Creation Workflow Asset Management Mobile Responsive Personalization Content Analytics SEO Integrations Security Website PerformanceEvoq Engage Overview Community Management  Dashboard  Analytics  Member Profile Gamification Advocate Marketing Community Engagement  Ideas  Answers  Discussions  Groups  Wikis  Events Mobile ReadyDNN Support PackagesEvoq: CMS FeaturesEvoq OnDemandCompare DNN's CMS Products

Solutions

Content Management SystemMulti-Channel PublishingDigital MarketingOnline Community ManagementIntranet Software SolutionOur CustomersPrime

Resources

Test DrivesSchedule A DemoDocumentation CenterWebinarsWhite PapersProduct ManualsRequest PricingData SheetsCase StudiesEvoq Preferred Products Content Management Ecommerce Forms Identity Management and Authentication Site Management Social Themes

Partners

DNN Partners Partner Directory Become a DNN Partner Partner Program Overview  Hosting  Implementation  ISV  Training  Competencies

Community

Participate Ask a Question Forums Community Showcase DNN MVP  Program Overview  Lifetime MVPs  Honorary MVPs Subscribe to DNN Digest Advisory Groups  Awareness Advisory Group  Developer Advisory Group  Partner Advisory Group  Technology Advisory GroupLearn Documentation Wiki Community Blog Video Library Project History Development RoadmapDownload DNN Store Language Packs Manuals Nightly BuildsSecurity Policies Security Center

Blog

About

News Press Releases News Coverage Press KitCareersContact DNN

QA

Ideas Test

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen
HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsReportsReportsExcel ODBC on x64 Excel ODBC on x64
Previous
 
Next
New Post
4/21/2009 4:24 PM
 
Eric Hickman

Joined: 5/23/2008
Posts: 3

Howdy all!

I'm pretty new to this ODBC thing.  I have been running DNN for a while now on a Win2003 x86 box.  I am migrating the site to a Win2003 x64 box with DNN 5.  I am using the reports module to pull data from an Excel file to produce a phone list kinda thing.  The Excel ODBC driver does not appear as an option in 64bit.  You CAN however configure the 32bit version by browsing to the SysWOW64\odbcad32.exe file.  The problem is that DNN seems to only be looking at the x64 version and not the 32bit.  Hope I am making some sense.....

Has anyone seen this or have any ideas?

Thank you for any help you can provide.

Eric

 

 
 
New Post
4/22/2009 2:22 AM
 
Andrew Nurse

Joined: 4/12/2004
Posts: 433

The most common issue with all 64-bit Applications (not just DNN) is that all of the libraries used by a single Process (such as ODBC drivers) must be 64-bit as well.  .Net can translate the MSIL for .Net libraries into either 32-bit or 64-bit code, but it can't do the same for any unmanaged code you use.  By default, IIS runs all AppPools in a 64-bit process when it's running on 64-bit Windows.

Unfortunately, the only solutions are:

a) Find a purely x64-based solution to this (64-bit ODBC driver, other ADO.Net provider, etc.)

b) Put the DNN app in a 32-bit AppPool (thus negating the benefits of running on x64).  You can change the processor architecture used by an AppPool in the Advanced Settings for the AppPool (in IIS manager).  There's a setting called "Enable 32-Bit Applications" which, if true, causes the whole AppPool to be run in 32-bit mode.

I'm afraid that's all you can do.  Hope that helps a bit.

Andrew Nurse
DotNetNuke Core Team Member and Reports Module Project Lead
Microsoft Certified Professional Developer
 
New Post
4/22/2009 10:17 AM
 
Eric Hickman

Joined: 5/23/2008
Posts: 3

Thank you so much for your reply / help.  I think I'll give the 32-bit thing a try to give me time to find a x64 solution.  Then maybe I can roll back to it then.

Thank you again.

Eric
 
 Page 1 of 1
Previous
 
Next
HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsReportsReportsExcel ODBC on x64 Excel ODBC on x64


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out