Whats your problem? What errors are you getting? You are going to have to provide us with more information.
sir,
i have made a windows application in vb6 with database in ms access,
now i want to make my database centralised(means: it could be accessible from any where in the world using internet)......for this purpose some one has suggested me to place my database on web database hosting server...
and from there i could access my database using the url provided by the web hosting server provider...
but before that i am trying to access my localhost server present on IIS ,
there i have placed my database and accessing it from my vb6 application....
i have tried the followling code...
{ With Adodc1
.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\\http:\\localhost\Soap3DocSamples\Database \Patient.mdb;Persist Security Info=False"
SQL_3 = "select PatientID,FirstName, LastName, Age, Sex, Address, City, State, Country, HomePhone, MobilePhone, PostalCode, Heridatery, Bio_history, Allergies from Patient where Patient.PatientID=" & Text6.Text
.RecordSource = SQL_3
.Refresh
End With)
but this code is giving error...{
"\\http:\\localhost\Soap3DocSamples\Database\Patie n t.mdb" is not a valid path.Make sure that path name is spelled correctly and that you are connected to the server on which the file resides" )
i also want to tell u that when i type "http:\\localhost\Soap3DocSamples\Database" on address bar of my internet explorer i am getting a HTML page on which a link for my database file "Patient.mdb" appears and on clicking that it gets open...
please tell me whether my approach is wrong or there is some error in codes......
also provide me with other alternatives to make my database centralised.......
thank you for your interest....
5
