473,320 Members | 1,969 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 ADO and Access DB on server

Hi,

I've written an 'application' in DHTML and Javascript that runs on the client side. No ASP involved.
For this 'application' I need to communicate with a database (MS Access 2002-2003), and I'm using ADO to do this.

However, while I'm albe to access the database when running the web page on my local IIS, I cannot get it to run when I move the whole thing to the server. I'm assuming this has something to do with different settings or that when opening the web page/application now, the page itself is running on the client machine while the database is located on the server, i.e. a different machine.
Since everything is designed to run on the client side, this seems to cause a problem.

Is it possible to use only javascript to access the database through the ADO, or do I need to use ASP to connect to the database (my server is microsoft, basically just another computer running IIS and is configured as a server, it runs XP pro with the lockdown security kit)

The code I'm using to access the DB is:
Expand|Select|Wrap|Line Numbers
  1. var conn_str = "Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\\inetpub\\wwwroot\\myDB.mdb;Uid=Admin;Pwd=;" ;
  2.  
  3.     var conn = new   ActiveXObject("ADODB.Connection");
  4.     conn.open(conn_str);
  5.  
I've tried using
Expand|Select|Wrap|Line Numbers
  1.     var conn_str = "Provider=MS Remote;Data Source=MyDB; Remote Server=http://hcidproj.soi.city.ac.uk; Remote Provider=Microsoft.Jet.OLEDB.4.0"
...which seems to open the connection, but now I'm unable to access the recordset, and it seems the table (which I know exists) is not found.

Any ideas? Suggestions maybe? I'd really appreciate some.

Cheers,
Kris
Sep 19 '06 #1
1 1660
PEB
1,418 Expert 1GB
Hi,

See simillar posts... There is established connection anywhere!

Also see VB forum!

And search on thescripts!

:)
Sep 19 '06 #2

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

Similar topics

43
by: nospam | last post by:
I got three (3) files (1) Untitled.aspx (2) Untitled.aspx.1.cs (3) Untitled.aspx.2.cs These three files must be used together to make file #1, Untitled.aspx, page work via J.I.T. when the...
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...
4
by: chris.dunigan | last post by:
I'm looking for an example of how to execute an existing DTS­ package from an ASP (VB)script and would appreciate any and all response. ­I don't even know if it's possible Thanks - Chuck...
1
by: annie | last post by:
Hi all, I have recently ported my Access 2000 app to SQL Server, keeping the Access client as the front end using linked tables. I am also using triggers on my SQL tables to trap orphan...
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...
19
by: James Fortune | last post by:
I have a lot of respect for David Fenton and Allen Browne, but I don't understand why people who know how to write code to completely replace a front end do not write something that will automate...
2
by: meyvn77 | last post by:
Background: I'm new at SQL Server (no experience, zip, nada) but getting pretty good with developing applications in Access(VBA) and in VB using ADO.... Currently I use access to and GIS...
1
by: lecnac | last post by:
Sorry for the repost. I must have done something wrong when I tried to post my reply (I can't seem to find it). Anyway, I'd really appreciate any help that anyone could provide. My issue is...
17
by: Flic | last post by:
Is this possible? I know about a bit about ODBC and found how to import an ODBC database stored on the computer, however I am after accessing an SQL database stored on a webserver. I'd like to...
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...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
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: 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...
0
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.