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
- var conn_str = "Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\\inetpub\\wwwroot\\myDB.mdb;Uid=Admin;Pwd=;" ;
- var conn = new ActiveXObject("ADODB.Connection");
- conn.open(conn_str);
Expand|Select|Wrap|Line Numbers
- var conn_str = "Provider=MS Remote;Data Source=MyDB; Remote Server=http://hcidproj.soi.city.ac.uk; Remote Provider=Microsoft.Jet.OLEDB.4.0"
Any ideas? Suggestions maybe? I'd really appreciate some.
Cheers,
Kris