Web Development

Ask something
Discussion Locked

Problem seeing DSN

0 helpful
6 replies

by munrrob

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I have an ASP page written with VBScript which has been tested on my laptop running Personal Web Server.
I have moved the files onto the company intranet, set up the DSN connection on the server the files are located on and tried to run the pages. I get the following error:

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

/information/QEV/default.asp, line 16

Anyone got any idea why?

6 replies

by techrep

You don't say what server operating system you are using or what web server product, but I assume you're using a Windows operating system and Internet Information Server as your web server.

Did you create the Data Source name on your intranet server? The program seems to be unable to find the DSN name on your server. Another possibility might be that you don't have the OLE DB driver files installed on the server. Are you able to run any other ASP pages on the server that read from a database? Your program is failing at line 16, but the error may actually be somewhere before that line.

These are just some ideas to get started. Please give us more information.

by munrrob

Sorry for the lack of info. Yes, I am running IIS on Windows 2k. Front page extensions are loaded on the server. The DSN is on the intranet server.
I have narrowed the problem down to the page not being able to see the global.asa file. Any ideas?

by techrep

OK, I've seen this problem before with global.asa. Are you referencing global.asa in your asp code? Take it out. You probably don't need global.asa at all.

Another possibility, copy the global.asa file to the same directory as your program and make sure your reference in your code points to that file.

This discussion is closed to new replies.