views:

37

answers:

0

Hi all,

I have a website built that uses MySql for data management. Everything works great there, however, I am now trying to add our web statistics to it - we have a generic standard that we use. This requires a connection to an MS Access database for login - user name and password, checks acess to that specific site.

The stats work fine on any site that uses MS Access for it data, but I'm having trouble getting the MS Access connection to work with the site that uses MySql.

Here is our basic setup:

folders:
main=site/2009
stats=site/webstats

Main site - MySql - web.config has connection setup for MySql

webstats is setup as a virtual directory in iis under the site and has its own web.config file. The connection here is defined as MS Access, but the default.aspx fails when the user tries to log in (connect to the db and check password)

Does anyone know what I can do to make the system use the connection from the child?

Thank you,

Christy