Perl under MS IIS with access to MySQL



I have been working with MS IIS, ASP, SQL Server, Oracle for several years.
I currently try to migrate that experience to another environment. I am
about to use Perl under MS IIS with access to a MySQL database.

I did some testing. That worked well. However, sometimes a detailed
background-knowledge is missing.

[1] For accessing MySQL I included and used a library with "use MySQL".
Afterwards I found out that there are other components for database access.
Here I can give the keywords DBI/DBD.

- What I have used is a low-level component, correct?

- DBI/DBD can be regarded as above that component, correct?

- Does DBI/DBD use the component that I used?

- Is one of those components better than the other for usage under MS IIS?

[2] If I open a connection under IIS/ASP/SQLServer, later close that
connection, it won't actually be closed. A caching will take place, so that
the next connection/open might get the returned connection. This is very
usefull when working under an internet server.

- Will IIS / Perl / use MySQL offer such a caching?

- Will IIS / Perl / DBI/DBD offer such a caching?

- If no caching takes place, how do you achieve caching?

--
Michael G. Schneider
Movable Type Weblog
http://www.movable-type-weblog.com/


.



Relevant Pages

  • Re: asp.net sql trusted connections between machines
    ... > connect to a remote SQL Server instance w/ Read-Write permissions. ... > connection string in the web.config. ... > Windows Authentication setting for access via IIS doesn't seem pass the ... is this impersonation behavior with IIS and Windows Authentication ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Cannot connect to database
    ... when you use iis, its uses the aspnet account which is local and is probably not set up to access your sqlserver. ... I open Visual Web Developer 2008 express on desktop and Select File>open Website, and browse to a folder on DevBox. ... An error has occurred while establishing a connection to the server. ... When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: IIS and SQL Server Persmission Issue
    ... >> IIS and SQL Server Persmission Issue ... >> connection in Dreamweaver and run the query it works just fine. ... > connecting to the database. ...
    (microsoft.public.sqlserver.programming)
  • Re: IIS and SQL Server Persmission Issue
    ... >> IIS and SQL Server Persmission Issue ... >> connection in Dreamweaver and run the query it works just fine. ... > connecting to the database. ...
    (microsoft.public.sqlserver.setup)
  • Re: IIS and SQL Server Persmission Issue
    ... >> IIS and SQL Server Persmission Issue ... >> connection in Dreamweaver and run the query it works just fine. ... > connecting to the database. ...
    (microsoft.public.sqlserver.server)