Connecting via IP Address????

[MnM]

I'm not even sure if this can be done..hence the reason I thought I'd come here.

Here is the scenario:

I have a VB application on computer A.

I have the Access Database on computer B.

The only way I can get to the database is through computer B's IP Address. (Ex.

http://24.20.11.156/retire.mdb)

So what I am wondering is, is there a way in Visual Basic I can connect to the database via its IP Address? Like I said I'm not even sure if this can be done.

 

[culshaja]

If I remeber correctly you need either a DSN or a mapped drive to a share on that server.

James James Culshaw
jculshaw@active-data-solutions.co.uk

http://www.active-data-solutions.co.uk

http://www.brainbench.com/transcript.jsp?pid=193305

 

[vijaygopalsk]

U can do it thru the dsn by giving the ip address for the servername attribute in the dsn for eg:

ConStrEpay=driver={SQL server};server=ipaddress;UID=rapidepay;PWD=s1tart;Database=apepayp01

 

[culshaja]

The example you have gave is correct but that is for SQL Server, and the originbal question was for Access which is not a networked database.

James James Culshaw
jculshaw@active-data-solutions.co.uk

http://www.active-data-solutions.co.uk

http://www.brainbench.com/transcript.jsp?pid=193305

 

[caf]

psst my two cents

I agree with James that probably the simplest way would be to ask someone for the server's unc name. & to map a drive to the virtual folder's real path.

Another (more complex) scenario would be to write it in a client/server fashion and have an ActiveX dll sit on the server & access it via your vb app.

You could use Remote Data Services, MTS, DCOM, ASP etc to access the database through an ActiveX Dll.

Hope this helps
Craig

BTW (Remote Data Services is the simplest of the complex scenarios to implement. If you like I can provide an example)

 

[Snaggs]

Caf, Can you provide that example that you mentioned above? Thanks! Snaggs
tribesaddict@swbell.net

 

[DougP]

I am connecting to another server which is our ISP and this is the code they gave me.

this is VBscript but it should work for you.

Set Conn = server.CreateObject("ADODB.Connection&quot
Conn.Open "driver=SQL Server;server=yourserver.com;uid=user;pwd=pass;database=Universal1;"
Set RS = Conn.Execute("SELECT Count(*) AS Recs FROM [Copy-PartMaster Lite]


DougP, MCP
dposton@universal1.com

Ask me how Bar-codes can help you be more productive.

 

[caf]

Hi

Sorry snaggs for only replying now to your post but I've been a tad busy.

I'll post an example with instructions on how to implement in the new year.

Seasons greetings
caf