Web Wiz Support and Community Forums : Database System Resource Overload https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Thu, 09 Apr 2026 14:13:55 +0000 Thu, 29 Jun 2006 21:18:47 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=20353 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[Database System Resource Overload : godot wrote: Set adoCon...]]> https://forums.webwiz.net/database-system-resource-overload_topic20353_post109884.html#109884 Author: Mikey
Subject: 20353
Posted: 29 June 2006 at 9:18pm

Originally posted by godot godot wrote:

Set adoCon = Server.CreateObject("ADODB.Connection") connstr="DRIVER={Microsoft Access Driver (*.mdb)}; DBQ="C:\webspace\XYZ.com\db\XYZ.mdb" adocon.Open connstr

As far as i remember remove the " in red.

]]> Thu, 29 Jun 2006 21:18:47 +0000 https://forums.webwiz.net/database-system-resource-overload_topic20353_post109884.html#109884 <![CDATA[Database System Resource Overload : -boRg- wrote:Yes that is correct...]]> https://forums.webwiz.net/database-system-resource-overload_topic20353_post109845.html#109845 Author: godot
Subject: 20353
Posted: 29 June 2006 at 3:22pm

Originally posted by -boRg- -boRg- wrote:

Yes that is correct
 
Thanks, boRg for the help.
 
I did not change the scirpt after all as the host provider enabled the parent path. Didn't know that in Win 2003 environment, the ../ command is not supported and you have to 'enable the parent path'.
 
I suppose the example of the edited script:

Set adoCon = Server.CreateObject("ADODB.Connection") connstr="DRIVER={Microsoft Access Driver (*.mdb)}; DBQ="C:\webspace\XYZ.com\db\XYZ.mdb" adocon.Open connstr

is applicable to all situations when we map databases using the physical path.


Edited by godot - 29 June 2006 at 3:25pm]]> Thu, 29 Jun 2006 15:22:10 +0000 https://forums.webwiz.net/database-system-resource-overload_topic20353_post109845.html#109845 <![CDATA[Database System Resource Overload : Yes that is correct ]]> https://forums.webwiz.net/database-system-resource-overload_topic20353_post109828.html#109828 Author: WebWiz-Bruce
Subject: 20353
Posted: 29 June 2006 at 7:47am

Yes that is correct]]> Thu, 29 Jun 2006 07:47:52 +0000 https://forums.webwiz.net/database-system-resource-overload_topic20353_post109828.html#109828 <![CDATA[Database System Resource Overload : Set adoCon = Server.CreateObje...]]> https://forums.webwiz.net/database-system-resource-overload_topic20353_post109773.html#109773 Author: godot
Subject: 20353
Posted: 28 June 2006 at 11:32am

Set adoCon = Server.CreateObject("ADODB.Connection") connstr="DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("../../db/XYZ.mdb")adocon.Open connstr

Taking away & Server.MapPath Do you mean the edited script should read something like this:

Set adoCon = Server.CreateObject("ADODB.Connection") connstr="DRIVER={Microsoft Access Driver (*.mdb)}; DBQ="C:\webspace\XYZ.com\db\XYZ.mdb" adocon.Open connstr

]]> Wed, 28 Jun 2006 11:32:27 +0000 https://forums.webwiz.net/database-system-resource-overload_topic20353_post109773.html#109773 <![CDATA[Database System Resource Overload : Remove the part that says:-Server.MapPathThen...]]> https://forums.webwiz.net/database-system-resource-overload_topic20353_post109708.html#109708 Author: WebWiz-Bruce
Subject: 20353
Posted: 27 June 2006 at 4:19pm

Remove the part that says:-

 Server.MapPath

Then just change it to the physical server path.
]]> Tue, 27 Jun 2006 16:19:14 +0000 https://forums.webwiz.net/database-system-resource-overload_topic20353_post109708.html#109708 <![CDATA[Database System Resource Overload : I&#039;ve migrated the files to...]]> https://forums.webwiz.net/database-system-resource-overload_topic20353_post109705.html#109705 Author: godot
Subject: 20353
Posted: 27 June 2006 at 3:57pm

I've migrated the files to a win 2003 server and guess what?
As expected, there is problem with the mapping of the pathway.
 
The new server does not seem to allow the " ../ " command for the virtual pathway. Did I miss out something here?
 
I tried using the physical directory and guess what? It worked.
 
But because I have other scripts using the virtual path, i still encounter errors and can't get them to work. The alternative would be of course to make changes to the script so that it will use the physical path but I don't know how ...
 
Example:

Set adoCon = Server.CreateObject("ADODB.Connection") connstr="DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("../../db/XYZ.mdb")adocon.Open connstr

If I were to modify it to use the physical path, what do I do with the above section of the script? Or am I too presumptious to just change this section?

Help!


Edited by godot - 27 June 2006 at 3:59pm]]> Tue, 27 Jun 2006 15:57:33 +0000 https://forums.webwiz.net/database-system-resource-overload_topic20353_post109705.html#109705 <![CDATA[Database System Resource Overload : It&#039;s a posibility. I&#039;m...]]> https://forums.webwiz.net/database-system-resource-overload_topic20353_post109657.html#109657 Author: Pugnacious
Subject: 20353
Posted: 26 June 2006 at 9:00pm

It's a posibility.  I'm skilled in remote management, and it would look good on my resume. ]]> Mon, 26 Jun 2006 21:00:51 +0000 https://forums.webwiz.net/database-system-resource-overload_topic20353_post109657.html#109657 <![CDATA[Database System Resource Overload : Not unless you can work for free,...]]> https://forums.webwiz.net/database-system-resource-overload_topic20353_post109655.html#109655 Author: WebWiz-Bruce
Subject: 20353
Posted: 26 June 2006 at 8:58pm

Not unless you can work for free, the web hosting doesn't even cover the cost of servers for the the web sites already hosted and the dedicated server required for this site.]]> Mon, 26 Jun 2006 20:58:57 +0000 https://forums.webwiz.net/database-system-resource-overload_topic20353_post109655.html#109655 <![CDATA[Database System Resource Overload : Well if you ever need help, give...]]> https://forums.webwiz.net/database-system-resource-overload_topic20353_post109649.html#109649 Author: Pugnacious
Subject: 20353
Posted: 26 June 2006 at 7:39pm

Well if you ever need help, give me a shout.  I'll send you a resume.  ]]> Mon, 26 Jun 2006 19:39:07 +0000 https://forums.webwiz.net/database-system-resource-overload_topic20353_post109649.html#109649 <![CDATA[Database System Resource Overload : Not at the moment, on the web...]]> https://forums.webwiz.net/database-system-resource-overload_topic20353_post109604.html#109604 Author: WebWiz-Bruce
Subject: 20353
Posted: 26 June 2006 at 10:03am

Not at the moment, on the web hosting side, as the Windows 2003 boxes need so little attention that it only takes up a few hours, at most, of my time each month administering the windows 3003 servers once the server is setup.]]> Mon, 26 Jun 2006 10:03:45 +0000 https://forums.webwiz.net/database-system-resource-overload_topic20353_post109604.html#109604