Ad:

Visual Basic 4 / 5 / 6 Discussion Thread
Unsolved
Views: 1357

Oct 18th, 2007

Getting path of host machine in VB when a client accesses the exe over the network

Expand Post »

Hi,
I am creating a small application which connects to an MS access database.
I am using app to get the path of the mdb. This works fine when I am accessing the exe from my own machine.
When I share the folder containing the exe and access it over the LAN, app looks for the mdb in the client machine. How do I reference the mdb on server?

Following is the code for db connection:

Visual Basic 4 / 5 / 6 Syntax (Toggle Plain Text)
'Module to connect to the database.
Sub db_connect()
Dim AccessConnect As String
Dim sPath As String
 
sPath = App.Path & "/../MasterDB"
 
AccessConnect = "Driver={Microsoft Access Driver (*.mdb)};" & _
                     "Dbq=My_Master.mdb;" & _
                     "DefaultDir=" & sPath & ";" & _
                     "Uid=;Pwd=test123;"
 
con.ConnectionString = AccessConnect
con.Open
End Sub
'Module to connect to the database.
Sub db_connect()
Dim AccessConnect As String
Dim sPath As String

sPath = App.Path & "/../MasterDB"

AccessConnect = "Driver={Microsoft Access Driver (*.mdb)};" & _
                     "Dbq=My_Master.mdb;" & _
                     "DefaultDir=" & sPath & ";" & _
                     "Uid=;Pwd=test123;"
                     
con.ConnectionString = AccessConnect
con.Open
End Sub

Can anyone please guide me ahead?
Regards,
ss

Similar Threads

This is a wierd one! in Windows NT / 2000 / XP
System 32 Coming Up at Startup in Viruses, Spyware and other Nasties
Zone Alarm Security Alerts. in Viruses, Spyware and other Nasties
Networking 2 XP Machines with crossover cable and 2 Realtek Cards in Networking
How can I delete Hosts: 1159680172 auto.search.msn.com? in Viruses, Spyware and other Nasties

snehas

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

2 posts
since Oct 2007

Permalink

Oct 19th, 2007

Re: Getting path of host machine in VB when a client accesses the exe over the network

instead of sPath = App.Path & "/../MasterDB"
use sPath = "\\SERVER\...\MasterDB.MDB"

dilip_singh3

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

24 posts
since Oct 2007

Permalink

Oct 19th, 2007

Re: Getting path of host machine in VB when a client accesses the exe over the network

Thanks Dilip. I tried this. Didn't seem to work.

I am thinking of using a config file to get the path. Couldn't find any other way.
Regards,
ss

snehas

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

2 posts
since Oct 2007

Permalink

Nov 2nd, 2007

Re: Getting path of host machine in VB when a client accesses the exe over the network

config file is the best way to get the path. You can read file easily

vijay.wadikar

Reputation Points: 10

Solved Threads: 1

Newbie Poster

Offline

4 posts
since Oct 2007

Permalink

Nov 5th, 2007

Re: Getting path of host machine in VB when a client accesses the exe over the network

Have you ever tried the WINSOCK component?

ryan_vietnow

Reputation Points: 28

Solved Threads: 71

Posting Pro

Offline

578 posts
since Aug 2007

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in Visual Basic 4 / 5 / 6 Forum Timeline: Oracle to visual basic

Next Thread in Visual Basic 4 / 5 / 6 Forum Timeline: Displaying data in a form

DaniWeb Message

Cancel Changes

User Name
Password