IT_REPORT - ASP / Active Server Pages

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

Jul 19 '05 #1

Subscribe Post Reply

1479

Curt_C [MVP]

what was the error?
Sounds like you misnamed the DSN to me. Try not using a DSN though, declare
your conn string in your ASA or in the page.

--
Curt Christianson
Owner/Lead Developer, DF-Software
Site: http://www.Darkfalz.com
Blog: http://blog.Darkfalz.com
"Ice Man" <eh***@hotmail.com> wrote in message
news:Op**************@TK2MSFTNGP10.phx.gbl...

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

Jul 19 '05 #2

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")
..
..
..
----------------------------------------------------------------------------
----------------------------------------------------------------------------
----
----------------------------------------------------------------------------
----------------------------------------------------------------------------
----
"Curt_C [MVP]" <software_AT_darkfalz.com> wrote in message
news:O6****************@tk2msftngp13.phx.gbl...

what was the error?
Sounds like you misnamed the DSN to me. Try not using a DSN though, declare your conn string in your ASA or in the page.

--
Curt Christianson
Owner/Lead Developer, DF-Software
Site: http://www.Darkfalz.com
Blog: http://blog.Darkfalz.com
"Ice Man" <eh***@hotmail.com> wrote in message
news:Op**************@TK2MSFTNGP10.phx.gbl...
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

Jul 19 '05 #3

Curt_C [MVP]

uh.....ok......and?
--
Curt Christianson
Owner/Lead Developer, DF-Software
Site: http://www.Darkfalz.com
Blog: http://blog.Darkfalz.com
"Ice Man" <eh***@hotmail.com> wrote in message
news:uE**************@tk2msftngp13.phx.gbl...

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")
.
.
.
-------------------------------------------------------------------------- -- -------------------------------------------------------------------------- -- ----
-------------------------------------------------------------------------- -- -------------------------------------------------------------------------- -- ----
"Curt_C [MVP]" <software_AT_darkfalz.com> wrote in message
news:O6****************@tk2msftngp13.phx.gbl...
what was the error?
Sounds like you misnamed the DSN to me. Try not using a DSN though,

declare
your conn string in your ASA or in the page.

--
Curt Christianson
Owner/Lead Developer, DF-Software
Site: http://www.Darkfalz.com
Blog: http://blog.Darkfalz.com
"Ice Man" <eh***@hotmail.com> wrote in message
news:Op**************@TK2MSFTNGP10.phx.gbl...
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

Jul 19 '05 #4

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
"Curt_C [MVP]" <software_AT_darkfalz.com> wrote in message
news:Ow**************@TK2MSFTNGP12.phx.gbl...

uh.....ok......and?
--
Curt Christianson
Owner/Lead Developer, DF-Software
Site: http://www.Darkfalz.com
Blog: http://blog.Darkfalz.com
"Ice Man" <eh***@hotmail.com> wrote in message
news:uE**************@tk2msftngp13.phx.gbl...
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")
.
.
.

--------------------------------------------------------------------------
--

--------------------------------------------------------------------------
--
----

--------------------------------------------------------------------------
--

--------------------------------------------------------------------------
--
----
"Curt_C [MVP]" <software_AT_darkfalz.com> wrote in message
news:O6****************@tk2msftngp13.phx.gbl...
what was the error?
Sounds like you misnamed the DSN to me. Try not using a DSN though,

declare
your conn string in your ASA or in the page.

--
Curt Christianson
Owner/Lead Developer, DF-Software
Site: http://www.Darkfalz.com
Blog: http://blog.Darkfalz.com
"Ice Man" <eh***@hotmail.com> wrote in message
news:Op**************@TK2MSFTNGP10.phx.gbl...
> 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
>
>

Jul 19 '05 #5

Curt_C [MVP]

that's what I've been trying to get from the start, the error.

Try using something like

ConnString = "Provider=SQLOLEDB.1;Persist Security Info=False;" & _
"User ID='yourUserName';" & _
"Password='yourPassword';" & _
"Initial Catalog='yourDBName';" & _
"Data Source='yourServerName';"
--
Curt Christianson
Owner/Lead Developer, DF-Software
Site: http://www.Darkfalz.com
Blog: http://blog.Darkfalz.com
"Ice Man" <eh***@hotmail.com> wrote in message
news:eZ*************@TK2MSFTNGP12.phx.gbl...

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
"Curt_C [MVP]" <software_AT_darkfalz.com> wrote in message
news:Ow**************@TK2MSFTNGP12.phx.gbl...
uh.....ok......and?
--
Curt Christianson
Owner/Lead Developer, DF-Software
Site: http://www.Darkfalz.com
Blog: http://blog.Darkfalz.com
"Ice Man" <eh***@hotmail.com> wrote in message
news:uE**************@tk2msftngp13.phx.gbl...
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")
.
.
.

--------------------------------------------------------------------------
--

--------------------------------------------------------------------------
--
----

--------------------------------------------------------------------------
--

--------------------------------------------------------------------------
--
----
"Curt_C [MVP]" <software_AT_darkfalz.com> wrote in message
news:O6****************@tk2msftngp13.phx.gbl...
> what was the error?
> Sounds like you misnamed the DSN to me. Try not using a DSN though,
declare
> your conn string in your ASA or in the page.
>
> --
> Curt Christianson
> Owner/Lead Developer, DF-Software
> Site: http://www.Darkfalz.com
> Blog: http://blog.Darkfalz.com
>
>
> "Ice Man" <eh***@hotmail.com> wrote in message
> news:Op**************@TK2MSFTNGP10.phx.gbl...
> > 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
> >
> >
>
>

Jul 19 '05 #6

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" <eh***@hotmail.com> wrote in message
news:Op**************@TK2MSFTNGP10.phx.gbl...

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

Jul 19 '05 #7

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! :)

"Jeff Dillon" <je**@removeemergencyreporting.com> wrote in message
news:eZ**************@TK2MSFTNGP11.phx.gbl...

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" <eh***@hotmail.com> wrote in message
news:Op**************@TK2MSFTNGP10.phx.gbl...
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

Jul 19 '05 #8