Hi there,
I'm trying to write a VBS that accesses a local database on my system
(personal project).
I'm running Windows XP 64-bit with Access XP. Every time I try to
access the database on the machine, I get the following error:
"Provider is not specified and there is no designated default
provider."
The code itself is correct because I tried the exact same code on a
Windows 2000 box and it worked fine.
If I go into the ODBC Data Source Administrator, I see three User Data
Sources listed under the User DSN tab, including the MS Access driver.
But if I look under Drivers, I only see the SQL Server driver. In
addition, if I click the "Configure" button after selecting the Access
driver using User DSN, I see the following two errors:
"The setup routines for the Microsoft Access Driver (*.mdb) ODBC driver
could not be found. Please reinstall the driver."
"Component not found in the registry."
So I'm assuming from this that the driver wasn't configured right
somewhere along the way. I just can't seem to find where I'd configure
it.
The really weird thing is that I'm running IIS on the same box, with
development websites running Access databases in some form or fashion,
and they run fine off the OLE Jet driver (which I had to configure for
32-bit compatibility.) So from this, I'm guessing I somehow need to
use some form of 32-bit compatibility for the Access driver itself.
But I don't know where I'm supposed to look.
I guess my question is: where exactly is the MDB ODBC driver, and how
would I install/configure it?
Thanks.
Adam http://www.searchenginefriendlylayouts.com 6  13371 
How about trying an mdac reinstall: http://www.microsoft.com/downloads/d...7-185d0506396c
-t
SEFL ha scritto:
Hi there,
I'm trying to write a VBS that accesses a local database on my system
(personal project).
I'm running Windows XP 64-bit with Access XP. Every time I try to
access the database on the machine, I get the following error:
"Provider is not specified and there is no designated default
provider."
The code itself is correct because I tried the exact same code on a
Windows 2000 box and it worked fine.
If I go into the ODBC Data Source Administrator, I see three User Data
Sources listed under the User DSN tab, including the MS Access driver.
But if I look under Drivers, I only see the SQL Server driver. In
addition, if I click the "Configure" button after selecting the Access
driver using User DSN, I see the following two errors:
"The setup routines for the Microsoft Access Driver (*.mdb) ODBC driver
could not be found. Please reinstall the driver."
"Component not found in the registry."
So I'm assuming from this that the driver wasn't configured right
somewhere along the way. I just can't seem to find where I'd configure
it.
The really weird thing is that I'm running IIS on the same box, with
development websites running Access databases in some form or fashion,
and they run fine off the OLE Jet driver (which I had to configure for
32-bit compatibility.) So from this, I'm guessing I somehow need to
use some form of 32-bit compatibility for the Access driver itself.
But I don't know where I'm supposed to look.
I guess my question is: where exactly is the MDB ODBC driver, and how
would I install/configure it?
Thanks.
Adam
http://www.searchenginefriendlylayouts.com
Thanks, dude. But no luck. Same error. to************* *@uniroma1.it wrote:
How about trying an mdac reinstall:
http://www.microsoft.com/downloads/d...7-185d0506396c
-t
SEFL ha scritto:
Hi there,
I'm trying to write a VBS that accesses a local database on my system
(personal project).
I'm running Windows XP 64-bit with Access XP. Every time I try to
access the database on the machine, I get the following error:
"Provider is not specified and there is no designated default
provider."
The code itself is correct because I tried the exact same code on a
Windows 2000 box and it worked fine.
If I go into the ODBC Data Source Administrator, I see three User Data
Sources listed under the User DSN tab, including the MS Access driver.
But if I look under Drivers, I only see the SQL Server driver. In
addition, if I click the "Configure" button after selecting the Access
driver using User DSN, I see the following two errors:
"The setup routines for the Microsoft Access Driver (*.mdb) ODBC driver
could not be found. Please reinstall the driver."
"Component not found in the registry."
So I'm assuming from this that the driver wasn't configured right
somewhere along the way. I just can't seem to find where I'd configure
it.
The really weird thing is that I'm running IIS on the same box, with
development websites running Access databases in some form or fashion,
and they run fine off the OLE Jet driver (which I had to configure for
32-bit compatibility.) So from this, I'm guessing I somehow need to
use some form of 32-bit compatibility for the Access driver itself.
But I don't know where I'm supposed to look.
I guess my question is: where exactly is the MDB ODBC driver, and how
would I install/configure it?
Thanks.
Adam
http://www.searchenginefriendlylayouts.com
Hmmm...
Dont' know if this is the right directionto look, but there seems that
a 64bit version of MDAC 2.8 exists included in Windows 2003 (xp does
not seem to mentioned), check out for instance: http://paulfallon.com/2004/08/16/MDA...t+Windows.aspx
-t
SEFL ha scritto:
Thanks, dude. But no luck. Same error.
to************* *@uniroma1.it wrote:
How about trying an mdac reinstall:
http://www.microsoft.com/downloads/d...7-185d0506396c
-t
SEFL ha scritto:
Hi there,
>
I'm trying to write a VBS that accesses a local database on my system
(personal project).
>
I'm running Windows XP 64-bit with Access XP. Every time I try to
access the database on the machine, I get the following error:
>
"Provider is not specified and there is no designated default
provider."
>
The code itself is correct because I tried the exact same code on a
Windows 2000 box and it worked fine.
>
If I go into the ODBC Data Source Administrator, I see three User Data
Sources listed under the User DSN tab, including the MS Access driver.
But if I look under Drivers, I only see the SQL Server driver. In
addition, if I click the "Configure" button after selecting the Access
driver using User DSN, I see the following two errors:
>
"The setup routines for the Microsoft Access Driver (*.mdb) ODBC driver
could not be found. Please reinstall the driver."
>
"Component not found in the registry."
>
So I'm assuming from this that the driver wasn't configured right
somewhere along the way. I just can't seem to find where I'd configure
it.
>
The really weird thing is that I'm running IIS on the same box, with
development websites running Access databases in some form or fashion,
and they run fine off the OLE Jet driver (which I had to configure for
32-bit compatibility.) So from this, I'm guessing I somehow need to
use some form of 32-bit compatibility for the Access driver itself.
But I don't know where I'm supposed to look.
>
I guess my question is: where exactly is the MDB ODBC driver, and how
would I install/configure it?
>
Thanks.
>
>
>
Adam
http://www.searchenginefriendlylayouts.com
Unfortunately, they're referring to Windows Server 2003 so that doesn't
work either. :( to************* *@uniroma1.it wrote:
Hmmm...
Dont' know if this is the right directionto look, but there seems that
a 64bit version of MDAC 2.8 exists included in Windows 2003 (xp does
not seem to mentioned), check out for instance:
http://paulfallon.com/2004/08/16/MDA...t+Windows.aspx
-t
SEFL ha scritto:
Thanks, dude. But no luck. Same error.
to************* *@uniroma1.it wrote:
How about trying an mdac reinstall:
>
http://www.microsoft.com/downloads/d...7-185d0506396c
>
-t
>
SEFL ha scritto:
>
Hi there,
I'm trying to write a VBS that accesses a local database on my system
(personal project).
I'm running Windows XP 64-bit with Access XP. Every time I try to
access the database on the machine, I get the following error:
"Provider is not specified and there is no designated default
provider."
The code itself is correct because I tried the exact same code on a
Windows 2000 box and it worked fine.
If I go into the ODBC Data Source Administrator, I see three User Data
Sources listed under the User DSN tab, including the MS Access driver.
But if I look under Drivers, I only see the SQL Server driver. In
addition, if I click the "Configure" button after selecting the Access
driver using User DSN, I see the following two errors:
"The setup routines for the Microsoft Access Driver (*.mdb) ODBC driver
could not be found. Please reinstall the driver."
"Component not found in the registry."
So I'm assuming from this that the driver wasn't configured right
somewhere along the way. I just can't seem to find where I'd configure
it.
The really weird thing is that I'm running IIS on the same box, with
development websites running Access databases in some form or fashion,
and they run fine off the OLE Jet driver (which I had to configure for
32-bit compatibility.) So from this, I'm guessing I somehow need to
use some form of 32-bit compatibility for the Access driver itself.
But I don't know where I'm supposed to look.
I guess my question is: where exactly is the MDB ODBC driver, and how
would I install/configure it?
Thanks.
Adam
http://www.searchenginefriendlylayouts.com
A few more places where to take a look: http://msdn.microsoft.com/library/de...nstall.asp?fra http://msdn.microsoft.com/library/de...dacroadmap.asp
Jet 4.0 Service Pack 8 http://download.microsoft.com/downlo...58-x86-enu.exe
hope you have some luck (let me know how you solve it).
-tom
SEFL ha scritto:
Unfortunately, they're referring to Windows Server 2003 so that doesn't
work either. :(
to************* *@uniroma1.it wrote:
Hmmm...
Dont' know if this is the right directionto look, but there seems that
a 64bit version of MDAC 2.8 exists included in Windows 2003 (xp does
not seem to mentioned), check out for instance:
http://paulfallon.com/2004/08/16/MDA...t+Windows.aspx
-t
SEFL ha scritto:
Thanks, dude. But no luck. Same error.
>
to************* *@uniroma1.it wrote:
How about trying an mdac reinstall:
http://www.microsoft.com/downloads/d...7-185d0506396c
-t
SEFL ha scritto:
Hi there,
>
I'm trying to write a VBS that accesses a local database on my system
(personal project).
>
I'm running Windows XP 64-bit with Access XP. Every time I try to
access the database on the machine, I get the following error:
>
"Provider is not specified and there is no designated default
provider."
>
The code itself is correct because I tried the exact same code on a
Windows 2000 box and it worked fine.
>
If I go into the ODBC Data Source Administrator, I see three User Data
Sources listed under the User DSN tab, including the MS Access driver.
But if I look under Drivers, I only see the SQL Server driver. In
addition, if I click the "Configure" button after selecting the Access
driver using User DSN, I see the following two errors:
>
"The setup routines for the Microsoft Access Driver (*.mdb) ODBC driver
could not be found. Please reinstall the driver."
>
"Component not found in the registry."
>
So I'm assuming from this that the driver wasn't configured right
somewhere along the way. I just can't seem to find where I'd configure
it.
>
The really weird thing is that I'm running IIS on the same box, with
development websites running Access databases in some form or fashion,
and they run fine off the OLE Jet driver (which I had to configure for
32-bit compatibility.) So from this, I'm guessing I somehow need to
use some form of 32-bit compatibility for the Access driver itself.
But I don't know where I'm supposed to look.
>
I guess my question is: where exactly is the MDB ODBC driver, and how
would I install/configure it?
>
Thanks.
>
>
>
Adam
http://www.searchenginefriendlylayouts.com
I don't think there is a 64 bit Access ODBC driver, for
use with 64 bit ODBC. I think you would have to uninstall
64 bit ODBC, and install a copy of 32 bit ODBC. 16 bit
ODBC was a bit simpler, because it could co-exist with
32 bit ODBC, but I don't think that's true for 64 and 32.
Also, ODBC comes with windows now, so there is not a
separate install for 32 bit ODBC, but I think I saw an
article about how to copy it from Win 32?
(david)
"SEFL" <ad**@searcheng inefriendlylayo uts.comwrote in message
news:11******** **************@ s13g2000cwa.goo glegroups.com.. .
Hi there,
I'm trying to write a VBS that accesses a local database on my system
(personal project).
I'm running Windows XP 64-bit with Access XP. Every time I try to
access the database on the machine, I get the following error:
"Provider is not specified and there is no designated default
provider."
The code itself is correct because I tried the exact same code on a
Windows 2000 box and it worked fine.
If I go into the ODBC Data Source Administrator, I see three User Data
Sources listed under the User DSN tab, including the MS Access driver.
But if I look under Drivers, I only see the SQL Server driver. In
addition, if I click the "Configure" button after selecting the Access
driver using User DSN, I see the following two errors:
"The setup routines for the Microsoft Access Driver (*.mdb) ODBC driver
could not be found. Please reinstall the driver."
"Component not found in the registry."
So I'm assuming from this that the driver wasn't configured right
somewhere along the way. I just can't seem to find where I'd configure
it.
The really weird thing is that I'm running IIS on the same box, with
development websites running Access databases in some form or fashion,
and they run fine off the OLE Jet driver (which I had to configure for
32-bit compatibility.) So from this, I'm guessing I somehow need to
use some form of 32-bit compatibility for the Access driver itself.
But I don't know where I'm supposed to look.
I guess my question is: where exactly is the MDB ODBC driver, and how
would I install/configure it?
Thanks.
Adam
http://www.searchenginefriendlylayouts.com
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Sergey V |
last post by:
Having following problem
1. Client: ASP application with anonymous access to be running as
DOMAIN\my_user on WinXP
2. Server: DCOM NT Service runs on remote host (W2K Server) under the same
account DOMAIN\my_user
security within server is initialized using
hr = CoInitializeSecurity(&appid, -1, NULL, NULL, 0, 0, 0, EOAC_APPID,
NULL);
|
by: Sean C. |
last post by:
Helpful folks,
Most of my previous experience with DB2 was on s390 mainframe systems
and the optimizer on this platform always seemed very predictable and
consistent. Since moving to a WinNT/UDB 7.2 environment, the choices
the optimizer makes often seem flaky. But this last example really
floored me. I was hoping someone could explain why I get worse
response time when the optimizer uses two indexes, than when it uses
one. Some context:
|
by: dog |
last post by:
I've seen plenty of articles on this topic but none of them have been
able to solve my problem.
I am working with an Access 97 database on an NT4.0 machine, which has
many Access reports.
I want my users to be able to select a report, click on a command
button on a form, which will then automatically create the report as a
pdf file and save it to the user's machine.
I am using Adobe Acrobat (5.0 I think) and have Adobe Distiller as a
|
by: Grasshopper |
last post by:
Hi,
I am automating Access reports to PDF using PDF Writer 6.0. I've
created a DTS package to run the reports and schedule a job to run this
DTS package. If I PC Anywhere into the server on where the job is
running, the job runs sucessfully, PDF files got generated, everything
is good. If I scheduled the job to run at the time that I am not
logged into the server, Access is not able to print to the printer.
The error is pretty...
|
by: Abareblue |
last post by:
I have no clue on how to insert a record into access. here is the whole
thing
using System;
using System.Drawing;
using System.Collections;
using System.ComponentModel;
| | |
by: Clint |
last post by:
Hey all -
I'm having a really confusing problem concerning a web service. Right
now, I have an application that needs to call a web service that does
nothing but return "true" (this will obviously change once the
program's fully built to actually do something, but for testing, it
works).
The only code I added to the service is below:
|
by: CM Manager via DotNetMonster.com |
last post by:
I am very frustrated due to this exception error I am receiving. I've tried
searching numerous user support groups, Microsoft Support Net, Google, etc.
and haven't found exactly my situation. Hopefully someone here can help.
I am just learning VB.NET and purchased the SAM's "Teach Yourself VB.NET
2003 in 21 days' book. I am trying to connect to an Access database I created
locally on my computer per Chapter 16. I originally had it on a...
|
by: freesteel |
last post by:
I have posted about this problem before. SInce then I found a much
better article to help with embedding python in a multithreaded
application:
http://www.linuxjournal.com/article/3641
I found this article very good and it clarified for me what needs
doing. Now I have an example application that almost works, but it is
far from reliable. If I run this several times I get crashes telling me
that the heap is modified after deallocation....
|
by: sammyloo |
last post by:
Hi all,
I'm experiencing a problem using ASP.NET web services to access a
different server with SQL Server 2000 database.
And I get the error of the following
Exception Details: System.Data.SqlClient.SqlException: SQL Server does
not exist or access denied.
|
by: Matt |
last post by:
How would I do this ... I want to set the Windows Scheduler to run the
..bat file which will open an access database at like 2 in the AM. What
code do I need in the .bat file.
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
| | |
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 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 a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| | |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
