Web Wiz Forums - Database Connection String problem

Print Page | Close Window

Database Connection String problem

Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=3012
Printed Date: 01 April 2026 at 6:16am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Database Connection String problem

Posted By: Michael Jr.
Subject: Database Connection String problem
Date Posted: 25 May 2003 at 12:23pm

I'm hosting on a paid premium Brinkster account. I'm having trouble with the site news app, specifically in the common.asp and site_news_preview.asp line:

strCon = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("what do I put here?")

do I put path: file://\\premfs2\sites\premium7\username\database\news.mdb - \\premfs2\sites\premium7\username\database\news.mdb ; of course I put my username in but then I get an invalid "/" or "\".

This worked for the forum, but the string was different. I have also tried \database\news.mdb; path but I get "[Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0x758 Thread 0xcc0 DBC 0xbaf0024 Jet'."

any help is GREATLY appreciated!

Replies:

Posted By: michael
Date Posted: 25 May 2003 at 1:19pm

I am not sure what the folders look like on a paid brinkster account but in general you need to put the virtual path to your database there. So e.g.

strCon = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("database/mydb.mdb")

Alternatively you can also use a physical path (I don't know if Brinketer allows that:

strCon = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=c:\mypath\myfolder\database\mydb.mdb

-------------
http://baumannphoto.com" rel="nofollow - Blog | http://mpgtracker.com" rel="nofollow - MPG Tracker

Posted By: Michael Jr.
Date Posted: 25 May 2003 at 6:47pm

Ok, I put in

strCon = ("DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=\\premfs2\sites\Premium7\myusername\Database\news.mdb")

This worked, but when I click on "Full Story" IE goes to download the actual new page to my hard drive. Any suggestions?

Posted By: michael
Date Posted: 25 May 2003 at 7:20pm

OK I am confused, why are you using a UNC path? and usually if IE is to download an asp page it means the server is not asp enabled thus if you are talking about the news script you would have to be able to see the initial news list....

-------------
http://baumannphoto.com" rel="nofollow - Blog | http://mpgtracker.com" rel="nofollow - MPG Tracker

Posted By: Michael Jr.
Date Posted: 25 May 2003 at 9:02pm

I was using that because I have no idea what I'm doing!

I was able to figure it out though. I put in the URl instead of the c:// path. Seems to work fine now.