Web Wiz Support and Community Forums : Access Database Connection https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Mon, 06 Apr 2026 17:27:10 +0000 Wed, 29 Aug 2007 14:01:20 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=24284 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[Access Database Connection : DSN&#039;s are no longer a option...]]> https://forums.webwiz.net/access-database-connection_topic24284_post126945.html#126945 Author: WebWiz-Bruce
Subject: 24284
Posted: 29 August 2007 at 2:01pm

DSN's are no longer a option as this is a slower connection method and not recommended.

As long as the database is on the same server you can use the a DSN-less connection to the database which is much faster.

All good web hosts setup a separate folder for Access databases outside of your web site, so the DSN-less method will work.
]]> Wed, 29 Aug 2007 14:01:20 +0000 https://forums.webwiz.net/access-database-connection_topic24284_post126945.html#126945 <![CDATA[Access Database Connection : Okay, may have sussed this, but...]]> https://forums.webwiz.net/access-database-connection_topic24284_post126932.html#126932 Author: kazmax
Subject: 24284
Posted: 29 August 2007 at 2:07am

Okay, may have sussed this, but it requires a little surgery to the database_connection.asp script in the database folder.
 
About line 96 there is a string reference:
 
      strCon = strDbPathAndName
 
Replace with:
 
      strCon = "DSN=MyDSN"
 
About line 210:
 
      strCon = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & strCon
 
Comment that line out - the previous declaration around line 96 becomes the database connection used by the web site.
 
Haven't tried everything out with this yet, but at least with this limited change the web site came up without splashing errors onto the screen.
 
Andrew
 
]]> Wed, 29 Aug 2007 02:07:38 +0000 https://forums.webwiz.net/access-database-connection_topic24284_post126932.html#126932 <![CDATA[Access Database Connection : First, good work with releasing...]]> https://forums.webwiz.net/access-database-connection_topic24284_post126930.html#126930 Author: kazmax
Subject: 24284
Posted: 29 August 2007 at 1:48am

First, good work with releasing v9. I just happen to be setting up a forum and thought I would drop by to pick up the latest version. Good timing on my part by the looks of it!
 
Anyway, I'm slightly curious about the new database connection for Access. I thought previously I had the option of using a DSN, but it appears in this latest version that only a direct access path to the database would do (though the WebWiz knowledgebase mysteriously refers to the ISP having to set up a DSN for you...).
 
I tried setting up a DSN instead of a direct path, but it went bang when it attempted to access the database. So I'm left wondering whether I'm stuffed with using the DSN option?

Reason for asking is because my ISP provides a separate directory for Access databases which is isolated from the web site (for security reasons). Using a DSN is no problem, but using a path could lead to some interesting discoveries on my part.
 
So, will v9 support DSN's? If so how?
 
Thanks,
Andrew
 
]]> Wed, 29 Aug 2007 01:48:57 +0000 https://forums.webwiz.net/access-database-connection_topic24284_post126930.html#126930