2. ASPRunnerPro General questions
  3. ASPRunner Preview
This topic is locked

ASPRunner Preview

 		1/27/2004 8:10:46 PM
ASPRunnerPro General questions
dcampbe11 author

For some reason, the ASPRunner preview no longer works. If I publish on my local computer running IIS the application does not work. However, if I publish the file to my Remote Web Hosting Server, the application works. I am reading and writing to a Remote SQL 2000 Server for the Database. The error I receive is when previewing in ASPRunner or when previewing in FrontPage 2003 is
error number: -2147467259

error description: [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.
All other asp application in Frontpage 2003 work when I preview on my local computer I have confirmed that the virtual server is working.
Richard <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=325&image=1&table=forumtopics' class='bbc_emoticon' alt=':blink:' />
Admin 1/27/2004

Richard,
make sure that you use SQL server authorization while connecting to SQL server.
If you need more help you can post your connection string here ( can be found in include/..._dbconnection.asp file ).
dcampbe11 author 1/27/2004

Yes, I need more help, here is my connection string:
<%

strConnection = "Provider=MSDataShape;DRIVER=SQL Server;SERVER=SQL-004.imconline.net;UID=;PWD=;APP=AspRunner Application;WSID=COBBLESTONE01;DATABASE=c2co4"

%>
I have blanked out the UID and PWD since I have posted it here .
Again, ASP Runner application only works when I upload the files to web hosting server. It does not work in ASP Runner Preview or in a Preview with Browser mode in FrontPage 2003 on my workstation.
Ricahrd
Admin 1/27/2004

Richard,
this connection string looks fine.
What connection string do you use in other ASP applications that work fine on your local box?
dcampbe11 author 1/27/2004

This was posted several weeks ago but uses another sql 2000 server. However,

when I tried to get asp runner to use this project it also no longer works with asp runner preview in broswer.
<%

strConnection = "Provider=MSDataShape;DRIVER=SQL Server;SERVER=64.224.17.175;UID=**;PWD=4;APP=AspRunner Application;WSID=COBBLESTONE01;DATABASE=bwconf2org"

%>
The only think I have done since then is add McAfee Personal Firewall. Thinking that this may be the problem I disabled but still have the problem.
Richard
Admin 1/27/2004

Richard,
make sure you can connect to this SQL Server box using SQL Query Analyzer or Enterprise Manager.
If you use antivirus software try to reboot after disabling firewall. It sounds like connection problem.
dcampbe11 author 1/27/2004

Confirmed that I can conect to the datbase using Enterprise Manager with or without the firewal active.
I disabled firewall and rebootted. Tried the ASPRunner application and same error error. Access denied
Admin 1/30/2004

Richard,
at this point I really don't know what else to try.
If ASP code works fine on your server it means something wrong with setup on your local box. Here is one more thing that you can try:
Go to ODBC Administrator panel (Start->Settings->Control Panel->Administrative tools->Data Sources(ODBC) on Win2000 box). Create new System DSN using SQL Server ODBC driver. While creating new DSN click on Client Configuration ...button and make sure that TCP/IP is choosen as Network library. After DSN created succesfully try to test ASP pages on your local box again
Let me know if you need any help doing this.