473,326 Members | 2,134 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,326 software developers and data experts.

[Please help] Cannnot connect ODBC

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


Jul 19 '05 #1
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
Jul 19 '05 #2
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

Jul 19 '05 #3
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
Jul 19 '05 #4
"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
Jul 19 '05 #5
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

Jul 19 '05 #6
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

Jul 19 '05 #7

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

Similar topics

20
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: " ....
1
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) {
9
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...
3
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...
5
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...
2
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...
15
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...
14
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...
16
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,...
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
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...
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
1
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....
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.