Windows XP, Frontpage 2000, IIS 5.1, Access 2000
When I attempt to open a connection to my database I get an error the
page cannot be found... this on my local machine, using localhost. The page
works correctly when viewed on my host's site.
The code:
Set Conn = Server.CreateOb ject("ADODB.Con nection")
Conn.open "gmarc"
I have a response.write test line within my asp code which displays
correctly
until I add the "Conn.open" line. The DSN is correct. Could there have
been
a change in XP in the way ODBC is configured?
Earl 9 1780
On Sat, 25 Sep 2004 23:30:07 GMT, "Earl Partridge"
<ea*****@pearne t.com> wrote: Windows XP, Frontpage 2000, IIS 5.1, Access 2000
When I attempt to open a connection to my database I get an error the page cannot be found... this on my local machine, using localhost. The page works correctly when viewed on my host's site.
The code: Set Conn = Server.CreateOb ject("ADODB.Con nection") Conn.open "gmarc"
I have a response.write test line within my asp code which displays correctly until I add the "Conn.open" line. The DSN is correct. Could there have been a change in XP in the way ODBC is configured?
It's configured the same. But we can't help with your error, you need
to post the entire error. And it's possible the problem has nothing
to do with your database anyway, try some testing using
Response.Writes and commenting out sections of your page to see if it
worked. Check the IIS logs and see what got requested.
Jeff
Where would I find that log? I've searched localhost/iishelp and where it
suggests "select the Enable Logging check box", I have right clicked my
computer name but do not find "Enable Logging" check box, only the box
to "Log Visits".
Earl
"Jeff Cochran" <je*********@zi na.com> wrote in message
news:41******** ********@msnews .microsoft.com. .. On Sat, 25 Sep 2004 23:30:07 GMT, "Earl Partridge" <ea*****@pearne t.com> wrote:
Windows XP, Frontpage 2000, IIS 5.1, Access 2000
When I attempt to open a connection to my database I get an error the page cannot be found... this on my local machine, using localhost. The page works correctly when viewed on my host's site.
The code: Set Conn = Server.CreateOb ject("ADODB.Con nection") Conn.open "gmarc"
I have a response.write test line within my asp code which displays correctly until I add the "Conn.open" line. The DSN is correct. Could there have been a change in XP in the way ODBC is configured?
It's configured the same. But we can't help with your error, you need to post the entire error. And it's possible the problem has nothing to do with your database anyway, try some testing using Response.Writes and commenting out sections of your page to see if it worked. Check the IIS logs and see what got requested.
Jeff
On Sun, 26 Sep 2004 14:28:30 GMT, "Earl Partridge"
<ea*****@pearne t.com> wrote: Where would I find that log? I've searched localhost/iishelp and where it suggests "select the Enable Logging check box", I have right clicked my computer name but do not find "Enable Logging" check box, only the box to "Log Visits".
IIS MMC in Administrative Tools -> Web Site -> Properties -> Bottom of
the Web Site Tab. Look at the Logging Properties and it shows the
path.
Jeff
"Jeff Cochran" <je*********@zi na.com> wrote in message news:41******* *********@msnew s.microsoft.com ... On Sat, 25 Sep 2004 23:30:07 GMT, "Earl Partridge" <ea*****@pearne t.com> wrote:
Windows XP, Frontpage 2000, IIS 5.1, Access 2000
When I attempt to open a connection to my database I get an error the page cannot be found... this on my local machine, using localhost. The page works correctly when viewed on my host's site.
The code: Set Conn = Server.CreateOb ject("ADODB.Con nection") Conn.open "gmarc"
I have a response.write test line within my asp code which displays correctly until I add the "Conn.open" line. The DSN is correct. Could there have been a change in XP in the way ODBC is configured?
It's configured the same. But we can't help with your error, you need to post the entire error. And it's possible the problem has nothing to do with your database anyway, try some testing using Response.Writes and commenting out sections of your page to see if it worked. Check the IIS logs and see what got requested.
Jeff
The error is:
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Driver Manager] Data source name not found and no
default driver specified
/gmarc/test.asp, line 29
Line 29 is the "Conn.Open "gmarc".
The log file contained the following:
#Software: Microsoft Internet Information Services 5.1
#Version: 1.0
#Date: 2004-09-26 21:06:05
#Fields: time c-ip cs-method cs-uri-stem sc-status
21:06:05 192.168.0.2 GET /gmarc/test.asp 500
The dsn and the path are correct.
Earl
"Jeff Cochran" <je*********@zi na.com> wrote in message
news:41******** ********@msnews .microsoft.com. .. On Sun, 26 Sep 2004 14:28:30 GMT, "Earl Partridge" <ea*****@pearne t.com> wrote:
Where would I find that log? I've searched localhost/iishelp and where it suggests "select the Enable Logging check box", I have right clicked my computer name but do not find "Enable Logging" check box, only the box to "Log Visits".
IIS MMC in Administrative Tools -> Web Site -> Properties -> Bottom of the Web Site Tab. Look at the Logging Properties and it shows the path.
Jeff
"Jeff Cochran" <je*********@zi na.com> wrote in message news:41****** **********@msne ws.microsoft.co m... On Sat, 25 Sep 2004 23:30:07 GMT, "Earl Partridge" <ea*****@pearne t.com> wrote:
Windows XP, Frontpage 2000, IIS 5.1, Access 2000
When I attempt to open a connection to my database I get an error the page cannot be found... this on my local machine, using localhost. The page works correctly when viewed on my host's site.
The code: Set Conn = Server.CreateOb ject("ADODB.Con nection") Conn.open "gmarc"
I have a response.write test line within my asp code which displays correctly until I add the "Conn.open" line. The DSN is correct. Could there have been a change in XP in the way ODBC is configured?
It's configured the same. But we can't help with your error, you need to post the entire error. And it's possible the problem has nothing to do with your database anyway, try some testing using Response.Writes and commenting out sections of your page to see if it worked. Check the IIS logs and see what got requested.
Jeff
On Sun, 26 Sep 2004 21:20:33 GMT, "Earl Partridge"
<ea*****@pearne t.com> wrote: The error is: Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified /gmarc/test.asp, line 29
Line 29 is the "Conn.Open "gmarc".
I've answered that one in another thread, but also see:
Why do I get database-related 80004005 errors? http://www.aspfaq.com/show.asp?id=2009
The log file contained the following: #Software: Microsoft Internet Information Services 5.1 #Version: 1.0 #Date: 2004-09-26 21:06:05 #Fields: time c-ip cs-method cs-uri-stem sc-status 21:06:05 192.168.0.2 GET /gmarc/test.asp 500
See:
Why do I get a 500 Internal Server error for all ASP errors? http://www.aspfaq.com/show.asp?id=2109
The dsn and the path are correct.
But I don't believe your code is. See the answer I posted in another
group/thread.
Jeff
"Jeff Cochran" <je*********@zi na.com> wrote in message news:41******* *********@msnew s.microsoft.com ... On Sun, 26 Sep 2004 14:28:30 GMT, "Earl Partridge" <ea*****@pearne t.com> wrote:
Where would I find that log? I've searched localhost/iishelp and where it suggests "select the Enable Logging check box", I have right clicked my computer name but do not find "Enable Logging" check box, only the box to "Log Visits".
IIS MMC in Administrative Tools -> Web Site -> Properties -> Bottom of the Web Site Tab. Look at the Logging Properties and it shows the path.
Jeff
"Jeff Cochran" <je*********@zi na.com> wrote in message news:41***** ***********@msn ews.microsoft.c om... On Sat, 25 Sep 2004 23:30:07 GMT, "Earl Partridge" <ea*****@pearne t.com> wrote:
>Windows XP, Frontpage 2000, IIS 5.1, Access 2000 > >When I attempt to open a connection to my database I get an error the >page cannot be found... this on my local machine, using localhost. The >page >works correctly when viewed on my host's site. > >The code: > Set Conn = Server.CreateOb ject("ADODB.Con nection") > Conn.open "gmarc" > >I have a response.write test line within my asp code which displays >correctl y >until I add the "Conn.open" line. The DSN is correct. Could there have >been >a change in XP in the way ODBC is configured?
It's configured the same. But we can't help with your error, you need to post the entire error. And it's possible the problem has nothing to do with your database anyway, try some testing using Response.Writes and commenting out sections of your page to see if it worked. Check the IIS logs and see what got requested.
Jeff
In ASPFAQ item 2009 I followed the 3rd item which I thought might be the
problem... that I do not have access, continuing to KB #306345, using an
ODBC DSN
"Insufficie nt Permissions to Read the DSN Registry Key".
I followed the regedit HKLM...\ODBC.IN I, where it indicates there should be
a
sub key entry for each DSN... There was only a blank Default entry.
And under ODBC.INI was ODBCFile DSN with a sub key DefaultDSN Dir which
is not where the database resides. I copied the database to that default,
rather than
changing the default, but that did not resolve the problem either.
It appears somehow that the ODBC.INI key is not updated with the DSNs. I'll
be looking around to see if I can find how to manually add them.
Earl
"Jeff Cochran" <je*********@zi na.com> wrote in message
news:41******** ********@msnews .microsoft.com. .. On Sun, 26 Sep 2004 21:20:33 GMT, "Earl Partridge" <ea*****@pearne t.com> wrote:
The error is: Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified /gmarc/test.asp, line 29
Line 29 is the "Conn.Open "gmarc".
I've answered that one in another thread, but also see:
Why do I get database-related 80004005 errors? http://www.aspfaq.com/show.asp?id=2009
The log file contained the following: #Software: Microsoft Internet Information Services 5.1 #Version: 1.0 #Date: 2004-09-26 21:06:05 #Fields: time c-ip cs-method cs-uri-stem sc-status 21:06:05 192.168.0.2 GET /gmarc/test.asp 500
See:
Why do I get a 500 Internal Server error for all ASP errors? http://www.aspfaq.com/show.asp?id=2109
The dsn and the path are correct.
But I don't believe your code is. See the answer I posted in another group/thread.
Jeff
"Jeff Cochran" <je*********@zi na.com> wrote in message news:41****** **********@msne ws.microsoft.co m... On Sun, 26 Sep 2004 14:28:30 GMT, "Earl Partridge" <ea*****@pearne t.com> wrote:
Where would I find that log? I've searched localhost/iishelp and where it suggests "select the Enable Logging check box", I have right clicked my computer name but do not find "Enable Logging" check box, only the box to "Log Visits".
IIS MMC in Administrative Tools -> Web Site -> Properties -> Bottom of the Web Site Tab. Look at the Logging Properties and it shows the path.
Jeff
"Jeff Cochran" <je*********@zi na.com> wrote in message news:41**** ************@ms news.microsoft. com... > On Sat, 25 Sep 2004 23:30:07 GMT, "Earl Partridge" > <ea*****@pearne t.com> wrote: > >>Windows XP, Frontpage 2000, IIS 5.1, Access 2000 >> >>When I attempt to open a connection to my database I get an error the >>page cannot be found... this on my local machine, using localhost. >>The >>page >>works correctly when viewed on my host's site. >> >>The code: >> Set Conn = Server.CreateOb ject("ADODB.Con nection") >> Conn.open "gmarc" >> >>I have a response.write test line within my asp code which displays >>correct ly >>until I add the "Conn.open" line. The DSN is correct. Could there >>have >>been >>a change in XP in the way ODBC is configured? > > It's configured the same. But we can't help with your error, you need > to post the entire error. And it's possible the problem has nothing > to do with your database anyway, try some testing using > Response.Writes and commenting out sections of your page to see if it > worked. Check the IIS logs and see what got requested. > > Jeff
Since everyone else forgot to mention this I will. Please read the
following links. It might not get rid of the error but at least your
application will be faster http://www.aspfaq.com/show.asp?id=2126 http://msdn.microsoft.com/library/de...components.asp
Earl Partridge wrote: In ASPFAQ item 2009 I followed the 3rd item which I thought might be the problem... that I do not have access, continuing to KB #306345, using an ODBC DSN "Insufficie nt Permissions to Read the DSN Registry Key". I followed the regedit HKLM...\ODBC.IN I, where it indicates there should be a sub key entry for each DSN... There was only a blank Default entry.
And under ODBC.INI was ODBCFile DSN with a sub key DefaultDSN Dir which is not where the database resides. I copied the database to that default, rather than changing the default, but that did not resolve the problem either.
It appears somehow that the ODBC.INI key is not updated with the DSNs. I'll be looking around to see if I can find how to manually add them. Earl
Problem Solvedl! I have several databases from earlier versions, Windows 98
and Frontpage 97... all were User DSNs, all worked correctly previously.
I may have too hurriedly scanned over some of the links I've been sent to,
and
maybe missed the point that System DSN should be used instead. I moved
my database from User to System and it works.
Thanks for hanging with me.
Earl
"Joker" <no*****@netzer o.com> wrote in message
news:%2******** ********@TK2MSF TNGP11.phx.gbl. .. Since everyone else forgot to mention this I will. Please read the following links. It might not get rid of the error but at least your application will be faster
http://www.aspfaq.com/show.asp?id=2126
http://msdn.microsoft.com/library/de...components.asp
Earl Partridge wrote:
In ASPFAQ item 2009 I followed the 3rd item which I thought might be the problem... that I do not have access, continuing to KB #306345, using an ODBC DSN "Insufficie nt Permissions to Read the DSN Registry Key". I followed the regedit HKLM...\ODBC.IN I, where it indicates there should be a sub key entry for each DSN... There was only a blank Default entry.
And under ODBC.INI was ODBCFile DSN with a sub key DefaultDSN Dir which is not where the database resides. I copied the database to that default, rather than changing the default, but that did not resolve the problem either.
It appears somehow that the ODBC.INI key is not updated with the DSNs. I'll be looking around to see if I can find how to manually add them. Earl
Stop using ODBC/DSN for your database connection. It is slow & cumbersome. http://www.aspfaq.com/show.asp?id=2126 http://msdn.microsoft.com/library/de...components.asp http://support.microsoft.com/?scid=252475
252475 PRB: ODBC Admin Displays Only a Certain Number of DSNs
So one last time stop using ODBC/DSN as it will cause the system to be
slower & is harder to deal with. I always use server side include files
to store my database connection strings.
Earl Partridge wrote: Problem Solvedl! I have several databases from earlier versions, Windows 98 and Frontpage 97... all were User DSNs, all worked correctly previously. I may have too hurriedly scanned over some of the links I've been sent to, and maybe missed the point that System DSN should be used instead. I moved my database from User to System and it works. Thanks for hanging with me. Earl This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Will |
last post by:
On the subject of Data Warehouses, Data Cubes & OLAP….
I would like to speak frankly about Data Warehouses, Data Cubes and
OLAP (on-line analytical processing). Has it dawned on anyone else
that these buzz words were created by some geek who decided to take a
stab at marketing? Knowing that to the backwoods manager who knows
little of technology that new innovative names for old concepts would
help to sale their products.
I mean...
|
by: lobrys |
last post by:
hi
I build a VB .NET application that makes file access, environnemet acess,
database access, etc....
If I ran the app locally, everything works....(normal)
If I copy the app on a server, and execute it, everything works until a
file/environnement/database access !.....
I just want that my app may run in every machine!
|
by: Greg Gursky |
last post by:
Hello:
I'm doing some planning on a potential project with which I need
some help. The database at the focus of this question is a
MS Access database that is currently accessed by DAO from a local
webserver. I need to access the same database remotely through
TCP/IP. There will be potentially many transactions coming from
both the web server and remotely, so the solution needs to keep
the data safe in such an environment. However,...
|
by: kma |
last post by:
I am designing an Access 2000 database on a computer running Windows 98.
I have one form with several tabs; all of which have sub forms, some
with a subform on a subform.
For example, on my main Job form I have a tab for PO's to keep track of
all purchase orders pertaining to a specific job. The first subform is
for the PO numbers related to the jobs on the main form and the next
subform is for all of the PO lines for each PO. ...
|
by: cisco |
last post by:
Could anyone point me in the direction of a document that describes the
difference between JET and Access? I can't seem to find anything.
Another question i have is i have this application (.net) that writes to a
databaase every 10 milliseconds(purely for testing). While it's writing i
copy over the access file and it seems fine. Is this really safe? Is jet
blocking until it can write? If does it queue up data.
man it's hot in here...
| |
by: Tim Marshall |
last post by:
My A2003 is set up so that the default file format is Access 2000
(options, advanced tab). I've just tried to make my first A2003 mdb
into an mde and I get an error saying: "you cannot create a <mdb name>
ADE or MDE from a dtabase saved in <mdb name> 2000 format."
Also, in help there's a curious note I simply don't understand which
I've reproduced below (help on mde, "About ADE & MDE files").
I'm a former A97 developer, can someone...
|
by: Bart |
last post by:
Hi,
I receive an utf8 character from a database, like 田 (Japanese
Character, style: &#XXXXX).
How can I visualize the Japanese character on my application? I have found
the class System.Text.Encoding, but the input looks like \uXXXX. I don't
know how to do.
Thank you,
|
by: XFER |
last post by:
Does anyone know how well 10 concurrent users will
perform on the above config? Are there any known issues,
limits to using MS Access with IIS 5 and ASP.net on a non-
..net server (NT)?
thanks.
|
by: MW de Jager |
last post by:
I'm having endless problems with gaining access to an Access Database that
sits on a different server. My ASP.NET app cannot gain control. The errror
message I get is:
The Microsoft Jet database engine cannot open the file
'\\Server1\DataFolder\Countries5.mdb'. It is already opened exclusively by
another user, or you need permission to view its data.
I have setup the connection string to have the username = admin and the
password is...
|
by: Suzette |
last post by:
I have an excel file that automatically updates when opened, pulling information from an Access database into into various pivot tables.
I created a macro in Access to perform various necessary functions with the data.
I want to be able to open an Access form that I created, and then hit a button that will run the macros and that will open the excel database.
The only problem that I am having is that when the excel file opens and tries...
|
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: 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...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| |
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
|
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...
| |