Networking With Vb6

[darrel]

Hello there VB wizards. I have a few questions, regarding how networking works with Visual Basic. It's like this - I have a PC that has the database of all my system. It's like a central database pc. Now I want to know how I can access those databases in another PC. For able for me to me achieve network.

By the way, the databases that are in the central database PC are all Access.

Another question; Will App Path work in accessing another pc?

Can someone guide me to the right path, or give some sites or tutorials on how I can achieve my goal?

Thank you very much.

Looking forward for some tips...

[debasisdas]

To access the MDB files you need to specify either the system name or ipaddress from the client pc.

better to put the database files in a shared with password for database.

[darrel]

Thank you for that information, but how can i achieve it, can you give me some example codes of that, or could you give some tutorials or site on how to do it.. Thank you very much...

[darrel]

Hi guys so far this is the code i have, but it gives me an error that the path name is not valid

Set cnn = New ADODB.Connection
cnn.ConnectionString = _
 "Provider=Microsoft.Jet.OLEDB.4.0;" & _
          "Data Source=" & App.Path & "\\192.168.1.60\C:\My Documents\DentalDB.mdb;"
cnn.Open

192.168.1.60 is the ip address of the computer where the DentalDB.mdb is located...

i think my format is incorrect... Can you give mea little information about this matter.. Thank you.

[Killer42]

"Data Source=" & App.Path & "\\192.168.1.60 \C:\My Documents\Denta lDB.mdb;"

My guess is you should be using either the IP address or App.Path, not both.

[darrel]

Networking With Vb6

Hey Guys i already achieve what i want i was able to access my database for different a computer/s... To share with you,, heres my code...

Dim cnn As New ADODB.Connection
Dim Str As String

Set cnn = New ADODB.Connection
Str = "\\Lbv\shareddocs\DentalDB.mdb"
cnn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Str + ";Persist Security Info=False"
cnn.CursorLocation = adUseClient

Where Lbv is the Computer Name, shareddocs is the folder name, and DentalDb.mdb is the database itself...

I hope it can contribute.... To all who replied.. Thank you.!!!

[Killer42]

Thanks for sharing. That could be useful for anyone with similar problems in future.

The more people who contribute, the better it gets. :)