<div>
Did you mean 'URL' or 'UNC' ? <br />
Basically with UNC (//servername/sharename/da<wbr />tabase.mdb<wbr />) it should work, IF...<br />
<br />
the process running the ASP has enough credentials to access the remote server. After all its logon is being used,<br />
UNC addressing for a file is quite similar to first running a NET USE and then prefixing the file with a drivelletter.<br />
And of course, //servername &nbsp;is preferably to be found through DDNS - although you could also use the IP address instead of the name.<br />
<br />
Hope thiz helpz,<br />
<br />
&lt;Erik&gt; - The Netherlands<br />
<br />

</div>


Did you mean 'URL' or 'UNC' ?
Basically with UNC (//servername/sharename/database.mdb) it should work, IF...

the process running the ASP has enough credentials to access the remote server. After all its logon is being used,
UNC addressing for a file is quite similar to first running a NET USE and then prefixing the file with a drivelletter.
And of course, //servername  is preferably to be found through DDNS - although you could also use the IP address instead of the name.

Hope thiz helpz,

<Erik> - The Netherlands



<div>
No, I want to access the database through a URL if possible since the database is on a server outside the company network
</div>


No, I want to access the database through a URL if possible since the database is on a server outside the company network

<div>
Thanks, sorry I took so long to answer.
</div>


<div>
<div class="content wysiwyg-content">
Hello,<br />
<br />
I aould like to access an Access 2000 database remotely usign an ASP web page (uses VBScript). Currently I use this code to access a local database :<br />
<br />
Set DBCon = Server.CreateObject(&quot;ADODB<wbr />.Connectio<wbr />n&quot;)<br />
&nbsp; With DBcon<br />
&nbsp; &nbsp;.Provider = &quot;Microsoft.Jet.OLEDB.4.0&quot;<br />
&nbsp; &nbsp;.open server.mappath(&quot;database.m<wbr />db&quot;)<br />
&nbsp; end with &nbsp;<br />
<br />
Is there any way I can access a database on another server? I tried using a URL in the open command but it didn't work.<br />
<br />
Thanks
</div>
</div>


Hello,

I aould like to access an Access 2000 database remotely usign an ASP web page (uses VBScript). Currently I use this code to access a local database :

Set DBCon = Server.CreateObject("ADODB.Connection")
  With DBcon
   .Provider = "Microsoft.Jet.OLEDB.4.0"
   .open server.mappath("database.mdb")
  end with  

Is there any way I can access a database on another server? I tried using a URL in the open command but it didn't work.

Thanks

Accessing a database remotely using ASP

Web development software is used to create websites for both the Internet and intranets. Software can be either locally installed or operated through a cloud interface, and ranges in complexity from simple text editors to full-fledged integrated development environments (IDEs) that include graphics, video, audio, scripting and database support.