Connection String Help

This topic is locked

Connection String Help		1/2/2006 23:35:10
ASPRunnerPro General questions
A ashumak author O.K. I have searched and search, but still have trouble getting anything to work. I am trying the 4.0 beta of asprunner. I have published the files to my server, I've adjusted the connection string in login.asp, managers_dbconnection.asp, Results_dbconnection.asp, and dbconnection.asp to read as follows: dbConnection.ConnectionString = "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & server.mappath("../../fpdb/leadrunner.mdb") & ";UID=;PWD=" And still anytime I try to login, I get a "The page cannot be displayed" error Http 500 - Internal server error Internet Explorer Any help would be appreciated. The main site is designed with FP 2003 just in case this seems to be part of the problem... Alan

Mark as Solved Mark as not solved

9 replies


	Sergey Kornilov admin 1/3/2006
	Alan, you do not have to modify connection string manually. Use FTP upload feature builtin into ASPRunnerPro and choose folder on the Web server where database file should be placed. In this case ASPRunnerPro adjusts connection string automatically.


A	ashumak author 1/4/2006
	because I use Frontpage, I can't use the FTP option...server won't allow FP and FTP! I have gotten it woking though...I build to a dir and then edit the /include/dbconnection.asp... Now I need to purchase the product and start building the html around the forms.... Alan Alan, you do not have to modify connection string manually. Use FTP upload feature builtin into ASPRunnerPro and choose folder on the Web server where database file should be placed. In this case ASPRunnerPro adjusts connection string automatically.


A	ashumak author 1/4/2006
	O.K. So I had it working, and now all of a sudden I get the dreaded Internal Error 500 again. I have one section running (www.monexgroup.com/repasp/) fine, but when I load a second section, (www.monexgroup.com/teleleads/) it won't work. Connection strings for both are the same. dB is the same, but the original won't work (tele). Trying to get the boss to purchase the full version, but he isn't impressed with it going down.. Any thoughts? Alan because I use Frontpage, I can't use the FTP option...server won't allow FP and FTP! I have gotten it woking though...I build to a dir and then edit the /include/dbconnection.asp... Now I need to purchase the product and start building the html around the forms.... Alan


	Sergey Kornilov admin 1/4/2006
	Alan, I can see both URLs load fine. If you give me access to your Web server I can check what exactly is wrong.


A	ashumak author 1/5/2006
	Actually I have things going again..some times I could kick myself for not using all of my brains. just sorting out a problem with the Now() call and then hopefully edits will load properly...either that or using #01/01/2001# as a default date is wrong... Alan Alan, I can see both URLs load fine. If you give me access to your Web server I can check what exactly is wrong.


A	ashumak author 1/5/2006
	Well, still at it... keep getting the following... Microsoft OLE DB Provider for ODBC Drivers error '80040e21' Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done. /teleleads/Results_add.asp, line 1992 Suggestions? It probably has something to do with the date settings...not sure what though... Now()? Or Maybe my defaults of #01/01/2001#? Tried variations but nothing seems to clear the error... Heelp please! Alan Actually I have things going again..some times I could kick myself for not using all of my brains. just sorting out a problem with the Now() call and then hopefully edits will load properly...either that or using #01/01/2001# as a default date is wrong... Alan


A	ashumak author 1/5/2006
	Did some further checking, and found that when clicking edit, I get error 500, and advanced search as well....any suggestions on what to look at would be great! Alan


	Sergey Kornilov admin 1/5/2006
	Alan, Please zip and send generated ASP files, project file and a sample database to support@xlinesoft.com for investigation.


A	ashumak author 1/5/2006
	Sorry, I won't! Not till I purchase a full copy of the program tonight!!! The quality of product and now support you are offering/supplying has been exceptional already. I will will purchase the product, but should I keep using V4? Will the unlock allow me to use V4 without the banner showing on the asp pages? Alan Alan, Please zip and send generated ASP files, project file and a sample database to support@xlinesoft.com for investigation.

9 replies

Mark as Solved Reply