 |
| Classic ASP Databases Discuss using ASP 3 to work with data in databases, including ASP Database Setup issues from the old P2P forum on this specific subtopic. See also the book forum Beginning ASP.NET Databases for questions specific to that book. NOT for ASP.NET 1.0, 1.1, or 2.0. |
Welcome to the p2p.wrox.com Forums.
You are currently viewing the Classic ASP Databases section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
|
|
|
|
November 9th, 2004, 03:58 AM
|
|
Registered User
|
|
Join Date: Nov 2004
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
Trouble connecting to Access DB thru IIS
Hi, I just got a new laptop and installed XP Pro to create my IIS development environment like I have on my desktop. I moved over some projects and then created the System DSN's I was using. Mimicking everything, I was surprised to get an error when I tried to load a dynamic page. It seems that no connection string works, neither DSN nor DSN'less, my pages load fine without any conn strings (IIS works fine). I have a problem with my IIS connecting to ODBC or something weird. I know it's just a setting, but I can't figure this out. Just wasted half the day on it and have given up... Please help.
|
|
November 9th, 2004, 06:00 AM
|
|
Friend of Wrox
|
|
Join Date: Jul 2004
Posts: 345
Thanks: 0
Thanked 1 Time in 1 Post
|
|
Can you please post your error messages !!!!
Gokulan Ethiraj
|
|
November 9th, 2004, 06:47 AM
|
|
Friend of Wrox
|
|
Join Date: Jun 2003
Posts: 2,480
Thanks: 0
Thanked 1 Time in 1 Post
|
|
Quote:
|
quote:was surprised to get an error when I tried to load a dynamic page
|
It is not that easy to predict thing without know what it erred out. May be you can post the exact error that you see when trying to do so.
_________________________
- Vijay G
Strive for Perfection
|
|
November 9th, 2004, 10:08 AM
|
|
Registered User
|
|
Join Date: Nov 2004
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
Hi, Sorry;
(it doesn't give a full error type...)
HTTP 500.100 - Internal Server Error - ASP error
Internet Information Services
--------------------------------------------------------------------------------
Technical Information (for support personnel)
Error Type:
(0x8007007F)
/assets/include/FWD_Common.asp, line 65
Browser Type:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; .NET CLR 1.1.4322)
Page:
GET /content/teamxl_admin.asp
Time:
Wednesday, November 10, 2004, 1:04:44 AM
More information:
Microsoft Support
|
|
November 9th, 2004, 11:04 AM
|
|
Friend of Wrox
|
|
Join Date: Jun 2003
Posts: 2,480
Thanks: 0
Thanked 1 Time in 1 Post
|
|
Can you also post the code around line 65?
_________________________
- Vijay G
Strive for Perfection
|
|
November 9th, 2004, 08:50 PM
|
|
Registered User
|
|
Join Date: Nov 2004
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
The code works on my desktop and the remote server, this code is used across dozens of sites without issue, but none of these sites work on my laptop, so it's not the conn string... anyway;
FunKey_Conn_String = "dsn=teamxl;"
Set objConn=Server.CreateObject("ADODB.Connection")
objConn.ConnectionTimeout=60
objConn.Open FunKey_Conn_STRING
I try dsn'less conns too, nothing works. it's gotta be the drivers...
It appears that it has to do with the ODBC drivers which may not have installed properly, but downloading them again from MS doesn't work... Maybe reinstall IIS?
I really appreciate your help!
Cheers,
Brad
|
|
|
