Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
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
  #1 (permalink)  
Old November 9th, 2004, 03:58 AM
Registered User
 
Join Date: Nov 2004
Location: , , .
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Default 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.

  #2 (permalink)  
Old November 9th, 2004, 06:00 AM
Friend of Wrox
 
Join Date: Jul 2004
Location: , , India.
Posts: 345
Thanks: 0
Thanked 1 Time in 1 Post
Send a message via MSN to gokul_blr Send a message via Yahoo to gokul_blr
Default

Can you please post your error messages !!!!


Gokulan Ethiraj
  #3 (permalink)  
Old November 9th, 2004, 06:47 AM
Friend of Wrox
 
Join Date: Jun 2003
Location: Bangalore, KA, India.
Posts: 2,480
Thanks: 0
Thanked 1 Time in 1 Post
Default

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
  #4 (permalink)  
Old November 9th, 2004, 10:08 AM
Registered User
 
Join Date: Nov 2004
Location: , , .
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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



  #5 (permalink)  
Old November 9th, 2004, 11:04 AM
Friend of Wrox
 
Join Date: Jun 2003
Location: Bangalore, KA, India.
Posts: 2,480
Thanks: 0
Thanked 1 Time in 1 Post
Default

Can you also post the code around line 65?

_________________________
- Vijay G
Strive for Perfection
  #6 (permalink)  
Old November 9th, 2004, 08:50 PM
Registered User
 
Join Date: Nov 2004
Location: , , .
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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

  #7 (permalink)  
Old November 10th, 2004, 10:13 AM
Registered User
 
Join Date: Nov 2004
Location: , , .
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Default

SOLVED!!!
it was the MSDART.DLL file, I found the solution at http://dotnetjunkies.com/WebLog/srir.../09/15845.aspx

It was the ODBC drivers...

Thanks



Similar Threads
Thread Thread Starter Forum Replies Last Post
Problem Connecting to BugBase DB under IIS maxshreck BOOK: ASP.NET 2.0 Instant Results ISBN: 978-0-471-74951-6 1 October 8th, 2006 07:48 PM
Connecting to Access via OLE-DB mairejo Access 3 October 26th, 2004 02:28 PM
Connecting to Access Db mattastic Classic ASP Databases 3 October 14th, 2004 02:32 AM
Connecting to another Access db with different IP ckentebe Access VBA 3 April 21st, 2004 12:08 AM
Connecting to Access DB using Visual Basic .NET Lieth Access 6 September 26th, 2003 06:17 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.