Strange error

Started by stanl, June 07, 2015, 11:33:24 AM

Previous topic - Next topic

stanl

Just refreshing using ISAM drivers with either the Jet or ACE Providers, in the snippet below, the URL is valid and the ISAM is installed, but the error is Internet Login Failure, which doesn't make a lot of sense:
Code (Winbatch) Select

cConn='Provider=Microsoft.ACE.OLEDB.12.0;Data Source=http://www.bennetyee.org/ucsd-pages/area.html;Extended Properties="HTML Import;HDR=YES;IMEX=1";'
;cConn='Provider=Microsoft.Jet.OLEDB.4.0;Data Source=http://www.bennetyee.org/ucsd-pages/area.html;Extended Properties="HTML Import;HDR=YES;IMEX=1";'
oConn=CreateObject("ADODB.Connection")
oConn.ConnectionTimeOut=0
oConn.CommandTimeOut=0
oConn.CursorLocation=3
oConn.Open(cConn)

oRS=CreateObject("ADODB.Recordset")
oRS.Open("select count(*) from [Area Code Listing, by Number]", oConn, 2,1,1)
oRS.Save(dirscript():"htmltest.xml",1)
oRS.Close()
oRS=0
oConn.Close()
oConn=0

Exit


JTaylor

Not that it helps but I see the same behavior.  I tried several different things but with no luck.  All I can find on the web is references to using this approach for HTML data created from an Excel or Access file.

Jim

stanl

You see, I commented out the Jet 4.0 connection, but I remember it working with Jet. Probably been deprecated like SOAP was by Microsoft.