473,320 Members | 1,978 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Networking With Vb6

72
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...
Dec 11 '07 #1
6 5319
debasisdas
8,127 Expert 4TB
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.
Dec 11 '07 #2
darrel
72
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...
Dec 12 '07 #3
darrel
72
Hi guys so far this is the code i have, but it gives me an error that the path name is not valid

Expand|Select|Wrap|Line Numbers
  1. Set cnn = New ADODB.Connection
  2. cnn.ConnectionString = _
  3.  "Provider=Microsoft.Jet.OLEDB.4.0;" & _
  4.           "Data Source=" & App.Path & "\\192.168.1.60\C:\My Documents\DentalDB.mdb;"
  5. cnn.Open
  6.  
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.
Dec 14 '07 #4
Killer42
8,435 Expert 8TB
"Data Source=" & App.Path & "\\192.168.1.60\C:\My Documents\DentalDB.mdb;"
My guess is you should be using either the IP address or App.Path, not both.
Dec 14 '07 #5
darrel
72
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...

Expand|Select|Wrap|Line Numbers
  1. Dim cnn As New ADODB.Connection
  2. Dim Str As String
  3.  
  4. Set cnn = New ADODB.Connection
  5. Str = "\\Lbv\shareddocs\DentalDB.mdb"
  6. cnn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Str + ";Persist Security Info=False"
  7. cnn.CursorLocation = adUseClient
  8.  
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.!!!
Dec 17 '07 #6
Killer42
8,435 Expert 8TB
Thanks for sharing. That could be useful for anyone with similar problems in future.

The more people who contribute, the better it gets. :)
Dec 17 '07 #7

Sign in to post your reply or Sign up for a free account.

Similar topics

1
by: hyperbob | last post by:
Hello, I'm in the design stage of an application that will consist of two or more processes that will be either on different computers in a network or on the same computer and will have to...
6
by: James Egan | last post by:
I've seen some networking toolkits for C++, but was wondering if there were (or plans for) a standard set of networking classes for C++? Also, can someone tell me where I can find a...
7
by: Brian Keogh | last post by:
Hi, I'm a student learning TCP/IP networking at University. Although I understand all about TCP/IP Networking in Java I am expected to understand the basics of C with regard to these programs as...
46
by: H.A. Sujith | last post by:
Why doesn't the standard library provide (at least basic) networking facilities using TCP/IP ?
4
by: Raj | last post by:
I want to program C with networking. Can anyone tell me the How to start with a small simple program can it possible in turbo/borland c 3+. or i should go for another verson. i am using windows...
0
by: petro | last post by:
I am trying to deploy an asp.net application to my web server. My application uses system.data.oledb to connect to an oracle database. On my development machine I have the oracle client 10g...
2
by: JCB19 | last post by:
I need help networking my HP DV4000 laptop to my home network. I have wireless home network with 3 computers using Linksys Wireless G The laptop has built in wireless capability. I want to...
1
by: ebrimagillen | last post by:
Want to know the difference between URL networking and Socket networking. Also and example from each and the networking technique is most appropriate for the example.
1
by: chinaemerem ibeawuchi | last post by:
What is the difference between URL networking and Socket networking? with an example of each type and state why the choosen networking technique is most appropriate for the example.
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.