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

[Alex71]

I have my site on one server and I need connect to DB on not same server.<br>How i do it?

 

[marshalsea]

Fun fun fun!<br><br>You need to look into ADO, and it's a fairly complicated project!<br><br>I'd solve it all, by putting it on the same server! ;-) <p>Ben Marshalsea<br><a href=mailto: > </a><br><a href= > </a><br>

 

[rpet]

hi alex!<br><br>&nbsp;&nbsp;i don't think it's a complicated project. however, it<br>looks like the responses to your previous post did not help.<br><br>&nbsp;&nbsp;all you have to do is to establish an odbc-connection<br>to the remote dbe and implement some standard asp-commands.<br>that's it.<br><br>-- ralf<br>

 

[roshan]

I also faced the same problem.I finaly I had to move the Access Database to the same server.

 

[Sensibilium]

Just create a USER DSN in your ODBC32 form Control panel on the Web Server, and then refer to it in you ASP using the DSN name you specified.<br>It really couldn't be any easier... <p>ahdkaw<br><a href=mailto:ahdkaw@sensibilium.com>ahdkaw@sensibilium.com</a><br><a href=

http://sensibilium.com/>Sensibilium</a><br>'If

you do visit my sites - be warned! You must be of a discordian nature...'

 

[vinodgk]

Well as moving the access database on the same server is the best thing to do..an i prefer using system DSN..and as far as ur DB not on the same server..i think if a DSN is created it should work..but lemme chk it up..an get back to u..<br><br>Vinod

 

[Guest_imported]

you can link to another DB on another server pointing to the DSNless or DSN connection to a virtual directory.&nbsp;&nbsp;The only problem I have had is the permission of the other server's directory. <br><br>David

 

[Karl Blessing]

If it's an Access database(not SQL or anything like that) you cannot connect remotely, access only works on the same machine. Use SQL Server if you need to connect off the machine. <p>Karl<br><a href=mailto:kb244@kb244.8m.com>kb244@kb244.8m.com</a><br><a href=

http://kb244.8m.com>

</a><br>Experienced in , or have messed with : VC++, Borland C++ Builder, VJ++6(starting),VB-Dos, VB1 thru VB6, Delphi 3 pro, Borland C++ 3(DOS), Borland C++ 4.5, HTML,Visual InterDev 6, ASP(WebProgramming), QBasic(least i didnt start with COBOL)

 

[NickBulka]

Not true.&nbsp;&nbsp;You can access an Access database on any machine on your Lan, providing the security is set up correctly. <p>nick bulka<br><a href=mailto: > </a><br><a href= > </a><br>

 

[Guest_imported]

Go to settings-&gt;control panel-&gt;odbc data sources<br>create a system dsn<br>give the path of the database by choosing the network button.<br>It also depends on the database u are using,anyway Access database can be accessed from any machine on the LAN if you have Authorisation in LAN to do so.

 

[Guest_imported]

Go to settings-&gt;control panel-&gt;odbc data sources<br>create a system dsn<br>give the path of the database by choosing the network button.<br>It also depends on the database u are using,anyway Access database can be accessed from any machine on the LAN if you have Authorisation in LAN to do so.