[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Urgent: VBscript Error in Windows 2008

Posted on 2011-04-19
8
Medium Priority
?
861 Views
Last Modified: 2012-05-11
Greeting,
I have a vbscript was working fine on windows 2003. It connect to Oracle 10G database and update the records.
After I moved it to Windows 2008, it gives me the following error when I ran it. I created the System DSN alreay on the windows 2008.

Error: [Microsoft][ODBC Driver Driver Manager] The Specified DSN contains an architecture mismatch between the Driver and Application
Code: 80004005
Source Microsoft OLE DB Provider for ODBC Drivers.

Thanks in Advance.

0
Comment
Question by:mrong
  • 5
  • 2
8 Comments
 
LVL 12

Expert Comment

by:serchlop
ID: 35429102
I don't know if your server is x64. But what worked for us was to change the advanced settings for the application pool in IIS7 to enable 32bit apps to true.

Here is some other information could help.

In a 64 bit windows server operating system, there are TWO odbc managers. When you pull up the usual menu for the odbc / dsn system, it is for the 64 bit odbc manager, and 32 bit applications (vb 6.0) will not work using these dsn's.

This is where the 32 bit odbc manager is:

C:\Windows\SysWOW64\odbcad32.exe

I hope you do not have to go through what I and three Microsoft Support engineers had to to figure this out.
0
 
LVL 13

Expert Comment

by:lciprianionut
ID: 35429103
Windows 2008 is x32 or x64 arhitecture? Did you register DSN for both x32 and x64 - http://support.microsoft.com/kb/942976 ?
0
 

Author Comment

by:mrong
ID: 35429140
serchlop:
Yes, It is 64 bit. I did enable 32-bit applications from IIS and modified the odbc from C:\Windows\SysWOW64\odbcad32.exe

Thanks.
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Author Comment

by:mrong
ID: 35429167
lciprianionut:
It is windows 2008 x64. I added system DSN in \Windows\SysWoW64 folder
But I didn't do it in 64 bit folder since the Oracle driver is not visible at there.

Thanks.
0
 
LVL 12

Expert Comment

by:serchlop
ID: 35429183
Have you tryed to install the latest oracle client odbc for Windows 2008. I don't remember exactly how, but I have a similar issue and that's the way we get a solution.
0
 

Author Comment

by:mrong
ID: 35429274
I have another asp page is working and It uses DSN I created in Windows\SysWoW64 folder
So I think the DSN should be fine since the asp working........
0
 

Accepted Solution

by:
mrong earned 0 total points
ID: 35429469
Here is the trick and it works for me.
ran a 32-bit version of the script host from c:\windows\syswow64\cscript.exe
0
 

Author Closing Comment

by:mrong
ID: 35994363
Found the solution to my question
0

Featured Post

Creating Active Directory Users from a Text File

If your organization has a need to mass-create AD user accounts, watch this video to see how its done without the need for scripting or other unnecessary complexities.

Question has a verified solution.

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

When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
With User Account Control (UAC) enabled in Windows 7, one needs to open an elevated Command Prompt in order to run scripts under administrative privileges. Although the elevated Command Prompt accomplishes the task, the question How to run as script…
This tutorial will walk an individual through locating and launching the BEUtility application to properly change the service account username and\or password in situation where it may be necessary or where the password has been inadvertently change…
To efficiently enable the rotation of USB drives for backups, storage pools need to be created. This way no matter which USB drive is installed, the backups will successfully write without any administrative intervention. Multiple USB devices need t…
Suggested Courses

830 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