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

[Curt_C [MVP]]

Re: IT_REPORT

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" <ehc00@hotmail. com> wrote in message
news:OpbGPk9bEH A.3804@TK2MSFTN GP10.phx.gbl...[color=blue]
> 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[/color]
me[color=blue]
> 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
>
>[/color]

[Ice Man]

Re: IT_REPORT

Hi Curt

thanks for ur reply
Here is the code

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

Session("UserLo ggedIn") = FALSE

Application("Co nn") = "IT_Report"
Application("Us r") = ""
Application("Pw d") = ""


Set Intra = Server.CreateOb ject("ADODB.Con nection")
Intra.Open Application("Co nn"),Applicatio n("Usr"),Applic ation("Pwd")
..
..
..
----------------------------------------------------------------------------
----------------------------------------------------------------------------
----
----------------------------------------------------------------------------
----------------------------------------------------------------------------
----
"Curt_C [MVP]" <software_AT_da rkfalz.com> wrote in message
news:O65339%23b EHA.3988@tk2msf tngp13.phx.gbl. ..[color=blue]
> what was the error?
> Sounds like you misnamed the DSN to me. Try not using a DSN though,[/color]
declare[color=blue]
> 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" <ehc00@hotmail. com> wrote in message
> news:OpbGPk9bEH A.3804@TK2MSFTN GP10.phx.gbl...[color=green]
> > 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[/color]
> me[color=green]
> > 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
> >
> >[/color]
>
>[/color]

[Curt_C [MVP]]

Re: IT_REPORT

uh.....ok...... and?


--
Curt Christianson
Owner/Lead Developer, DF-Software
Site: http://www.Darkfalz.com
Blog: http://blog.Darkfalz.com


"Ice Man" <ehc00@hotmail. com> wrote in message
news:uEplkQ$bEH A.1048@tk2msftn gp13.phx.gbl...[color=blue]
> Hi Curt
>
> thanks for ur reply
> Here is the code
>
> --------------------------------------------------------------------------[/color]
--[color=blue]
> --------------------------------------------------------------------------[/color]
--[color=blue]
> ----
> --------------------------------------------------------------------------[/color]
--[color=blue]
> --------------------------------------------------------------------------[/color]
--[color=blue]
> ----
> <%@ Language=VBScri pt %>
> <%Option explicit%>
> <%
> Dim Intra
> Dim Login, pass
> Dim stringSQL, results
>
> Session("UserLo ggedIn") = FALSE
>
> Application("Co nn") = "IT_Report"
> Application("Us r") = ""
> Application("Pw d") = ""
>
>
> Set Intra = Server.CreateOb ject("ADODB.Con nection")
> Intra.Open Application("Co nn"),Applicatio n("Usr"),Applic ation("Pwd")
> .
> .
> .
> --------------------------------------------------------------------------[/color]
--[color=blue]
> --------------------------------------------------------------------------[/color]
--[color=blue]
> ----
> --------------------------------------------------------------------------[/color]
--[color=blue]
> --------------------------------------------------------------------------[/color]
--[color=blue]
> ----
> "Curt_C [MVP]" <software_AT_da rkfalz.com> wrote in message
> news:O65339%23b EHA.3988@tk2msf tngp13.phx.gbl. ..[color=green]
> > what was the error?
> > Sounds like you misnamed the DSN to me. Try not using a DSN though,[/color]
> declare[color=green]
> > 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" <ehc00@hotmail. com> wrote in message
> > news:OpbGPk9bEH A.3804@TK2MSFTN GP10.phx.gbl...[color=darkred]
> > > 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[/color][/color][/color]
gave[color=blue][color=green]
> > me[color=darkred]
> > > 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
> > >
> > >[/color]
> >
> >[/color]
>
>[/color]

[Ice Man]

Re: IT_REPORT

and ....


on line 16 which is Intra.Open
Application("Co nn"),Applicatio n("Usr"),Applic ation("Pwd")

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

Thx


"Curt_C [MVP]" <software_AT_da rkfalz.com> wrote in message
news:Ow4NVT$bEH A.2660@TK2MSFTN GP12.phx.gbl...[color=blue]
> uh.....ok...... and?
>
>
> --
> Curt Christianson
> Owner/Lead Developer, DF-Software
> Site: http://www.Darkfalz.com
> Blog: http://blog.Darkfalz.com
>
>
> "Ice Man" <ehc00@hotmail. com> wrote in message
> news:uEplkQ$bEH A.1048@tk2msftn gp13.phx.gbl...[color=green]
> > Hi Curt
> >
> > thanks for ur reply
> > Here is the code
> >[/color]
>
> --------------------------------------------------------------------------
> --
>
> --------------------------------------------------------------------------
> --[color=green]
> > ----[/color]
>
> --------------------------------------------------------------------------
> --
>
> --------------------------------------------------------------------------
> --[color=green]
> > ----
> > <%@ Language=VBScri pt %>
> > <%Option explicit%>
> > <%
> > Dim Intra
> > Dim Login, pass
> > Dim stringSQL, results
> >
> > Session("UserLo ggedIn") = FALSE
> >
> > Application("Co nn") = "IT_Report"
> > Application("Us r") = ""
> > Application("Pw d") = ""
> >
> >
> > Set Intra = Server.CreateOb ject("ADODB.Con nection")
> > Intra.Open Application("Co nn"),Applicatio n("Usr"),Applic ation("Pwd")
> > .
> > .
> > .[/color]
>
> --------------------------------------------------------------------------
> --
>
> --------------------------------------------------------------------------
> --[color=green]
> > ----[/color]
>
> --------------------------------------------------------------------------
> --
>
> --------------------------------------------------------------------------
> --[color=green]
> > ----
> > "Curt_C [MVP]" <software_AT_da rkfalz.com> wrote in message
> > news:O65339%23b EHA.3988@tk2msf tngp13.phx.gbl. ..[color=darkred]
> > > what was the error?
> > > Sounds like you misnamed the DSN to me. Try not using a DSN though,[/color]
> > declare[color=darkred]
> > > 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" <ehc00@hotmail. com> wrote in message
> > > news:OpbGPk9bEH A.3804@TK2MSFTN GP10.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[/color][/color]
> gave[color=green][color=darkred]
> > > 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
> > > >
> > > >
> > >
> > >[/color]
> >
> >[/color]
>
>[/color]

[Curt_C [MVP]]

Re: IT_REPORT

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

Try using something like

ConnString = "Provider=SQLOL EDB.1;Persist Security Info=False;" & _
"User ID='yourUserNam e';" & _
"Password='your Password';" & _
"Initial Catalog='yourDB Name';" & _
"Data Source='yourSer verName';"


--
Curt Christianson
Owner/Lead Developer, DF-Software
Site: http://www.Darkfalz.com
Blog: http://blog.Darkfalz.com


"Ice Man" <ehc00@hotmail. com> wrote in message
news:eZ7mmw$bEH A.996@TK2MSFTNG P12.phx.gbl...[color=blue]
> and ....
>
>
> on line 16 which is Intra.Open
> Application("Co nn"),Applicatio n("Usr"),Applic ation("Pwd")
>
> the IE browser gives me error... mentioned in it "providor error" and[/color]
the[color=blue]
> script can't execute
>
> Thx
>
>
> "Curt_C [MVP]" <software_AT_da rkfalz.com> wrote in message
> news:Ow4NVT$bEH A.2660@TK2MSFTN GP12.phx.gbl...[color=green]
> > uh.....ok...... and?
> >
> >
> > --
> > Curt Christianson
> > Owner/Lead Developer, DF-Software
> > Site: http://www.Darkfalz.com
> > Blog: http://blog.Darkfalz.com
> >
> >
> > "Ice Man" <ehc00@hotmail. com> wrote in message
> > news:uEplkQ$bEH A.1048@tk2msftn gp13.phx.gbl...[color=darkred]
> > > Hi Curt
> > >
> > > thanks for ur reply
> > > Here is the code
> > >[/color]
> >[/color]
>
> --------------------------------------------------------------------------[color=green]
> > --
> >[/color]
>
> --------------------------------------------------------------------------[color=green]
> > --[color=darkred]
> > > ----[/color]
> >[/color]
>
> --------------------------------------------------------------------------[color=green]
> > --
> >[/color]
>
> --------------------------------------------------------------------------[color=green]
> > --[color=darkred]
> > > ----
> > > <%@ Language=VBScri pt %>
> > > <%Option explicit%>
> > > <%
> > > Dim Intra
> > > Dim Login, pass
> > > Dim stringSQL, results
> > >
> > > Session("UserLo ggedIn") = FALSE
> > >
> > > Application("Co nn") = "IT_Report"
> > > Application("Us r") = ""
> > > Application("Pw d") = ""
> > >
> > >
> > > Set Intra = Server.CreateOb ject("ADODB.Con nection")
> > > Intra.Open Application("Co nn"),Applicatio n("Usr"),Applic ation("Pwd")
> > > .
> > > .
> > > .[/color]
> >[/color]
>
> --------------------------------------------------------------------------[color=green]
> > --
> >[/color]
>
> --------------------------------------------------------------------------[color=green]
> > --[color=darkred]
> > > ----[/color]
> >[/color]
>
> --------------------------------------------------------------------------[color=green]
> > --
> >[/color]
>
> --------------------------------------------------------------------------[color=green]
> > --[color=darkred]
> > > ----
> > > "Curt_C [MVP]" <software_AT_da rkfalz.com> wrote in message
> > > news:O65339%23b EHA.3988@tk2msf tngp13.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" <ehc00@hotmail. com> wrote in message
> > > > news:OpbGPk9bEH A.3804@TK2MSFTN GP10.phx.gbl...
> > > > > Hi all
> > > > >
> > > > > I created a DSN called IT_REPORT which points to an access[/color][/color][/color]
database[color=blue][color=green][color=darkred]
> > > > > then I tried using asp code to open connection to it but the[/color][/color][/color]
server[color=blue][color=green]
> > gave[color=darkred]
> > > > 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
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >[/color]
> >
> >[/color]
>
>[/color]

[Jeff Dillon]

Re: IT_REPORT

Then use ITREPORT? Sounds like it doesn't like the underscore...pe rhaps
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" <ehc00@hotmail. com> wrote in message
news:OpbGPk9bEH A.3804@TK2MSFTN GP10.phx.gbl...[color=blue]
> 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[/color]
me[color=blue]
> 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
>
>[/color]

[Ice Man]

Re: IT_REPORT

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" <jeff@removeeme rgencyreporting .com> wrote in message
news:eZ3fqqBcEH A.3580@TK2MSFTN GP11.phx.gbl...[color=blue]
> Then use ITREPORT? Sounds like it doesn't like the underscore...pe rhaps
> it's not a valid character in the version of data access that you're[/color]
using.[color=blue]
>
> 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" <ehc00@hotmail. com> wrote in message
> news:OpbGPk9bEH A.3804@TK2MSFTN GP10.phx.gbl...[color=green]
> > 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[/color]
> me[color=green]
> > 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
> >
> >[/color]
>
>[/color]