IT_REPORT

[Ice Man]

Hi all

I created a DSN called IT_REPORT which points to an access database
then I tried using asp code to open connection to it but the server gave me
error

when I changed the name to ITREPORT it worked fine

I have a personal laptop running windows 2000

what might be the problem?
Thanks in advance

 

[Ice Man]

Hi Curt

thanks for ur reply
Here is the code

----------------------------------------------------------------------------
----------------------------------------------------------------------------
----
----------------------------------------------------------------------------
----------------------------------------------------------------------------
----
<%@ Language=VBScript %>
<%Option explicit%>
<%
Dim Intra
Dim Login, pass
Dim stringSQL, results

Session("UserLoggedIn") = FALSE

Application("Conn") = "IT_Report"
Application("Usr") = ""
Application("Pwd") = ""


Set Intra = Server.CreateObject("ADODB.Connection")
Intra.Open Application("Conn"),Application("Usr"),Application("Pwd")
..
..
..

 

[Ice Man]

and ....


on line 16 which is Intra.Open
Application("Conn"),Application("Usr"),Application("Pwd")

the IE browser gives me error... mentioned in it "providor error" and the
script can't execute

Thx

 

[Jeff Dillon]

Then use ITREPORT? Sounds like it doesn't like the underscore...perhaps
it's not a valid character in the version of data access that you're using.

Or use a connection string as suggested.

Patient:

"Doctor doctor..my arm hurts when I do this"

Doctor:

"Then don't do that."

Jeff

 

[Ice Man]

Thanks for the reply Jeff...

Personally I like to know about the Big bang (if it exists) origin of
creatures secrets of religion... Beleive I can't accept that some strange
behavior of a software pass without me knowing the cause!

Just for education!