Steve Erbach
erbachs at gmail.com
Tue Mar 28 19:53:36 CST 2006
Marty, I went through my copy of "ASP in a Nutshell and added another 20 or so objects to your list, like CDONTS.xxx and ADODB.Record. All 9 of the ADODB objects are installed except Field and Property. I have now experimented with the debugging code for VBScript I found somewhere (4 Guys from Rolla?) and have listed all the Connection Object Properties Collection data-provider-specific properties. There are 93 properties and they contain things like: DBMS Name: Microsoft SQL Server DBMS Version: 08.00.2039 OLE DB Version: 02.70 Provider Version: 08.10.9042 And now! The Recordset opens and contains data and it displays on the page! Take THAT Earthlink!!! Hey, Marty, thanks a lot! Steve Erbach Scientific Marketing Neenah, WI http://TheTownCrank.blogspot.com On 3/28/06, MartyConnelly <martyconnelly at shaw.ca> wrote: > Need to see your connection code to SQL, it could be your ADO call isn't > "Server.CreateObject" > Guy is talking a bit odd, you can connect to a remote SQL Server via ADO > and ASP > I have done it via a WAP server to an ASP site to a Remote SQL server > each on a different continent > He is probably confusing not having a SQL Server access on site. If he > supports Access > he has to use ADODB. > > here is some sample ASP code to check what server objects are available > on the ISP site > Note ADODB.Connection and Recordset available. > > Working at http://www5.brinkster.com/mconnelly/TestSiteObjects/testobj.asp > > <% @ Language="VBScript" %> > <% Option Explicit %> > <% > ' Modified from a version on http://www.alphasierrapapa.com > ' there are a number of objects that come with IIS4 MSXML etc. > ' these are put in the array that's declared below > Dim theInstalledObjects(18)