Connect to a Microsoft Access Database using DSN in Arvixe

Hello,

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.

Best Regards,

Richi

Looking for quality Clip-Bucket hosting? Try out Arvixe and you won’t be disappointed.
Tags: , , , , , , , , , , , , | Posted under ASP .NET 4.0, DotNet/Windows Hosting, Programming/Coding | RSS 2.0

Author Spotlight

Richi González

Richi González

I started programming when I was 12. I'm a Developer and have been working with the Clip-Bucket script since it came out. I became a Liaison between Arvixe and Clip-Bucket, so I am here to assist you with anything you need regarding Clip-Bucket or any particular computer-related subject you need. Best Regards, Richi

Leave a Reply

Your email address will not be published. Required fields are marked *


8 − = 2

You may use these HTML tags and attributes: <a href="" title="" rel=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>