2. ASPRunnerPro General questions
  3. APSRunnerPro does not see my DSN when starting a new project
This topic is locked

APSRunnerPro does not see my DSN when starting a new project

 		1/25/2008 4:09:39 PM
ASPRunnerPro General questions
R
 RichardS author

I just downloaded the trial version of ASPRunner. I tried many times to get the demo projects to run but have not yet been successful. I want to use an SQLExpress Database for my project and already have a database and tables setup. I created an ODBC DSN and wehn I click the Test button it confirms all is OK however when I choose the existing DSN option when setting up a new project no DSN's are available.

Can anyone tell me what I am doing wrong? I am using WinXP Pro SP2. SQLExpress 2005 set with Windows Authentication not SQL authentication. ASPRunner 5.1 build 327. IIS is also installed and working OK.

Thank you all for your support.

Richard
Sergey Kornilov admin 1/27/2008

First of all make sure you created a System DSN (as opposed to User DSN).
Also you need to turn on SQL Server authentication which is required to make generated application work properly.
R
 		RichardS author 1/30/2008

First of all make sure you created a System DSN (as opposed to User DSN).

Also you need to turn on SQL Server authentication which is required to make generated application work properly.


Thank you! It was the SQL Server authentication that got me.......