Need Help with ConnectionString Property and Access 2000

  • Thread starter Thread starter Doughboy
  • Start date Start date
D

Doughboy

Hello,

I have a web form that adds records to an Access 2000 database. The
ASP code for connecting to the database looks something like:

Dim objConn
Set objConn = Server.CreateObject("ADODB.Connection")
objConn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=C:\Documents and Settings\Username\Desktop\test.mdb"
objConn.Open

This works great if the database is on the same machine as the
webserver, but what if it resides on another PC on the WAN? Do I have
to mount a network share (Data Source = Z:\whatever), or can I use the
IP address of the remote machine (Data Source = 192.168.1.100)?

Thanks,


Doughboy
 
MindwarpLtd said:
Hi,

You should be able to specify the machine name.
\\server\whatever
Click to expand...

Do I have to mount the server first if I use this UNC syntax? I'm
trying to avoid that. Is there a way to use the IP address (or
hostname) of the remote machine?
 
Back
Top