473,320 Members | 1,722 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,320 software developers and data experts.

using ASP in web with database Access

10
Hi, I need help on this...

This code is working on my IIS server but when I uploaded it to the web, it wont run anymore, why? Please help.

Thanks!

set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open(Server.Mappath("cartoon.mdb"))
set rs = Server.CreateObject("ADODB.recordset")
Dec 5 '06 #1
7 1495
sashi
1,754 Expert 1GB
Hi, I need help on this...

This code is working on my IIS server but when I uploaded it to the web, it wont run anymore, why? Please help.

Thanks!

set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open(Server.Mappath("cartoon.mdb"))
set rs = Server.CreateObject("ADODB.recordset")
Hi there,

"Won't run anymore" doesn't provide much details to be able to help you out. Please provide more details such as the error message / error number / code being prompt or thrown while executing this code.

Providing more details would ease in providing help in return. Good luck & Take care.
Dec 5 '06 #2
jhaek19
10
Ahm, actually there is no error, cause it simply "wont run/execute" in my web server, unlike in my own computer where I developed the asp file, it executes the way it should be on my IIS virtual directory...but when I uploaded it for users to browse in the www, my commands wont execute; access database, etc...

Hi there,

"Won't run anymore" doesn't provide much details to be able to help you out. Please provide more details such as the error message / error number / code being prompt or thrown while executing this code.

Providing more details would ease in providing help in return. Good luck & Take care.
Dec 6 '06 #3
So you open the web page, and nothing happens? There HAS to be an error somewhere.

Do you have a global.asa file that holds variables, and you are running the virtual directory as it's own application, etc.?

First, I would start by writing out some basic info so you can debug...

Expand|Select|Wrap|Line Numbers
  1. response.write server.mappath("/") & "/whatever/mydb.mdb"
  2. response.end
  3.  
This way, you can step through the code, to see if everything is working.

You should also have a custom 500.asp page which can be configured to show you where errors occur, plus give a nice friendly error page to clients. You can even have it email you the errors, so you can fix the site as quickly as possible. Just a suggestion.

Best regards,

Michael C. Gates
Dec 6 '06 #4
jhaek19
10
I tried it, so it seems my asp doesn't execute on my web server...is there any special headings or commands I should include??

can anyone give me a sample asp file that executes with a database in a web server???please help!


thanks!


So you open the web page, and nothing happens? There HAS to be an error somewhere.

Do you have a global.asa file that holds variables, and you are running the virtual directory as it's own application, etc.?

First, I would start by writing out some basic info so you can debug...

Expand|Select|Wrap|Line Numbers
  1. response.write server.mappath("/") & "/whatever/mydb.mdb"
  2. response.end
  3.  
This way, you can step through the code, to see if everything is working.

You should also have a custom 500.asp page which can be configured to show you where errors occur, plus give a nice friendly error page to clients. You can even have it email you the errors, so you can fix the site as quickly as possible. Just a suggestion.

Best regards,

Michael C. Gates
www.gateshosting.com
Dec 6 '06 #5
sashi
1,754 Expert 1GB
I tried it, so it seems my asp doesn't execute on my web server...is there any special headings or commands I should include??

can anyone give me a sample asp file that executes with a database in a web server???please help!


thanks!
Hi there,

Is ASP supported on the particular web server? Please check this detail. Good luck & Take care.
Dec 6 '06 #6
Are you using windows 2003 or 2000 server?

Regards,

Michael C. Gates
Dec 6 '06 #7
jhaek19
10
Thanks for all your help, I found out that my webhost doesn't support ASP, how sad!!! Anyways Im shifting to PHP programming, hope to hear your help in the future, enjoy programming!
Dec 7 '06 #8

Sign in to post your reply or Sign up for a free account.

Similar topics

38
by: Remco Groot Beumer | last post by:
Hello, I'm trying to decide if the following situation would be workable: Generate an MS Access Front End (which will run localy on client computers), which will link to a DBMS (SQL server or...
5
by: dananrg | last post by:
I've created a small company database where the tables reside in a SQL Server database. I'm using Access 2000 forms for a front end. I've got a System DSN set-up to SQL Server and am using links...
1
by: Matt Alanzo | last post by:
On another newsgroup an Access knowledgable party posted: >You should be able to connect an Access ADP to an existing SQLExpress >database running in SQLS 2000 compatibility mode. The only thing...
10
by: B Moor | last post by:
Host PC: Win SBS 2003 with 2.6 GHz processor and 1GB RAM SQL Server 2000 sp3 (or latest).MS Office 2k3 I have the access 2k3 front end running on server (this may get changed) and all was well...
8
by: Carl | last post by:
Hi, Using MS Access 2000, is it possible to run a UPDATE or INSERT SQL query using some form of conditional IF THEN ?? for example: SELECT * FROM Books IF EXISTS(Select Books.ID = 1)
6
by: Serious_Practitioner | last post by:
Good day all, and thank you in advance for your help. No - MANY thanks in advance for your help - I know nothing about using databases on Web servers. I am about to discuss a project with a...
4
by: James | last post by:
I have a VB windows forms application that accesses a Microsoft Access database that has been secured using user-level security. The application is being deployed using No-Touch deployment. The...
10
by: Robert | last post by:
How do you get an accurate count of the number of records returned from a query when using linked tables. I have an access 2003 database as a front end to another access 2003 database that...
4
by: Bugs | last post by:
Hi everyone. I am trying to open a database which works fine using Access 2003, but when trying to open it on another PC that has Access 2002 I get the following error "This database is...
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: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
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: 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
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.