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" <ehc00@hotmail.com> wrote in message
news:eZ7mmw$bEHA.996@TK2MSFTNGP12.phx.gbl...[color=blue]
> 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[/color]
the[color=blue]
> script can't execute
>
> Thx
>
>
> "Curt_C [MVP]" <software_AT_darkfalz.com> wrote in message
> news:Ow4NVT$bEHA.2660@TK2MSFTNGP12.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$bEHA.1048@tk2msftngp13.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=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")
> > > .
> > > .
> > > .[/color]
> >[/color]
>
> --------------------------------------------------------------------------[color=green]
> > --
> >[/color]
>
> --------------------------------------------------------------------------[color=green]
> > --[color=darkred]
> > > ----[/color]
> >[/color]
>
> --------------------------------------------------------------------------[color=green]
> > --
> >[/color]
>
> --------------------------------------------------------------------------[color=green]
> > --[color=darkred]
> > > ----
> > > "Curt_C [MVP]" <software_AT_darkfalz.com> wrote in message
> > > news:O65339%23bEHA.3988@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" <ehc00@hotmail.com> wrote in message
> > > > news:OpbGPk9bEHA.3804@TK2MSFTNGP10.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]
IT_REPORT 
