> 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

> Did you create the connection string using the properties in your ADODC?
And
> then test your recordset?

> >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.