How I can connect to Accses Database on not same server?

[Alex71]

Hi i want to connect to DB on another server.<br>I have DSN and Path.<br>How i can do it?

 

[rpet]

setup an odbc-connection to the db and use e.g.:<br><br><FONT FACE=monospace><br>Set CON = Server.CreateObject(&quot;ADODB.Connection&quot<br>CON.Open &quot;DSN=ODBC_Connection_Name&quot;<br></font><br><br>so you can connect to the dbe on the remote server.<br>or what does &quot;another&quot; server means??<br><br>

 

[NickBulka]

Just make sure the security settings on the remote serve will allow you access. <p>nick bulka<br><a href=mailto: > </a><br><a href= > </a><br>

 

[imstillatwork]

why not map the drive from the other computer to the

http://www server

and use the absolute path in the connection string