Need Help With Database Connection

Author	« Topic »
jezze Ecommerce Template Expert USA 602 Posts	Posted - 11/23/2017 : 13:22:59 Hi I'm setting up an ASP store on a Windows IIS 10.0 version I used a test file with the following code to find out the database path: <HTML> <BODY> sDSN = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=<%=server.mappath("vsproducts.mdb")%>;" </BODY> </HTML> I got this below: sDSN = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\home\mysite.com\wwwroot\vsproducts.mdb;" Question, My database is located outside the root on the db folder and it is also located in the root inside the fpdb folder ( for testing) Which path should i use? I already tried all these database paths below but I still get a 500 internal error message sDSN = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\home\mysite.com\wwwroot\fpdb\vsproducts.mdb;" sDSN = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\home\mysite.com\fpdb\vsproducts.mdb;" sDSN = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\home\mysite.com\db\vsproducts.mdb;" Note: none of the above paths work, what am I missing? Jezze ASP v6.8.1 PHP v6.7.2 Edited by - jezze on 11/23/2017 13:26:41
Sinbad ECT Moderator USA 65937 Posts	Posted - 11/23/2017 : 13:31:21 Hi Jezze, 500 error is generic can you ask your host to disable friendly error messages, also can you let us know who you are hosting so we can check if others using that host have run into connection issues. Winners never quit, quitters never win CSS and Responsive Designs User Manual for Ecommerce Templates
jezze Ecommerce Template Expert USA 602 Posts	Posted - 11/23/2017 : 13:52:05 Hi Sinbad, I'm using hostek.com Jezze ASP v6.8.1 PHP v6.7.2
Sinbad ECT Moderator USA 65937 Posts	Posted - 11/23/2017 : 14:12:45 Hi in that case it should look like the following but the guys at Hostek can confrim that for you, as for the 500 you will need to ask them to disable friendly error messages also ask them to check that asp classic is enabled on the server. <% sDSN = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=d:\hosting\username\db\vsproducts.mdb;" %> Winners never quit, quitters never win CSS and Responsive Designs User Manual for Ecommerce Templates
jezze Ecommerce Template Expert USA 602 Posts	Posted - 11/23/2017 : 20:08:22 Hi Sinbad, According to hostek the problem was an incorrect provider. The following is the code for Windows servers using IIS ver 10.0 sDSN = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=d:\home\username\db\vsproducts.mdb;" I have another online store with them using IIS 8.0, so the code above only applies to IIS ver 10.0 Jezze ASP v6.8.1 PHP v6.7.2
jezze Ecommerce Template Expert USA 602 Posts	Posted - 11/23/2017 : 20:17:42 I forgot to mention that hostek found a coding error which prevented my store to function properly. In the inc/incfunctions.asp line 69 rs.open sSQL,cnn,0,1 (original code) Rs.Open sSQL,cnn,0,1, (changed code) Finally the above coding error was found on Ecommerce PlusASP v6.8.2 Jezze ASP v6.8.1 PHP v6.7.2
	« Topic »