Re: Access query won't work with XP

• Previous message: Bob Barrows: "Re: Clearing a Table (Access MDB file)"
• In reply to: Aaron Bertrand [MVP]: "Re: Access query won't work with XP"
• Messages sorted by: [ date ] [ thread ]

Date: 17 Mar 2004 13:20:43 -0800

Thanks! I created a virtual directory and changed the code to:
**********
Set rs = Server.CreateObject("ADODB.Recordset")
sql = "select * from FloatTable Where ((TagIndex < 9) and (TagIndex <>
1) and (TagIndex <> 4)) And (DateAndTime>#"&StartDate&"#) And
(Minute(DateAndTime)=0) order by DateAndTime, TagIndex asc"

cst = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & _
        Server.MapPath("/Powerhouse/AirFlowODBC.mdb")

rs.Open sql, cst
*********
and it works anonymously. Should I be concerned that Jet and
Replication Objects are being deprecated?
Thanks again for the help.

Ernest

"Aaron Bertrand [MVP]" <aaron@TRASHaspfaq.com> wrote in message news:<#3ni#n2CEHA.3132@TK2MSFTNGP11.phx.gbl>...
> Well, stop using a DSN, for one (see http://www.aspfaq.com/2126). Once you
> get the connection working, I have about a half dozen other constructive
> criticisms of your code...
>
> --
> Aaron Bertrand
> SQL Server MVP
> http://www.aspfaq.com/
>
>
> "Ernest" <ernestcarroll@msn.com> wrote in message
> news:e9a62807.0403160338.6de74159@posting.google.com...
> > I get "The page cannot be displayed" and :
> >
> > Error Type:
> > Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
> > [Microsoft][ODBC Microsoft Access Driver] '(unknown)' is not a valid
> > path. Make sure that the path name is spelled correctly and that you
> > are connected to the server on which the file resides.
> >
> >
> >
> > "Aaron Bertrand [MVP]" <aaron@TRASHaspfaq.com> wrote in message
> news:<OsK2NDrCEHA.3280@TK2MSFTNGP09.phx.gbl>...
> > > *sigh*
> > >
> > > WHAT DOES "DOESN'T WORK" MEAN???
> > >
> > > --
> > > Aaron Bertrand
> > > SQL Server MVP
> > > http://www.aspfaq.com/
> > >
> > >
> > > "Ernest" <ernestcarroll@msn.com> wrote in message
> > > news:e9a62807.0403150910.157d92@posting.google.com...
> > > > I have ASP web pages which were running on the NT IIS and querying
> > > > access databases on 2 different PC's. I had to replace the PC and the
> > > > new PC has windows xp. I have fought for the last week trying every
> > > > combination of settings but cannot get anonymous access to work. The
> > > > query's work fine from the IIS PC if I only select integrated windows
> > > > authentication and am logged in on the IIS PC with the Administrator
> > > > name and password of the database PC. If I select Basic
> > > > authentication and login with IUSR_servername it doesn't work. Yes, I
> > > > have set the IUSR passwords the same on each PC. Thanks for any help.
> > > > I am begining to think XP just may not work with this.
> > > >
> > > >
> > > > Set rs = Server.CreateObject("ADODB.Recordset")
> > > > sql = "select * from FloatTable Where ((TagIndex < 9) and (TagIndex <>
> > > > 1) and (TagIndex <> 4)) And (DateAndTime>#"&StartDate&"#) And
> > > > (Minute(DateAndTime)=0) order by DateAndTime, TagIndex asc"
> > > > rs.Open sql, "DATABASE=AirFlowODBC;UID=;PWD=;DSN=PowerhouseDB"

• Previous message: Bob Barrows: "Re: Clearing a Table (Access MDB file)"
• In reply to: Aaron Bertrand [MVP]: "Re: Access query won't work with XP"
• Messages sorted by: [ date ] [ thread ]