I got a ASP program in the server, it runs properly . However, As I run the
web siste , click 'login' button.
It return the following errors. It seems can't connect the database, I had
stopped the IIS and run it again, (it still didn't work) , I use visual
foxpro to check the database, everything is fine.
Please help ~~
Technical Information (for support personnel)
a.. Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Visual FoxPro Driver]Cannot open file
u:\cgl\vfpmaster\data\master.dbc.
/cglwebpage/webbook/trackNTracing.asp, line 15
b.. Browser Type:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0; .NET CLR 1.1.4322)
c.. Page:
POST 38 bytes to /cglwebpage/webbook/trackNTracing.asp
d.. POST Data:
shcode=&password=&Submit=Login&Login=Y
e.. Time:
Saturday, January 31, 2004, 11:07:55 AM
f.. More information:
Microsoft Support
--
Thanks For Your kind Attention.
Best Regards,
Miss. Agnes Cheng 6 2861
"Agnes" <ag***@dynamictech.com.hk> wrote in message
news:eQ**************@TK2MSFTNGP11.phx.gbl... I got a ASP program in the server, it runs properly . However, As I run
the web siste , click 'login' button.
It return the following errors. It seems can't connect the database, I had stopped the IIS and run it again, (it still didn't work) , I use visual foxpro to check the database, everything is fine.
Please help ~~
Technical Information (for support personnel)
a.. Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [Microsoft][ODBC Visual FoxPro Driver]Cannot open file u:\cgl\vfpmaster\data\master.dbc. /cglwebpage/webbook/trackNTracing.asp, line 15
b.. Browser Type: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0; .NET CLR 1.1.4322)
c.. Page: POST 38 bytes to /cglwebpage/webbook/trackNTracing.asp
d.. POST Data: shcode=&password=&Submit=Login&Login=Y
e.. Time: Saturday, January 31, 2004, 11:07:55 AM
f.. More information: Microsoft Support -- Thanks For Your kind Attention.
Best Regards,
Miss. Agnes Cheng
Probably a permissions issue. Ensure the anonymous user (Iusr_machinename)
has full control permissions in u:\cgl\vfpmaster\data\master.dbc, once you
have got it working you can experiment removing one permission at a time to
see what you really need.
--
John Blessing http://www.LbeHelpdesk.com - Help Desk software priced to suit all
businesses http://www.free-helpdesk.com - Completely free help desk software ! http://www.lbetoolbox.com - Remove Duplicates from MS Outlook
Is U: a mapped drive letter or a physical drive on the server?
If it is mapped then the IUSR account does not have that mapping and you
need to use the UNC path (\\<servername>\volume\...>
--
Mark Schupp
Head of Development
Integrity eLearning www.ielearning.com
"Agnes" <ag***@dynamictech.com.hk> wrote in message
news:eQ**************@TK2MSFTNGP11.phx.gbl... I got a ASP program in the server, it runs properly . However, As I run
the web siste , click 'login' button.
It return the following errors. It seems can't connect the database, I had stopped the IIS and run it again, (it still didn't work) , I use visual foxpro to check the database, everything is fine.
Please help ~~
Technical Information (for support personnel)
a.. Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [Microsoft][ODBC Visual FoxPro Driver]Cannot open file u:\cgl\vfpmaster\data\master.dbc. /cglwebpage/webbook/trackNTracing.asp, line 15
b.. Browser Type: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0; .NET CLR 1.1.4322)
c.. Page: POST 38 bytes to /cglwebpage/webbook/trackNTracing.asp
d.. POST Data: shcode=&password=&Submit=Login&Login=Y
e.. Time: Saturday, January 31, 2004, 11:07:55 AM
f.. More information: Microsoft Support -- Thanks For Your kind Attention.
Best Regards,
Miss. Agnes Cheng
Hi,
I have a related problem. Using IIS 5.1 on Windows XP Home Edition.
I'm putting up the website <a
href="http://bugsonline.sourceforge.net/">bugsonline</a> bug tracking
freeware.
<br><br>
The site is in asp and uses an Access mdb file as the database.
I have configured the ODBC DSN correctly. However when the first page
tries to access the database for updating I get the error:
<br>
Error Type:
Provider (0x80004005)
Unspecified error
/html/login.asp, line 33
<br>
In the source code (lines 32 and 33):
32> Set Conn = Server.CreateObject("ADODB.Connection")
33> Conn.Open "bugs", , ""
The problem is that sometimes the page gives an error at line 33
and sometimes it goes further (I can see the db being updated when
I open the mdb via Access) and fails at another DB call on line 70:
69> Set Conn = Server.CreateObject("ADODB.Connection")
70> Conn.Open "bugs", , ""
According to one suggestion I opened the file in Access and deselected
the "record level locking" from Tools > Options > Advanced.
Does anyone have an idea on how to get over this?
Regards,
~ amol
"Amol" <de*****@ececs.uc.edu> wrote in message
news:51*************************@posting.google.co m... Hi,
I have a related problem. Using IIS 5.1 on Windows XP Home Edition. I'm putting up the website <a href="http://bugsonline.sourceforge.net/">bugsonline</a> bug tracking freeware. <br><br> The site is in asp and uses an Access mdb file as the database. I have configured the ODBC DSN correctly. However when the first page tries to access the database for updating I get the error: <br> Error Type: Provider (0x80004005) Unspecified error /html/login.asp, line 33 <br>
In the source code (lines 32 and 33): 32> Set Conn = Server.CreateObject("ADODB.Connection") 33> Conn.Open "bugs", , ""
The problem is that sometimes the page gives an error at line 33 and sometimes it goes further (I can see the db being updated when I open the mdb via Access) and fails at another DB call on line 70:
69> Set Conn = Server.CreateObject("ADODB.Connection") 70> Conn.Open "bugs", , ""
According to one suggestion I opened the file in Access and deselected the "record level locking" from Tools > Options > Advanced.
Does anyone have an idea on how to get over this? Regards, http://www.aspfaq.com/show.asp?id=2009
--
John Blessing http://www.LbeHelpdesk.com - Help Desk software priced to suit all
businesses http://www.free-helpdesk.com - Completely free help desk software ! http://www.lbetoolbox.com - Remove Duplicates from MS Outlook
Amol,
Don't know if this is your issue, but does the anonymous Web user have
rights to write to the directory where the MDB lives? It needs to
write a lock file.
HTH,
Mark http://www.idataconsultingservices.com - Multilingual Web Development http://www.synapsecm.com - Simple, Multilingual Content Management "Amol" <de*****@ececs.uc.edu> wrote in message news:51*************************@posting.google.co m... Hi,
I have a related problem. Using IIS 5.1 on Windows XP Home Edition. I'm putting up the website <a href="http://bugsonline.sourceforge.net/">bugsonline</a> bug tracking freeware. <br><br> The site is in asp and uses an Access mdb file as the database. I have configured the ODBC DSN correctly. However when the first page tries to access the database for updating I get the error: <br> Error Type: Provider (0x80004005) Unspecified error /html/login.asp, line 33 <br>
In the source code (lines 32 and 33): 32> Set Conn = Server.CreateObject("ADODB.Connection") 33> Conn.Open "bugs", , ""
The problem is that sometimes the page gives an error at line 33 and sometimes it goes further (I can see the db being updated when I open the mdb via Access) and fails at another DB call on line 70:
69> Set Conn = Server.CreateObject("ADODB.Connection") 70> Conn.Open "bugs", , ""
According to one suggestion I opened the file in Access and deselected the "record level locking" from Tools > Options > Advanced.
Does anyone have an idea on how to get over this? Regards,
http://www.aspfaq.com/show.asp?id=2009 ms******@hotmail.com (Mark Reichard) wrote in message news:<79*************************@posting.google.c om>... Amol, Don't know if this is your issue, but does the anonymous Web user have rights to write to the directory where the MDB lives? It needs to write a lock file.
Well, the problem is of the "works sometimes but not always" type.
I believe the lock file should not be an issue since the first time
the user logs in (this is when the last logged in timestamp is
incremented) the DB is updated fine (again - sometimes :( ), but it
is the second update to the DB that causes the error.
regards,
~ amol
HTH, Mark
http://www.idataconsultingservices.com - Multilingual Web Development http://www.synapsecm.com - Simple, Multilingual Content Management
"Amol" <de*****@ececs.uc.edu> wrote in message news:51*************************@posting.google.co m... Hi,
I have a related problem. Using IIS 5.1 on Windows XP Home Edition. I'm putting up the website <a href="http://bugsonline.sourceforge.net/">bugsonline</a> bug tracking freeware. <br><br> The site is in asp and uses an Access mdb file as the database. I have configured the ODBC DSN correctly. However when the first page tries to access the database for updating I get the error: <br> Error Type: Provider (0x80004005) Unspecified error /html/login.asp, line 33 <br>
In the source code (lines 32 and 33): 32> Set Conn = Server.CreateObject("ADODB.Connection") 33> Conn.Open "bugs", , ""
The problem is that sometimes the page gives an error at line 33 and sometimes it goes further (I can see the db being updated when I open the mdb via Access) and fails at another DB call on line 70:
69> Set Conn = Server.CreateObject("ADODB.Connection") 70> Conn.Open "bugs", , ""
According to one suggestion I opened the file in Access and deselected the "record level locking" from Tools > Options > Advanced.
Does anyone have an idea on how to get over this? Regards,
http://www.aspfaq.com/show.asp?id=2009 This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Mr Dygi |
last post by:
Hi,
PHP 4.3.4 installed manually from package *.zip and Apache 2. I have a
problem with this simple code:
<?php
$link = mysql_connect("127.0.0.1","","")
or die("Could not connect: " ....
|
by: kaiwing18 |
last post by:
Hi ,
I have a problem relate to java and database. Could anyone answer me
?Please see the following code.
import java.sql.*;
public class Result {
public static void main(String args) {
|
by: DD |
last post by:
Hello,
Could anyone please help me??
Is there somebody who could explain me how to make a connection to a access
database with a python cgi script.
I would like to use common sql commands in my...
|
by: Ana RM |
last post by:
Hi!!
I am connecting Oracle Discoverer to Informix. The connection is OK. I
can create an EUL in the Administrator, and make calcules, everything.
My problem is that I cannnot connect to the...
|
by: db2sysc |
last post by:
We want to run Unix Scripts on SunSolaris which Connected to MS SQL
Server 2000.
We would like to connect to SQL Server 2000 from Solaris. Is there any
way to connect to Sql Server 2000 natively...
|
by: Amanda |
last post by:
From a guy in Microsoft newsgroups:
| In *comp.databases.ibm-db2* there are always IBM guys
| from the Toronto labs on line.Post with the
| -for the love of god please help-
| line...
|
by: DavidS |
last post by:
Have Visual Studio.NET installed on MS 2000 Professional OS laptop. No issue
ever with web development and SQL connections.
Purchased new laptop with XP Professional SP2!!!!!!!! & Visual...
|
by: Brad Allison |
last post by:
Sorry to repeat myself if this is the same question I asked in the past, but
I have finally made a connection to our AS400 through ODBC. I tried to get
the connection using the data connection...
|
by: BartlebyScrivener |
last post by:
I am a mere hobbyist. Spent several hours trying to make a class,
because I think this is an occasion where I need one. But I can't make
it work.
This code "works" (only because of the global c,...
|
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...
|
by: ArrayDB |
last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
|
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)...
|
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...
|
by: Defcon1945 |
last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
|
by: Shællîpôpï 09 |
last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
|
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
|
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...
|
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...
| |