I recently had to set up a connection to a Microsoft Access DB using DSN and as I have just a little ASP knowledge, it took me hours to figure it out. I’m writing this article as I know there might be others out there like me who need to set up a connection and don’t know how. This is how it works in Arvixe.
1. Create a ticket in our Support Suite (http://support.arvixe.com) and ask to have a DSN set up in your server. Make sure you specify the location and name of your database so we can get it up running as soon as possible.
2. Once you are told the DSN has been set up, we can now proceed with the connection code. The ASP code to use, pretending our DSN is “myarvixedsn”; user, “arvixe” and it has no password, would be:
<% Dim Conn Set Conn = Server.CreateObject("ADODB.Connection") Conn.open "myarvixedsn","arvixe","" %>
If no user and password were set, we would simply use:
<% Dim Conn Set Conn = Server.CreateObject("ADODB.Connection") Conn.open "myarvixedsn" %>
-Read more about connection strings here-
Go ahead now and test it. Works? Great. If it does not, please let me know so I can further investigate it. Feel free to post next article suggestions, comments or questions.