I am a newbie.
I am trying to setup my asp pages with some databases in my company intranet. But when i use the PC and log into that webpages, all of the database cannot been loaded out to the pages. why?

<%
Dim DataConn, dbpath
dbpath = server.mappath("EmScheduler.mdb")
Set DataConn =Server.CreateObject("ADODB.Connection")
Dataconn.Provider="Microsoft.Jet.OLEDB.4.0"
Dataconn.connectionstring = "Data source =" & dbpath
Dataconn.open
%>
this is how the connection go, is that correct. the pages work well at my own home PC. so when i upload to the company intranet, everythg goes wrong. My company is using SQLserver 7.0, so is there any changes i need to do in case to settle this?

Thanks for helping.

In your code there, I could see that you are using ACCESS mdb file.

Are you trying to use MSAccess or SQL server 7.0?

I am confused. If everything goes wrong, then what is the error you get? You haven't mentioned about that. Can you post the error?

For help on connection strings you can take a look at http://www.connectionstrings.com/

This is how I do use, if it is for SQL server.
Dim conn
Set conn = Server.CreateObject("ADODB.CONNECTION")
conn.ConnectionTimeout = 30
conn.Open "Provider=sqloledb;Data Source=Aron1;Initial Catalog=pubs;User Id=sa;Password=asdasd;"

-Vijay G

Actually, the problem i found is

1. when i key in information to the pages and submit. the data cannot b save into the database.

2. i also unable to call out the database that i save in my access.

i trying my pages at home using access.
if my company server is SQL7.0, then wat should i do, in order to match with the server.

Hey vieritlc,

I've played with both Access and SQL. For the problem that you are refering too sounds more like a privileges issue. If you can view however cannot add or update then the best thing is to go into the SQL Server (Enterprise Manager) and check the setting that show who can update what kind of information. I would make sure that iuser is allowed to make changes.

From there just know that if you don't want everyone on the intranet to be able to make changes then you'll probably want to setup a password protected area in which only the admins can login and make the changes to the database.

For the difference between the connections reference the connection strings happygv provided.

Hope this helps,
James