473,732 Members | 2,083 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

problems with connecting to Access dB

I seem to be having a lot of problems with running/developing web site on my
XP Professional OS.

I have a simple web site (using ASP/VB), which retrieves information from an
Access 2000 database. I have MS Access XP installed on my machine.

When I open the database in Access and try to open up a page, I get this
error:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver] Could not use '(unknown)'; file
already in use.

After this error, I have to restart my machine, and as long as I don't open
the database again (in Access) it works fine.

If I take the same web site on a NT machine, running IIS4, it works like a
charm, even if I open the database in Access.

I found these articles on support.Microso ft.com and tried to apply the
solution, mentioned in it; but, no success:
http://support.microsoft.com/default.aspx?kbid=315456
http://support.microsoft.com/default...b;en-us;295297

the second article talks about giving permissions to a user. I gave
permissions to IUSER_MACHINE, and no luck.

I am using a DSNless connection and the database is local to the machine

Here's what I sue in ASP to connect to the database

set conn = Server.CreateOb ject("ADODB.Con nection")
set rs=server.creat eobject("ADODB. Recordset")
mapPath="DBQ=" & server.mappath (db_path+db_nam e)
dbconnstr="Driv er={Microsoft Access Driver (*.mdb)};" & mapPath
conn.open dbconnstr

Please help, I have to deliver this site for a demo, by tomorrow, for a
client.

--
Asim Chowdhry
Recursive Consulting
http://www.e-recursive.com
Nov 12 '05 #1
0 1701

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
2140
by: Brad Pears | last post by:
Our graphic designer is developing our new company website. We have switched providers and currently she is working on the new website which currently ressides on the new providers server as they support the ASP development environment. Their server is a Win2K3 server. She is writing an ASP module to connect to an MS Access 2000 database and is having problems connecting. In this database there is only one table. She has tried many...
0
2062
by: maddunr | last post by:
Hi, I just installed PHP 4.3.9, MySQL 4.0.2 and PHPMyAdmin 2.6.0-pl3 on our intranet server (Win2k3 running IIS). I also have a similar setup on my local machine (http://localhost/phpmyadmin). Everything seems normal when I work on the server machine (also known as web-nt with IP xxx.xxx.xx.xx), but when I try connecting to the MySQL database on the server from my local machine (http://web-nt/phpmyadmin), two things happen:
1
1536
by: Adi Sapir | last post by:
Hi, We're currently planning to migrate from SQL Auth to Windows Auth. Personally, I do not have too much experience with Windows authentication but have heard that there are some problems when working with it. The problems I've already ran into were: "Cannot Generate SSPI Context" (which I've already resolved), and a more serious problem which prevents me from connecting to a linked server. (double hop, see...
3
6914
by: Roy Souther | last post by:
Trying to get the unixODBC to work connecting to an IBM DB2 UDB V8.1. The DB2 server is running on Red Hat 8 and is tested and confirmed to be serving connections to Windows 98 clients using the Accpac 5.1 client program (I would like to find an OpenSource generic ODBC program for Wiindows that can do simple SQL). An Accpac database was installed and the Win32 ODBC connection is working. Trying to connect a Linux client via unixODBC I...
9
17028
by: mcbill20 | last post by:
Hello all. I just installed Oracle 10g developer tools on a machine running XP Pro and Office XP. Before this I had just the Oracle 9 client installed. I the previous configuration, I was able to access any of the Oracle tables on another machine but now I am having problems. Unfortunately, I don't remember the correct syntax for the ODBC connect string and I am hoping that is my whole problem. I am trying to connect to an Oracle 9...
4
1799
by: CodeImp | last post by:
A simple app I quickly wrote to try getting info from a database. Here is the first part of its code. The rest of the code is irellevant. using System; using System.Data; using System.Data.SqlClient; using System.Threading; namespace TestSQL { class Class1
13
4334
by: Joner | last post by:
Hello, I'm having trouble with a little programme of mine where I connect to an access database. It seems to connect fine, and disconnect fine, but then after it won't reconnect, I get the error "operation is not allowed when object is open" so I take out the line of code: BookDetails.Connection1.Open and it comes up with the error "operation is not allowed when object
3
4364
by: Mike | last post by:
I have transferred the data from Access to MySQL using MySQL's tool. The transfer worked great and saved me a lot of time (thanks MySQL). Now I'm trying to get the Access database, or a new access database, to talk across ODBC and see the data. I created the DSN through the control panel and it works without error. How do I setup Access so it can see the data. The data
5
1572
by: bodhiSoma | last post by:
Hi all. Can't seem to get PHP to play nice with MySQL. First I logged into MySQL, created the db, switched to it and then granted (what I thought were) correct privileges: -------- Macintosh-7:~ jason$ /usr/local/mysql/bin/mysql -u root mysqlcreate database wes;
0
8773
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,...
0
9306
jinu1996
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...
1
9234
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,...
0
9180
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
1
6733
isladogs
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...
0
6030
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4805
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
3259
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
3
2177
bsmnconsultancy
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...

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.