MS Access Databases/CGI

• • Reply

  19 years ago

  by mrjdesign

  Mike J

  London, UK, United Kingdom

  Joined 19 years ago

  In replay to another topic I posted this little resource for reply, however I found this technique so interesting I think it may deserve it's own subject line in here.
  

  
  I am not sure if this applies on all servers but I tested this on MS NT 4 running IIS 4 and on Win2K running IIS 5 and it seemed to work fine in both cases, should the server just allow EXE extensions in the cgi bin.
  

  
  The database I tested this on holds, sorts and searches over 141,000 address listings with detailed categories and so on. and the pure ASP returns search hits in leass than 3 seconds. This does not slow it down one bit.
  

  
  VB CGI!

  
  

  
  If you are intending to place a VB file as an Executable CGI in your cgi bin thats doable.
  

  
  I have seen a program called CGI for VB5 but ... I would seriously recomend another file named CGI4VB
  

  
  This is really great and it has a little perk to it as well if you are building databases and interacting with MS Access.
  

  
  Using MS Access on IIS 4 or 5 will limit the number of SQL Quesries you can pass to the MS Jet DB.
  

  
  This limitation, caused by JET it self, is set to maximum 20 simultaneous connections per server.
  

  
  This means if your site is hosted over a huge server and you have 100 other servers on that machine too you will share connections with the other 99 users.
  

  
  Instead, by using CGI4VB and the VB database connections, you can byppass this entire ordeal and access you db directly without going through the server limitations.
  

  
  Now since CGI4VB uses VB Runtime only, it will work fine on any IIS based server having VB5 Rtimes.
  

  
  Also.. you now have the ability to hold 255 simultaneous connections to your own database independantly of your server settings.
  

  
  Remember though, this CGI will not be a standard Win32 CGI.
  It is dependant on VB Rt and should be placed in cgi-bin.
  

  
  Also your server must support EXE extensions.
  

  
  Some servers and hosts today turn this function off due to security risks.
  

  
  

  
  Here are the files you need for this
  

  
  http://pw2.netcom.com/~obrienk/index.html

  Report abuse