Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > ASP.NET and ASP > ASP 3 Classic ASP Active Server Pages 3.0 > Classic ASP Databases
Password Reminder
Register
| FAQ | Members List | 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 tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Search this Thread Display Modes
  #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.

Reply With Quote
  #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
Reply With Quote
  #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
Reply With Quote
  #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



Reply With Quote
  #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
Reply With Quote
  #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

Reply With Quote
  #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

Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


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



All times are GMT -4. The time now is 04:14 AM.


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