
ADO control on HTML, to MSAccess/ODBC database on Webserver
Hi,
I have an urgent problem, and I hope you guys can help
I have a HTML page, on which I wish to display a table of data from a
MSAccess/ODBC database on the webserver.
The data in the table is static ( ie, once loaded, will not be refreshed or
edited ). However, the table itself should be live ( in the sense that it
should be aware that the user has clicked on a row ), so that a little
Javascript routine can interact with it.
What I have now is a MS DataGrid, whose datasource is a ADO Control on the
same HTML page. The problem is this : when I use a personal webserver on my
client machine, and connect the ADO control to a local database, everything
works fine ( ie, I use http://localhost, or to file://myhtml.htm as my URL).
When I move the whole shabang to a MS IIS server ( and have the ADO control
connect to a MSAccess database on the webserver ), nothing happens. Kaput,
zilch, nothing. I figured the problem is either :
1. My ADO Connection string is incorrect. Its been a long time since I did
anything with connection strings, so I won't be surprised if I got it wrong.
2. Some web server security settings is preventing the database connection.
So, does anyone know what connection string to use for the ADO control in
this context ? What should I be using as the provider ? MS Remote ? Do you
have a sample of the connection string I can use ? And what are the security
settings that I need on the web server ?
Thanks alot.
--
Delete "RemoveThis" from email address to reply