> The pages work right now using the SET CON =
> Server.CreateObject("ADODB.Connection")
> CON.Open "profilegroup"
If this works with Chilisoft, then they've ported ADO. Personally, it
would be a neat idea if the DBD::ADO maintainer would implement passing
the connection created from Server.CreateObject ... to use as Database
Connection. Without this feature, you'll need to open a new connection
to the database each time a page is served.
As for MySQL, is there an OLEDB driver yet? If not, ADO will use the
ODBC driver. I've done a little work with Perlscript on IIS ASP,
works well.
Thomas
On Fri, Jun 01, 2001 at 12:06:56AM -0700, Kokarski, Anton wrote:
>
> interesting question. you have your api to connect from asp to database
> while dbi is perl module. Bottom line is ADODB.Connection is for ASP and
> DBI is for perl. 2 different languages 2 different libraries. Actually to be
> more politically correct ASP can be VB or JS, but that's whole another
> issue...
>
> There are few modules that allow you do server pages scripting with perl. If
> you want to use perl to write server pages than you need to look at some of
> the Apache modules, cannot recall the exact name.
>
> -----Original Message-----
> From: Glenn Emery [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, May 31, 2001 6:57 PM
> To: [EMAIL PROTECTED]
> Subject: DBI with Chilisoft ASP
>
>
> Hi All,
>
> Please excuse the ignorance...................
>
> Very new to this and have gotten an Access Database ported over to MySQL now
> I am hitting the ASP pages and am wondering if it is possible (and more
> efficient) to use DBI within active server pages?
>
> The pages work right now using the SET CON =
> Server.CreateObject("ADODB.Connection")
> CON.Open "profilegroup"
>
> I am using Chilisoft ASP 3.6 Apache 1.3.19 and MySQL 3.23.36 and would like
> to use the most efficient means possible.
--
Thomas A. Lowery
See DBI/FAQ http://tlowery.hypermart.net
_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
