Hi folks - just a quick question.

Is it possible to connect to a database that sits on a webserver using a script that sits on a local machine ?

If so, would the connection string look something like this :
sConnString="PROVIDER=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=" & Server.MapPath("http://www.blah.cm/casinonewsxml.mdb")

The reason I ask, is because I have a vbscript that uses windows scheduling service to run at different stages during the day to update a database on a live server. I was wondering if it was possible to put this script on a local machine and make changes to the connection string.

I'm sure there are security issues etc, so any comments or input would be greatly appreciated. Or if you could think of any other ways I could do this, that would really help.

Thanks folks

I've decided to use MySQL database instead of the access database - access seems to be too flakey for this type of remote connection.

I have connected to a mysql database and have experienced a bit of a problem. I can insert and display info ok from the database, however when I try and enter in a date it doesn't seem to work. I believe its because mysql stores the dates as 0000/00/00 and asp does it the other way, 00/00/0000.

Any body know of any scripts or resources that might help me fix this?

Thanks folks.

I am a bit rusty on my MySQL knowledge but check to see it the GRANT tables in the MySQL database for the user you are using allows you to modify the database, tables etc. MySQL has a pretty fine-grained solution for managing the access (read/write). It took me a while to come to terms with the method.

If this is not the problem you can just convert the date representation you have got to the one which the database accepts. This should be simple string manipulation so it shouldn't cause problems.

Hope it helps a little,
Jacob.