Advertisement

03.24.2008 at 04:27PM PDT, ID: 23265680
[x]
Attachment Details
[x]
The Solution Rating System

With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.

  • The Grade of the Solution
  • The Zone Rank of the Expert Providing the Solution
  • The Number of Author and Expert Comments
  • The Number of Experts Contributing
  • The Feedback of the Community

Your Input Matters
Because of the way the system is set up, the most important variable in this equation is you. As a member of Experts Exchange, you are able to cast your vote on the quality of the solutions in regard to how complete, accurate, helpful and easy to understand each solution is. When you provide your feedback, each rating is adjusted accordingly. So, if you see a solution that has a poor rating that you think is a good solution, let us know by rating it. As you do, the rating will be adjusted and will become more accurate for other members of our site.

If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support.

Thank you!
9.1

ASP Web page returns 500 error when loading, has to do with SQL Database not connecting, I believe

Zones: SQL Server 2005, Active Server Pages (ASP), Microsoft IIS Web Server
Tags: Microsoft, SQL Server 2005 Express, Ent. Server 2008, IIS 7.0, MSPress Interactive Leaning, 2005 Express, Server 2008, IIS 7.0, Office XP Step by Step Interactive Application SQL database issue
I'm attempting to run an application from Microsoft Press, "Office XP Step by Step Interactive", on a IIS 7.0 web server with SQL Server 2005 Express.  Everything appears to have been installed and the database schema was created successfully.  I can attach to the database via SQL Server Management Studio Express and view the database's, "MsPressV01", tables.  I did have to make a few changes to make the install work correctly:
    1.  Added a password to the SQL account 'sa'.
    2.  Disable the TCP dynamic Ports for all IP's
    3.  Added 1433 to the TCP Port for all IP's

In IIS I had to modify the ASP behavior to Enable Parent Paths by setting it to True.

There are two different web pages that are accessed, one for administration, 'http://server/MIT/admin/default.asp' and the other for access to the training, 'http://server/MIT/default.asp'.

When I startup the administration page '.../MIT/admin/default.asp' I get the initial screen display and I can select from the four differnent tabs, but no information is displayed.  In reviewing the log files in IIS I see the following errors listed in them.  Listed below is a partial list of the log file from IIS that I felt might help out.  I label which log file was from what web page.

When I tried to browse to the file for the user '.../MIT/main/default.asp', I get the error 500.  Listed at the very bottom of this email is the log file from IIS that has the specifics of the error.

Since the training was created by Microsoft I'm simply trying to follow their directions on the install and how it should work.  Now they do support Access databases, but I wanted to try to use SQL as I at least understand it a bit better.  I didn't know what drivers I would need to install so that I could read the *.mdb.

Any idea on if I can make this work?  I'm a compentent, but very green when it comes to all of these working together, so please be nice.  I have tried accessing this from the IE on the server running everything locally and a computer attached to the lan.  I am running AD DC on the server and I believe I have all the access rights set correctly, as they were not initially.

Thanks so very much for any help and suggestions.  

Sincerely,

Brian

Log file from IIS when attempting to browse to '.../MIT/admin/default.asp'

#Software: Microsoft Internet Information Services 7.0
#Version: 1.0
#Date: 2008-03-24 00:04:21
#Fields: date time s-ip cs-method cs-uri-stem cs-uri-query s-port cs-username c-ip cs(User-Agent) sc-status sc-substatus sc-win32-status time-taken
2008-03-24 20:18:44 fe80::417b:ed6c:2959:8175%9 GET /MIT/admin/default.asp - 80 - fe80::417b:ed6c:2959:8175%9 Mozilla/4.0+(compatible;+MSIE+7.0;+Windows+NT+6.0;+WOW64;+SLCC1;+.NET+CLR+2.0.50727;+.NET+CLR+3.0.04506;+.NET+CLR+3.5.21022) 401 3 5 0
2008-03-24 20:18:45 fe80::417b:ed6c:2959:8175%9 GET /MIT/admin/default.asp - 80 - fe80::417b:ed6c:2959:8175%9 Mozilla/4.0+(compatible;+MSIE+7.0;+Windows+NT+6.0;+WOW64;+SLCC1;+.NET+CLR+2.0.50727;+.NET+CLR+3.0.04506;+.NET+CLR+3.5.21022) 401 3 5 0
2008-03-24 20:18:46 fe80::417b:ed6c:2959:8175%9 GET /MIT/admin/default.asp - 80 - fe80::417b:ed6c:2959:8175%9 Mozilla/4.0+(compatible;+MSIE+7.0;+Windows+NT+6.0;+WOW64;+SLCC1;+.NET+CLR+2.0.50727;+.NET+CLR+3.0.04506;+.NET+CLR+3.5.21022) 401 3 5 15
2008-03-24 20:22:06 fe80::417b:ed6c:2959:8175%9 GET /MIT/admin/default.asp - 80 - fe80::417b:ed6c:2959:8175%9 Mozilla/4.0+(compatible;+MSIE+7.0;+Windows+NT+6.0;+WOW64;+SLCC1;+.NET+CLR+2.0.50727;+.NET+CLR+3.0.04506;+.NET+CLR+3.5.21022) 200 0 0 124
2008-03-24 20:22:06 fe80::417b:ed6c:2959:8175%9 GET /MIT/admin/shared/main.css - 80 - fe80::417b:ed6c:2959:8175%9 Mozilla/4.0+(compatible;+MSIE+7.0;+Windows+NT+6.0;+WOW64;+SLCC1;+.NET+CLR+2.0.50727;+.NET+CLR+3.0.04506;+.NET+CLR+3.5.21022) 304 0 0 15
2008-03-24 20:22:06 fe80::417b:ed6c:2959:8175%9 GET /MIT/admin/left.asp - 80 - fe80::417b:ed6c:2959:8175%9 Mozilla/4.0+(compatible;+MSIE+7.0;+Windows+NT+6.0;+WOW64;+SLCC1;+.NET+CLR+2.0.50727;+.NET+CLR+3.0.04506;+.NET+CLR+3.5.21022) 200 0 0 15
2008-03-24 20:22:06 fe80::417b:ed6c:2959:8175%9 GET /MIT/admin/top.asp - 80 - fe80::417b:ed6c:2959:8175%9 Mozilla/4.0+(compatible;+MSIE+7.0;+Windows+NT+6.0;+WOW64;+SLCC1;+.NET+CLR+2.0.50727;+.NET+CLR+3.0.04506;+.NET+CLR+3.5.21022) 200 0 0 218
2008-03-24 20:22:06 fe80::417b:ed6c:2959:8175%9 GET /MIT/admin/shared/top.css - 80 - fe80::417b:ed6c:2959:8175%9 Mozilla/4.0+(compatible;+MSIE+7.0;+Windows+NT+6.0;+WOW64;+SLCC1;+.NET+CLR+2.0.50727;+.NET+CLR+3.0.04506;+.NET+CLR+3.5.21022) 304 0 0 0
2008-03-24 20:22:06 fe80::417b:ed6c:2959:8175%9 GET /MIT/admin/shared/art/linkhelp.gif - 80 - fe80::417b:ed6c:2959:8175%9 Mozilla/4.0+(compatible;+MSIE+7.0;+Windows+NT+6.0;+WOW64;+SLCC1;+.NET+CLR+2.0.50727;+.NET+CLR+3.0.04506;+.NET+CLR+3.5.21022) 304 0 0 0
2008-03-24 20:22:06 fe80::417b:ed6c:2959:8175%9 GET /MIT/admin/main.asp - 80 - fe80::417b:ed6c:2959:8175%9 Mozilla/4.0+(compatible;+MSIE+7.0;+Windows+NT+6.0;+WOW64;+SLCC1;+.NET+CLR+2.0.50727;+.NET+CLR+3.0.04506;+.NET+CLR+3.5.21022) 200 0 0 202
2008-03-24 20:22:06 fe80::417b:ed6c:2959:8175%9 GET /MIT/admin/pid.vbs - 80 - fe80::417b:ed6c:2959:8175%9 Mozilla/4.0+(compatible;+MSIE+7.0;+Windows+NT+6.0;+WOW64;+SLCC1;+.NET+CLR+2.0.50727;+.NET+CLR+3.0.04506;+.NET+CLR+3.5.21022) 304 0 0 0
2008-03-24 20:22:06 fe80::417b:ed6c:2959:8175%9 GET /MIT/admin/shared/art/bigarrowleft.gif - 80 - fe80::417b:ed6c:2959:8175%9 Mozilla/4.0+(compatible;+MSIE+7.0;+Windows+NT+6.0;+WOW64;+SLCC1;+.NET+CLR+2.0.50727;+.NET+CLR+3.0.04506;+.NET+CLR+3.5.21022) 304 0 0 0
2008-03-24 20:22:06 fe80::417b:ed6c:2959:8175%9 GET /MIT/admin/shared/art/bigarrowleft2.gif - 80 - fe80::417b:ed6c:2959:8175%9 Mozilla/4.0+(compatible;+MSIE+7.0;+Windows+NT+6.0;+WOW64;+SLCC1;+.NET+CLR+2.0.50727;+.NET+CLR+3.0.04506;+.NET+CLR+3.5.21022) 304 0 0 0
2008-03-24 20:22:06 fe80::417b:ed6c:2959:8175%9 GET /MIT/admin/shared/art/bigarrowtop.gif - 80 - fe80::417b:ed6c:2959:8175%9 Mozilla/4.0+(compatible;+MSIE+7.0;+Windows+NT+6.0;+WOW64;+SLCC1;+.NET+CLR+2.0.50727;+.NET+CLR+3.0.04506;+.NET+CLR+3.5.21022) 304 0 0 0
2008-03-24 20:22:06 fe80::417b:ed6c:2959:8175%9 GET /MIT/admin/pid.js - 80 - fe80::417b:ed6c:2959:8175%9 Mozilla/4.0+(compatible;+MSIE+7.0;+Windows+NT+6.0;+WOW64;+SLCC1;+.NET+CLR+2.0.50727;+.NET+CLR+3.0.04506;+.NET+CLR+3.5.21022) 304 0 0 0
2008-03-24 20:22:06 fe80::417b:ed6c:2959:8175%9 GET /MIT/admin/shared/art/bigarrowmain.gif - 80 - fe80::417b:ed6c:2959:8175%9 Mozilla/4.0+(compatible;+MSIE+7.0;+Windows+NT+6.0;+WOW64;+SLCC1;+.NET+CLR+2.0.50727;+.NET+CLR+3.0.04506;+.NET+CLR+3.5.21022) 304 0 0 0
2008-03-24 20:22:06 fe80::417b:ed6c:2959:8175%9 GET /MIT/admin/shared/main.css - 80 - fe80::417b:ed6c:2959:8175%9 Mozilla/4.0+(compatible;+MSIE+7.0;+Windows+NT+6.0;+WOW64;+SLCC1;+.NET+CLR+2.0.50727;+.NET+CLR+3.0.04506;+.NET+CLR+3.5.21022) 200 0 64 93
2008-03-24 20:22:08 fe80::417b:ed6c:2959:8175%9 GET /MIT/admin/manageaccess/default.asp - 80 - fe80::417b:ed6c:2959:8175%9 Mozilla/4.0+(compatible;+MSIE+7.0;+Windows+NT+6.0;+WOW64;+SLCC1;+.NET+CLR+2.0.50727;+.NET+CLR+3.0.04506;+.NET+CLR+3.5.21022) 200 0 0 15
2008-03-24 20:22:08 fe80::417b:ed6c:2959:8175%9 GET /MIT/admin/shared/left.asp - 80 - fe80::417b:ed6c:2959:8175%9 Mozilla/4.0+(compatible;+MSIE+7.0;+Windows+NT+6.0;+WOW64;+SLCC1;+.NET+CLR+2.0.50727;+.NET+CLR+3.0.04506;+.NET+CLR+3.5.21022) 200 0 0 0
2008-03-24 20:22:08 fe80::417b:ed6c:2959:8175%9 GET /MIT/admin/manageaccess/top.asp - 80 - fe80::417b:ed6c:2959:8175%9 Mozilla/4.0+(compatible;+MSIE+7.0;+Windows+NT+6.0;+WOW64;+SLCC1;+.NET+CLR+2.0.50727;+.NET+CLR+3.0.04506;+.NET+CLR+3.5.21022) 200 0 0 140
2008-03-24 20:22:08 fe80::417b:ed6c:2959:8175%9 GET /MIT/admin/manageaccess/main.asp - 80 - fe80::417b:ed6c:2959:8175%9 Mozilla/4.0+(compatible;+MSIE+7.0;+Windows+NT+6.0;+WOW64;+SLCC1;+.NET+CLR+2.0.50727;+.NET+CLR+3.0.04506;+.NET+CLR+3.5.21022) 200 0 0 140
2008-03-24 20:22:08 fe80::417b:ed6c:2959:8175%9 GET /MIT/admin/shared/art/linkhome.gif - 80 - fe80::417b:ed6c:2959:8175%9 Mozilla/4.0+(compatible;+MSIE+7.0;+Windows+NT+6.0;+WOW64;+SLCC1;+.NET+CLR+2.0.50727;+.NET+CLR+3.0.04506;+.NET+CLR+3.5.21022) 304 0 0 0
2008-03-24 20:22:08 fe80::417b:ed6c:2959:8175%9 GET /MIT/admin/shared/art/logovertical.gif - 80 - fe80::417b:ed6c:2959:8175%9 Mozilla/4.0+(compatible;+MSIE+7.0;+Windows+NT+6.0;+WOW64;+SLCC1;+.NET+CLR+2.0.50727;+.NET+CLR+3.0.04506;+.NET+CLR+3.5.21022) 304 0 0 0
2008-03-24 20:22:08 fe80::417b:ed6c:2959:8175%9 GET /MIT/admin/manageaccess/courseaccess.asp |6|80004005|General_error:_Invalid_file_dsn_'' 80 - fe80::417b:ed6c:2959:8175%9 Mozilla/4.0+(compatible;+MSIE+7.0;+Windows+NT+6.0;+WOW64;+SLCC1;+.NET+CLR+2.0.50727;+.NET+CLR+3.0.04506;+.NET+CLR+3.5.21022) 500 0 0 15
2008-03-24 20:22:11 fe80::417b:ed6c:2959:8175%9 GET /MIT/admin/manageaccess/users.asp |6|80004005|General_error:_Invalid_file_dsn_'' 80 - fe80::417b:ed6c:2959:8175%9 Mozilla/4.0+(compatible;+MSIE+7.0;+Windows+NT+6.0;+WOW64;+SLCC1;+.NET+CLR+2.0.50727;+.NET+CLR+3.0.04506;+.NET+CLR+3.5.21022) 500 0 0 15
2008-03-24 20:22:12 fe80::417b:ed6c:2959:8175%9 GET /MIT/admin/manageaccess/groups.asp |6|80004005|General_error:_Invalid_file_dsn_'' 80 - fe80::417b:ed6c:2959:8175%9 Mozilla/4.0+(compatible;+MSIE+7.0;+Windows+NT+6.0;+WOW64;+SLCC1;+.NET+CLR+2.0.50727;+.NET+CLR+3.0.04506;+.NET+CLR+3.5.21022) 500 0 0 15
2008-03-24 20:22:12 fe80::417b:ed6c:2959:8175%9 GET /MIT/admin/manageaccess/globalsettings.asp |6|80004005|General_error:_Invalid_file_dsn_'' 80 - fe80::417b:ed6c:2959:8175%9 Mozilla/4.0+(compatible;+MSIE+7.0;+Windows+NT+6.0;+WOW64;+SLCC1;+.NET+CLR+2.0.50727;+.NET+CLR+3.0.04506;+.NET+CLR+3.5.21022) 500 0 0 15
2008-03-24 20:22:16 fe80::417b:ed6c:2959:8175%9 GET /MIT/admin/manageaccess/courseaccess.asp |6|80004005|General_error:_Invalid_file_dsn_'' 80 - fe80::417b:ed6c:2959:8175%9 Mozilla/4.0+(compatible;+MSIE+7.0;+Windows+NT+6.0;+WOW64;+SLCC1;+.NET+CLR+2.0.50727;+.NET+CLR+3.0.04506;+.NET+CLR+3.5.21022) 500 0 0 15
2008-03-24 20:22:17 fe80::417b:ed6c:2959:8175%9 GET /MIT/admin/manageaccess/users.asp |6|80004005|General_error:_Invalid_file_dsn_'' 80 - fe80::417b:ed6c:2959:8175%9 Mozilla/4.0+(compatible;+MSIE+7.0;+Windows+NT+6.0;+WOW64;+SLCC1;+.NET+CLR+2.0.50727;+.NET+CLR+3.0.04506;+.NET+CLR+3.5.21022) 500 0 0 15
2008-03-24 20:22:17 fe80::417b:ed6c:2959:8175%9 GET /MIT/admin/manageaccess/groups.asp |6|80004005|General_error:_Invalid_file_dsn_'' 80 - fe80::417b:ed6c:2959:8175%9 Mozilla/4.0+(compatible;+MSIE+7.0;+Windows+NT+6.0;+WOW64;+SLCC1;+.NET+CLR+2.0.50727;+.NET+CLR+3.0.04506;+.NET+CLR+3.5.21022) 500 0 0 15
2008-03-24 20:22:19 fe80::417b:ed6c:2959:8175%9 GET /MIT/admin/manageaccess/globalsettings.asp |6|80004005|General_error:_Invalid_file_dsn_'' 80 - fe80::417b:ed6c:2959:8175%9 Mozilla/4.0+(compatible;+MSIE+7.0;+Windows+NT+6.0;+WOW64;+SLCC1;+.NET+CLR+2.0.50727;+.NET+CLR+3.0.04506;+.NET+CLR+3.5.21022) 500 0 0 15


Log file from IIS when attempting to browse to '.../MIT/main/default.asp'

#Software: Microsoft Internet Information Services 7.0
#Version: 1.0
#Date: 2008-03-24 23:05:10
#Fields: date time s-ip cs-method cs-uri-stem cs-uri-query s-port cs-username c-ip cs(User-Agent) sc-status sc-substatus sc-win32-status time-taken
2008-03-24 23:05:10 fe80::417b:ed6c:2959:8175%9 GET /MIT/main/default.asp - 80 - fe80::417b:ed6c:2959:8175%9 Mozilla/4.0+(compatible;+MSIE+7.0;+Windows+NT+6.0;+WOW64;+SLCC1;+.NET+CLR+2.0.50727;+.NET+CLR+3.0.04506;+.NET+CLR+3.5.21022) 302 0 0 15
2008-03-24 23:05:10 fe80::417b:ed6c:2959:8175%9 GET /MIT/main/selection/default.asp |6|80004005|General_error:_Invalid_file_dsn_'' 80 - fe80::417b:ed6c:2959:8175%9 Mozilla/4.0+(compatible;+MSIE+7.0;+Windows+NT+6.0;+WOW64;+SLCC1;+.NET+CLR+2.0.50727;+.NET+CLR+3.0.04506;+.NET+CLR+3.5.21022) 500 0 0 0
Start your free trial to view this solution
Question Stats
Zone: Microsoft
Question Asked By: dcmense
Solution Provided By: nmcdermaid
Participating Experts: 2
Solution Grade: A
Views: 0
Translate:
Loading Advertisement...
03.24.2008 at 05:35PM PDT, ID: 21198702

Rank: Master

slamhound:

All comments and solutions are available to Premium Service Members only.

Start your 7 day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
03.24.2008 at 05:54PM PDT, ID: 21198765
dcmense:

All comments and solutions are available to Premium Service Members only.

Start your 7 day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
03.24.2008 at 09:06PM PDT, ID: 21199427

Rank: Master

nmcdermaid:

All comments and solutions are available to Premium Service Members only.

Start your 7 day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
03.25.2008 at 08:01AM PDT, ID: 21202544
dcmense:

All comments and solutions are available to Premium Service Members only.

Start your 7 day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
03.28.2008 at 09:58PM PDT, ID: 21235606

Rank: Master

nmcdermaid:

All comments and solutions are available to Premium Service Members only.

Start your 7 day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
03.29.2008 at 07:10PM PDT, ID: 21239229
dcmense:

All comments and solutions are available to Premium Service Members only.

Start your 7 day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
03.30.2008 at 02:36AM PDT, ID: 21240120

Rank: Master

nmcdermaid:

All comments and solutions are available to Premium Service Members only.

Start your 7 day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
04.04.2008 at 04:25PM PDT, ID: 21286365
dcmense:

All comments and solutions are available to Premium Service Members only.

Start your 7 day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
 
Loading Advertisement...
Microsoft
  • Internet Protocols
  • Applications
  • Development
  • OS
  • Hardware
  • Windows Security
Apple
  • Operating Systems
  • Hardware
  • Programming
  • Networking
  • Software
Internet
  • Search Engines
  • File Sharing
  • WebTrends / Stats
  • Spy / Ad Blockers
  • Web Browsers
  • New Net Users
  • Web Development
  • Chat / IM
  • Anti Spam
  • Web Servers
  • Anti-Virus
  • Email Clients
Gamers
  • Tips
  • Online / MMORPG
  • Puzzle
  • Emulators
  • Action / Adventure
  • Role Playing
  • Consoles
  • Game Programming
  • Strategy
  • Sports
  • Misc
  • Computer Games
Digital Living
  • Hardware
  • New Net Users
  • New Users
  • Software
  • Digital Music
  • Gaming World
  • Home Security
  • Apple
  • Networking Hardware
Virus & Spyware
  • Vulnerabilities
  • IDS
  • Encryption
  • Anti-Virus
  • Operating Systems Security
  • Software Firewalls
  • WebApplications
  • Cell Phones
  • Operating Systems
  • Internet
  • Hardware Firewalls
Hardware
  • Handhelds / PDAs
  • Displays / Monitors
  • Components
  • Networking Hardware
  • Peripherals
  • Laptops/Notebooks
  • Storage
  • Servers
  • Desktops
  • New Users
  • Misc
  • Apple
Software
  • System Utilities
  • Industry Specific
  • Network Management
  • Photos / Graphics
  • Page Layout
  • VMWare
  • Misc
  • Web Development
  • OS
  • CYGWIN
  • Voice Recognition
  • Message Queue
  • Quality Assurance
  • Security
  • Firewalls
  • MultiMedia Applications
  • Development
  • Database
  • Office / Productivity
  • Business Management
  • OS/2 Apps
  • Server Software
  • Internet / Email
ITPro
  • OS
  • Storage
  • Encryption
  • Operating Systems Security
  • Apple Hardware
  • Laptops & Notebooks
  • Servers
  • Networking Hardware
  • Peripherals
  • Devices
  • Displays / Monitors
  • WebTrends / Stats
  • Search Engines
  • Firewalls
  • WebApplications
  • IDS
  • Vulnerabilities
  • Email Clients
  • File Sharing
  • Spy / Ad Blockers
  • Web Browsers
  • Web Servers
  • Networking
  • Anti-Virus
  • Chat / IM
  • Anti Spam
Developer
  • Web Servers
  • Web Browsers
  • Game Programming
  • Dev Tools
  • Industry Specific
  • Office / Productivity
  • Database
  • CYGWIN
  • Web Development
  • Search Engines
  • File Sharing
  • WebTrends / Stats
  • Programming
  • Content Management
  • Application Servers
  • Protocols
Storage
  • Removable Backup Media
  • Storage Technology
  • Servers
  • Grid
  • Remote Access
  • Backup / Restore
  • Misc
  • Hard Drives
OS
  • Miscellaneous
  • Security
  • Development
  • Linux
  • VMWare
  • MainFrame OS
  • Unix
  • Apple
  • OS / 2
  • AS / 400
  • BeOS
  • Microsoft
  • VMS / OpenVMS
Database
  • Oracle
  • Miscellaneous
  • MySQL
  • Software
  • Sybase
  • Contact Management
  • PostgreSQL
  • Data Manipulation
  • Clarion
  • InterSystems Cache
  • Siebel
  • MUMPS
  • OLAP
  • SQLBase
  • SAS
  • GIS & GPS
  • 4GL
  • Berkeley DB
  • DB2
  • Informix
  • Interbase / Firebird
  • FoxPro
  • Reporting
  • LDAP
  • Filemaker Pro
  • MS SQL Server
  • dBase
  • MS Access
Security
  • Misc
  • Web Browsers
  • Software Firewalls
  • Operating Systems Security
  • File Sharing
  • Spy / Ad Blockers
  • Vulnerabilities
  • WebApplications
  • IDS
  • Anti-Virus
  • Encryption
  • Anti Spam
  • Email Clients
  • VPN
  • Chat / IM
Programming
  • Editors IDEs
  • Installation
  • Handhelds / PDAs
  • Multimedia Programming
  • System / Kernel
  • Algorithms
  • Game
  • Signal Processing
  • Project Management
  • Open Source
  • Database
  • Misc
  • Languages
  • Processor Platforms
  • Theory
Web Development
  • Scripting
  • Blogs
  • Web Servers
  • Software
  • Search Engines
  • Web Graphics
  • Images
  • Internet Marketing
  • Images and Photos
  • Components
  • Document Imaging
  • Web Languages/Standards
  • Illustration
  • WebApplications
  • Fonts
  • WebTrends / Stats
  • Authoring
  • Digital Camera Software
  • Miscellaneous
Networking
  • Protocols
  • Apple Networking
  • Network Management
  • Message Queue
  • Application Servers
  • Content Management
  • File Servers
  • Email Servers
  • Misc
  • Java Editors & IDEs
  • Wireless
  • Networking Hardware
  • Backup / Restore
  • System Utilities
  • ISPs & Hosting
  • Web Servers
  • Storage Technology
  • Removable Backup Media
  • Servers
  • Broadband
  • Grid
  • OS / 2
  • Novell Netware
  • Unix Networking
  • Windows Networking
  • Security
  • Telecommunications
  • Operating Systems
  • Linux Networking
Other
  • Community Advisor
  • Lounge
  • Community Support
  • New Net Users
  • Philosophy / Religion
  • Math / Science
  • Miscellaneous
  • URLs
  • Expert Lounge
  • Politics
  • Puzzles / Riddles
Community Support
  • Suggestions
  • New to EE
  • New Topics
  • Community Advisor
  • CleanUp
  • Announcements
  • General
  • Feedback
  • Input
  • EE Bugs
 
03.24.2008 at 05:35PM PDT, ID: 21198702

Rank: Master

slamhound:
When I browse to your admin page, I get a sort of "site comming soon" page from your host. Most of the IIS logs are DSN errors which is Domain Name Server which usually means that the domain or the files in the domain can't be found.

Can you upload a static HTML page and browse to it to confirm that the files are being stored and served where you are expecting them?
 
03.24.2008 at 05:54PM PDT, ID: 21198765
dcmense:
slamhound,

The URL are not public accessable.  When I typed the question, it converted it to a hot link.  This is all located in a intranet with no outside access.

Thanks,
Brian
 
03.24.2008 at 09:06PM PDT, ID: 21199427

Rank: Master

nmcdermaid:
Are you saying that the sample was set out for MS Access, and you are trying to set it up for SQL instead.

You need to go and find your connection strings, and change your MS Access one

(which will look something like this http://www.connectionstrings.com/?carrier=access2007)


To a SQL Server connection string:

(which will look something like this: http://www.connectionstrings.com/?carrier=sqlserver2005)


Then you'll need to change any SQL within the web pages to use SQL 2005 T-SQL dialect instead of MS Access JET SQL dialect.


It'll also help to turn on advanced error messages (or whatever its called) so you can see the error message directly in the web page.
 
03.25.2008 at 08:01AM PDT, ID: 21202544
dcmense:
nmcdermaid,

Thanks for the assistance...

The application 'interactive training' comes delivered to support Access or SQL in a network server environment.  I installed the software so that it was configured to access a SQL database.  Once I set the various parameters correctly in SQL Express, the software, 'interactive training' built the database schema just fine, all automatically.

I believe the application is having an issue using the SQL Express Server as it requires the SQLExpress in the connect statements.  I'm just guessing here as I haven't been to eager to dive into the code of the web pages.

I guess that will be my next step, unless someone can tell me how to change SQL Server Express to operate more the SQL Server 2005.

Thanks,
Brian
 
03.28.2008 at 09:58PM PDT, ID: 21235606

Rank: Master

nmcdermaid:
What exactly built the schema for you? Did your ASP application build the schema or did you you run a script (totally external to the app) to build the schema?


I can see:

   'General_error:_Invalid_file_dsn'

popping up a lot in your error messages.

This is curious as file dsn's are about the oldest and most unreliable way to connect to a database.



You'll need to work out what method your app is using to connect to your SQL Server instance. Normally you can open an ASP.Net app up in visual studio and there will be a connection string sitting somewhere just in one spot.

When you connect in management studio do you connect to something like this:

  localhost

or something like this:

  localhost\sqlexpress
 
03.29.2008 at 07:10PM PDT, ID: 21239229
dcmense:
nmcdermaid,

Thanks for the ideas, I'll check into them first thing on Monday.

As far as the schema and what built it.  The installation program for the training application is what built the database schema.  It appears as though it was an external script as it opened up a cmd window and ran some scripts.

I have looked in the ASP app, but I have  not seen the strings that you refer to.  I'll look again.

Thanks,
Brian
 
03.30.2008 at 02:36AM PDT, ID: 21240120

Rank: Master

nmcdermaid:
OK, well that at least has ascertained that the ASP app has not managed to connect at all yet.

Why don't you a search in your code on

   .DSN


A file DSN (which the error is referring to) has an extension of .DSN So if the code is trying to fins it, it'll be (incorrectly) hard coded somewhere.
Accepted Solution
 
04.04.2008 at 04:25PM PDT, ID: 21286365
dcmense:
I'm been delayed in getting to this.  Hopefully I'll get a chance in the next few days.  I'll report back what I find.
 
 
20080236-EE-VQP-29 / EE_QW_2_20070628