I have a simple database in ms access, one table with some 10-15 recordets.
When creating web page in asp (vbscript) on my local machine, which displays
the contents of access database, everything works fine (on local server,
dreamweaver, inetpub/ etc etc...).
Problem appears when i upload entire site (form my
d:\inetpub\wwwr oot\site_name) to my web server. Server is based
on NT techn., all the html files appear normally, but this page in asp wont
show up (HTTP500 internal server error shows up).
Can anybody give me a hint what has to be changed? connection string? path?
Many thanks. 6 1928
"sirius" <zu****@hotmail .com> wrote in message
news:bv******** **@ls219.htnet. hr... I have a simple database in ms access, one table with some 10-15
recordets. When creating web page in asp (vbscript) on my local machine, which
displays the contents of access database, everything works fine (on local server, dreamweaver, inetpub/ etc etc...). Problem appears when i upload entire site (form my d:\inetpub\wwwr oot\site_name) to my web server. Server is based on NT techn., all the html files appear normally, but this page in asp
wont show up (HTTP500 internal server error shows up). Can anybody give me a hint what has to be changed? connection string?
path? Many thanks.
It's not really an Access question - perhaps you could try one of the ASP
groups, but one suggestion is this:
If on your machine the database, was "d:\inetpub\www root\site_name\ MyDb.mdb"
on the new machine the file could be anywhere. Therefor make sure you use
in your connection string
"Data Source=" & Server.MapPath( "MyDb.mdb")
Another common cause of grief is permissions - there must be millions of
postings on this.
Fletcher
"sirius" <zu****@hotmail .com> wrote in news:bv******** **@ls219.htnet. hr: I have a simple database in ms access, one table with some 10-15 recordets. When creating web page in asp (vbscript) on my local machine, which displays the contents of access database, everything works fine (on local server, dreamweaver, inetpub/ etc etc...). Problem appears when i upload entire site (form my d:\inetpub\wwwr oot\site_name) to my web server. Server is based on NT techn., all the html files appear normally, but this page in asp wont show up (HTTP500 internal server error shows up). Can anybody give me a hint what has to be changed? connection string? path?
Perhaps your server is not ASP enabled?
--
Lyle
(for e-mail refer to http://ffdba.com/contacts.htm)
It sometimes helps to make a test page (test.asp or whatever) with one
simple line of code to isolate problems...
<%
response.write "If you see this, asp is enabled and working on the server"
%>
Otherwise, like Lyle... I would recommend using server.mappath wherever you
need to reference a file such as the mdb. Also, the mdb has to have write
perms.
--
Jerry Boone
Analytical Technologies, Inc. http://www.antech.biz
Secure Hosting and Development Solutions for ASP, ASP.NET, SQL Server, and
Access
"sirius" <zu****@hotmail .com> wrote in message
news:bv******** **@ls219.htnet. hr... I have a simple database in ms access, one table with some 10-15
recordets. When creating web page in asp (vbscript) on my local machine, which
displays the contents of access database, everything works fine (on local server, dreamweaver, inetpub/ etc etc...). Problem appears when i upload entire site (form my d:\inetpub\wwwr oot\site_name) to my web server. Server is based on NT techn., all the html files appear normally, but this page in asp
wont show up (HTTP500 internal server error shows up). Can anybody give me a hint what has to be changed? connection string?
path? Many thanks.
"Jerry Boone" <je***@antech.b iz.killspam> wrote in message
news:Ae******** **********@news svr24.news.prod igy.com... It sometimes helps to make a test page (test.asp or whatever) with one simple line of code to isolate problems...
<% response.write "If you see this, asp is enabled and working on the server" %>
Otherwise, like Lyle... I would recommend using server.mappath wherever
you need to reference a file such as the mdb. Also, the mdb has to have write perms.
-- Jerry Boone Analytical Technologies, Inc. http://www.antech.biz Secure Hosting and Development Solutions for ASP, ASP.NET, SQL Server, and Access
Normally I have a simple page to test read-write access to the database as
well. People bring a thousand lines of code which "don't work" when a few
lines could at least make sure they have access to the database.
However, I did get caught out a while ago with the following: http://support.microsoft.com/default...;en-us;Q251254
which explains how permissions are necessary on a temp folder as well.
I also tend to write a function which involves an On Error Resume Next
statement so I can check whether I do have a connection before I proceed,
although I am now looking at using .NET for the hopefully more useful
try/catch error handling.
.......
Set cnn = DbConnection(st rError)
If Len(strError) > 0 Then ...
........
........
Function DbConnection(st rError)
On Error Resume Next
Dim cnn
Dim strCnn
strError = "Unknown Error"
strCnn = "Provider=Micro soft.Jet.OLEDB. 4.0;" & _
"Data Source=" & Server.MapPath( g_strDatabase)
Set cnn = Server.CreateOb ject("ADODB.Con nection")
cnn.ConnectionS tring = strCnn
cnn.Open
If Err.Number <> 0 Then
Set cnn = Nothing
If Len(Err.Descrip tion) > 0 Then
strError = Err.Description
End If
Else
strError = ""
End if
Set DbConnection = cnn
End function
Fletcher
I've been using Asp.Net using VS02, then VS03 and I have to say that the new
error handling is great and the detail is there... it's just understanding
what the hell it's trying to tell me is the problem... or my problem?...
To clarify that... Try-Catch is great, minds every time, and is a
significant improvement. However, the stack trace seldom (if ever) points
out hints as to the source of the error... at least to a 9 month
developer... which could be my problem as well...
If I had it to do again I might look more seriously into using Web Matrix
because it isn't reliant on code behind dll's. You can modify it like ASP
and the changes take effect on save, unlike having to build the application
and have it give birth to a new dll that takes forever to load into the gac.
One of the more frustrating things I have also come across is that if the
web app isn't getting regular hits... it kind of goes to sleep and the gac
or something is repopulated and the user waits for about 20 seconds for this
to occur before getting a page. After that it's snappy, but none the less a
little disappointing - perhaps I will find some cure for that in the
future...
Anyway... (sigh)
--
Jerry Boone
Analytical Technologies, Inc. http://www.antech.biz
Secure Hosting and Development Solutions for ASP, ASP.NET, SQL Server, and
Access
"Fletcher Arnold" <fl****@home.co m> wrote in message
news:bv******** **@hercules.bti nternet.com... "Jerry Boone" <je***@antech.b iz.killspam> wrote in message news:Ae******** **********@news svr24.news.prod igy.com... It sometimes helps to make a test page (test.asp or whatever) with one simple line of code to isolate problems...
<% response.write "If you see this, asp is enabled and working on the
server" %>
Otherwise, like Lyle... I would recommend using server.mappath wherever you need to reference a file such as the mdb. Also, the mdb has to have
write perms.
-- Jerry Boone Analytical Technologies, Inc. http://www.antech.biz Secure Hosting and Development Solutions for ASP, ASP.NET, SQL Server,
and Access
Normally I have a simple page to test read-write access to the database as well. People bring a thousand lines of code which "don't work" when a few lines could at least make sure they have access to the database.
However, I did get caught out a while ago with the following:
http://support.microsoft.com/default...;en-us;Q251254
which explains how permissions are necessary on a temp folder as well.
I also tend to write a function which involves an On Error Resume Next statement so I can check whether I do have a connection before I proceed, although I am now looking at using .NET for the hopefully more useful try/catch error handling.
...... Set cnn = DbConnection(st rError) If Len(strError) > 0 Then ... ....... .......
Function DbConnection(st rError)
On Error Resume Next
Dim cnn Dim strCnn
strError = "Unknown Error"
strCnn = "Provider=Micro soft.Jet.OLEDB. 4.0;" & _ "Data Source=" & Server.MapPath( g_strDatabase)
Set cnn = Server.CreateOb ject("ADODB.Con nection")
cnn.ConnectionS tring = strCnn
cnn.Open
If Err.Number <> 0 Then Set cnn = Nothing If Len(Err.Descrip tion) > 0 Then strError = Err.Description End If Else strError = "" End if
Set DbConnection = cnn
End function Fletcher
"Jerry Boone" <je***@antech.b iz.killspam> wrote in message
news:j3******** **********@news svr24.news.prod igy.com... I've been using Asp.Net using VS02, then VS03 and I have to say that the
new error handling is great and the detail is there... it's just understanding what the hell it's trying to tell me is the problem... or my problem?...
To clarify that... Try-Catch is great, minds every time, and is a significant improvement. However, the stack trace seldom (if ever) points out hints as to the source of the error... at least to a 9 month developer... which could be my problem as well...
If I had it to do again I might look more seriously into using Web Matrix because it isn't reliant on code behind dll's. You can modify it like ASP and the changes take effect on save, unlike having to build the
application and have it give birth to a new dll that takes forever to load into the
gac. One of the more frustrating things I have also come across is that if the web app isn't getting regular hits... it kind of goes to sleep and the gac or something is repopulated and the user waits for about 20 seconds for
this to occur before getting a page. After that it's snappy, but none the less
a little disappointing - perhaps I will find some cure for that in the future...
Anyway... (sigh)
-- Jerry Boone Analytical Technologies, Inc. http://www.antech.biz Secure Hosting and Development Solutions for ASP, ASP.NET, SQL Server, and Access
Well, I've got all that to look forward to - I'm just starting to look at
ASP.NET. I am still unsure as to whether there is a pressing need to change
to ADO.NET at the same time as converting the pages to ASP.NET. The number
of times these data access methods and models change really does make it
hard for the lazy programmer to keep up.
Fletcher This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Mark B |
last post by:
We have an Access app (quite big) at www.orbisoft.com/download.
We have had requests by potential users to have it converted to an SQL
version for them since there corporate policy excludes them from buying mdb
backends.
Here's the (million dollar?) questions :)
How long and how difficult a process would it be?
Which SQL platform would we be best to develop it on?
|
by: diskoduro |
last post by:
Hi!!
Years ago I built a database to control the production of a little
factory.
The users wanted to work in a Windows Net workgroup so I created an
mdb with all the tables and data an after that every user had his own
mde linked to the main mdb.
Year by year, progressively the number of records has been growing and
the speed of the application has decreased strongly, because of the
grrrreat number of records stored.
|
by: Indrid Colt |
last post by:
Hi everybody,
I try to migrate my Access 2003 MDB BackEnd (with data) to SQL server (MSDE
8.0) with the Access Wizard, but when i finish, all my table with a random
autonumber primarykey have no record, and i was not able to add record ??
I try to change random field to a simple autonumber (in MDB) but it's
impossible :-(
I try too SSW upsizing Pro software, but i have the same problem.
|
by: Bob Palank |
last post by:
I created a windows application, added a Grid Control and connected to the
Pubs.mdb Access database locally with no trouble. Next I copied Pubs to a
WebServer, changed the connection string by providing the IP address of the
web server but the error below occurs. I tried the domain name ( like
ibm.com\Folder) for the server and that failed also. I don't think I'm even
attempting to hit on the server! The error is shown below
An...
|
by: Deltronic |
last post by:
Hi,
situation :
MDB file on SBS2003 server, used by 4 or 5 users simultaniously (on XPP pc's)
witout problems. File is always in use by one of these users, so .ldb is
always present.
problem :
| |
by: jimbreau |
last post by:
Re: Dreamweaver Mx 2004 ASP VBscript:
1. The following is my connection script at "conn.asp"
Dim MM_connDWDynamicServer_STRING
MM_connDWDynamicServer_STRING = "Driver={Microsoft Access Driver (*.mdb)}; DBQ=E:\kunden\homepages\28\d153929211\db\nationaEx .mdb;"
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.connectionstring = MM_connDWDynamicServer_STRING
Conn.Open %>
|
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: 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: 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: 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: 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();...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
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...
| |