XPost: microsoft.public.sqlserver.programming   
   From: genew@ocis.net   
      
   On Wed, 01 Aug 2012 00:26:43 +0200, Jeroen Mostert   
    wrote:   
      
   >On 2012-08-01 00:02, Gene Wirchenko wrote:   
      
   [snip]   
      
   >>       My understanding is that in order to access the data with the   
   >> browser, I have to create an ADODB.Connection object and an   
   >> ADODB.Recordset object using ActiveXObject() which Firefox (for   
   >> example) does not have.   
   >   
   >Like Bob said, you create these objects on the server side, using   
   >Server.CreateObject(). The browser never sees these objects. In fact, the   
   >browser doesn't know a database is involved at all -- the server is the one   
   >contacting the database and formatting the data as HTML. The communication   
   >between the browser and the site is limited to HTTP.   
      
        I know that I create objects on the server side.  I also have to   
   create objects on the browser side.  At this point in time, I do not   
   have an alternative.  I have been looking for one.   
      
        I need data validation at the browser level.   
      
   >Although it is in fact possible to use these components client-side (in an   
   >IE intranet only), that's like enjoying hot cocoa by snorting it up your   
   >nose: weird, uncomfortable and altogether missing the point. Basically, it's   
   >a terrifically inconvenient way of writing an application you could write   
   >much better using almost any other client-side technology, like .NET.   
   >   
   >There is no browser-independent way of accessing a database from the client   
   >side, unless you consider HTML5's forays in that area (web SQL databases,   
   >since abandoned). Even then it's about local databases, not database servers.   
      
        I do not care so much about browser-independent as much as I   
   would like to be able to use more than just IE.   
      
   Sincerely,   
      
   Gene Wirchenko   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)