using web database hosting throug vb6

[alfaas]

Hi,

I need someone who could help my problem in connecting the database from
Web Hosting Server using my vbapp.


Please Help!!!

Thanks

[Stang02GT]

Whats your problem? What errors are you getting? You are going to have to provide us with more information.

[alfaas]

sir,
i have made a windows application in vb6 with database in ms access,
now i want to make my database centralised(mea ns: 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

.ConnectionStri ng = "Provider=Micro soft.Jet.OLEDB. 4.0;Data Source=\\http:\ \localhost\Soap 3DocSamples\Dat abase\Patient.m db;Persist Security Info=False"



SQL_3 = "select PatientID,First Name, LastName, Age, Sex, Address, City, State, Country, HomePhone, MobilePhone, PostalCode, Heridatery, Bio_history, Allergies from Patient where Patient.Patient ID=" & Text6.Text

.RecordSource = SQL_3



.Refresh
End With)

but this code is giving error...{
"\\http:\\local host\Soap3DocSa mples\Database\ Patient.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:\\localho st\Soap3DocSamp les\Database" on address bar of my internet explorer i am getting a HTML page on which a link for my database file "Patient.md b" 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....

[alfaas]

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(mea ns: 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

.ConnectionStri ng = "Provider=Micro soft.Jet.OLEDB. 4.0;Data Source=\\http:\ \localhost\Soap 3DocSamples\Dat abase \Patient.mdb;Pe rsist Security Info=False"



SQL_3 = "select PatientID,First Name, LastName, Age, Sex, Address, City, State, Country, HomePhone, MobilePhone, PostalCode, Heridatery, Bio_history, Allergies from Patient where Patient.Patient ID=" & Text6.Text

.RecordSource = SQL_3



.Refresh
End With)

but this code is giving error...{
"\\http:\\local host\Soap3DocSa mples\Database\ Patien 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:\\localho st\Soap3DocSamp les\Database" on address bar of my internet explorer i am getting a HTML page on which a link for my database file "Patient.md b" 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....