Hi All,
I am trying to use simple Microsoft Access Database Access page on my website, just to view customers information.
I created the page using MS Access Wizard, its very standard and simple.
I can view the page perfectly on my local PC.
But i am having problems viewing the page on my website.
My website address is
http://www10.asphost4free.com/rizzir/
I copied the database in db folder of my website
http://www10.asphost4free.com/rizzir/db/online.mdb
Datbase name is
onlinedb.mdb
Database does not need any password
Page which created is standard Customers.htm page
Which works fine locally on my pc.
I opened the Customers.html page in notepad and changed the FOLLOWING CODE
Data Source=http://www10.asphost4free.com/rizzir/db/online.mdb
This is the whole shunk from the Customers.html
<a:ConnectionString>Provider=Microsoft.Jet.OLEDB.4.0;User ID=Admin;Data Source=http://www10.asphost4free.com/rizzir/db/online.mdb;Mode=Share Deny None;Extended Properties="";Persist Security Info=False;Jet OLEDB:System database="";Jet OLEDB:Registry Path="";Jet OLEDBatabase Password="";Jet OLEDB:Engine Type=0;Jet OLEDBatabase Locking Mode=1;Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Global Bulk Transactions=1;Jet OLEDB:New Database Password="";Jet OLEDB:Create System Database=False;Jet OLEDB:Encrypt Database=False;Jet OLEDBon't Copy Locale on Compact=False;Jet OLEDB:Compact Without Replica Repair=False;Jet OLEDB:SFP=False</a:ConnectionString>
So far i have tried following database paths in html code
\\www10.asphost4free.com\rizzir\online.mdb
http://www10.asphost4free.com/rizzir/online.mdb
I have also tried copying my datbase into
http://www10.asphost4free.com/rizzir/online.mdb
and tried following paths for the database
\\www10.asphost4free.com\rizzir\db\online.mdb
http://www10.asphost4free.com/rizzir/db/online.mddb
I get 2 error messages
"Not a valid filename"
"Dataprovider could not be initialized"
Any idea what is causing this error. how can i fix this.
I had looked around forums but so far i had no luck.
Also reviewed
http://support.microsoft.com/kb/304324/
http://support.microsoft.com/kb/300699
but no joy
Any help would be appreciated.
Thanks
rizzir@hotmail.com