473,322 Members | 1,241 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

VB6 compiled program accessing Access in W7 64bit sp1

How do I tell the compiler to use the 32 bit ODBC driver when compiling a VB6 program in a 64 bit machine, W7.

When compiling it comes up with several SQL errors but does not offer any other info. When running the program it comes up with a "file not found" error without further info. It appears as though it is using the VB6 - 64 bit sql connection rather than the odbc connection.

I have a former VB 6 compiled program that has been running for years in XP. I have recompiled this program in VB6 running on W7 sp1, 64 bit machine.

The program needs to access an Access datbase. The process works just fine in the VB Enviornment but when compiled it produces an error (SQL error) which leads me to believe the compiler is using the 64 bit ODBC driver not the 32 bit driver I loaded into the c:\windows\system32\ folder. Conversly the program running in the enviornment apparently is using the 32bit driver and access the database correctly. When running compiled it seems to be looking in the office directory??

I have downloaded the ODBCJT32.dll to the c:\windows\system32\ folder.

Any comment would be appreciated
Jun 21 '12 #1
0 1790

Sign in to post your reply or Sign up for a free account.

Similar topics

6
by: Earl Teigrob | last post by:
I am writing an application that dynamically loads user controls at run time based on user options. I would like to give my users the ability to build their own user controls and add them to my...
8
by: Samik Raychaudhuri | last post by:
Hello, I am trying to run a perl CGI program for accessing a database. The program runs fine from command prompt, producing expected output. But it gives errors while running as CGI. ---------...
3
by: Dave | last post by:
I've seen at least one article on this: How to access classes, etc. managed-to-unmanaged. I can't find it. Any tricks or pointers? I guess the class name won't get munged but I'm not clear about...
3
by: mehmetmutigozel | last post by:
i have a compiled program named m.exe. when i execute it asks me to enter a parameter like "me.dat". the coder didn't manage the argv for this program and i only have the executable. is there a...
1
by: pete | last post by:
I've created a program in VB Express 2005 that imports a 150 megs text file into a MySQL database. The problem is when I run the compiled program outside of the VB Express IDE it takes more than...
2
by: rachana | last post by:
Hi, I am trying to deploy a asp.net website developed using Visual Studio 2005 on server. Application works fine on development machine, but when trying to run on server I get following error...
3
by: watson128 | last post by:
I have a program that interrogates and modifies an Access database. When I run this program from the VB editor it runs fine. When I make the exe file and run that it crashes saying that the "Object...
3
by: Nathan Sokalski | last post by:
When I attempt to access a Microsoft Access database from my website, I recieve the following error: Server Error in '/' Application....
1
by: Laurence | last post by:
Hi there, I am beginning to code C program to access ibm db2 database. Could somebody show me the way how to do the first step for self-learning? Thank you very much, Laurence
3
by: John Dann | last post by:
We've got a VB2005 program written some time back that we're trying to do some maintenance on still from within VB2005 but now running on a Vista Business PC (which I think may be relevant to the...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.