2. ASPRunnerPro General questions
  3. SQL Server 2005/IIS
This topic is locked

SQL Server 2005/IIS

 		5/20/2009 15:04:51
ASPRunnerPro General questions
D
 deeg author

I am attempting to build a simple project with a single table. I am new to SQL Server and very comfortable with MS Access.

  • I selected ODBC Driver dialog and connected to SQL Server > entered server name> login name and password> selected the database>
  • When I go to build the application using IIS the files do not show the ODBC connection. I thought I already connected at the beginning of the process. (forgive me if this sounds elementary). Voila - I am able to see the table.
  • I select fields and design interface
  • On the build page, I identify the virtual directory (IIS) and then build.


It will not display the data. I also do not see a db folder - is that because I am not connecting to the db on the local machine but directly from the SQL Server? Isn't it suppose to include the connection in the .asp pages?
Please help?
Should I be using another option to connect to the SQL Server in ASP Runner?
Sergey Kornilov admin 5/20/2009

What exactly do you see viewing generated application in the browser? Any error messages?
D
 		deeg author 5/21/2009

What exactly do you see viewing generated application in the browser? Any error messages?


I see the HTTP 500 Internal Server error
Sergey Kornilov admin 5/21/2009

Turn off "Show friendly HTTP error messages" in Internet Explorer to see the actual error message.
D
 		deeg author 5/27/2009

Turn off "Show friendly HTTP error messages" in Internet Explorer to see the actual error message.


The log file indicates the following message: The_user_is_not_associated_with_a_trusted_SQL_Server_connection
Sergey Kornilov admin 5/27/2009

This article should help:

http://www.xlinesoft.com/asprunnerpro/docs...achine_name.htm