DSN-less MySQL Connection to FP

[NearlyNormal]

Locally from my PC I can connect to our MySQL database on our hosted site. I use a System DSN connection from within FP.

Then I published a test ASP page and since the hosting service (Linux/Apache/FrontPage Extensions)doesn't support System DSN connections on the host, I got a DSN-less connection script from them that I dropped into my ASP page. When I brought up the page there was a "Database connection "Students" undefined." error. "Students" is the System DSN connection name.

I tried to delete references to "Students" within FP but that didn't work, usually yielding "Database connection "" undefined". Finally I tried to redefine "Students" by changing it's entries in GLOBAL.ASA to reflect the DSN-less connection. Still the error -- "Database connection "Students" undefined."

I'm about ready to give up and get a Windows 2000 hosting service and convert the database to Access.

Desperate desperado needs help.

 

[Noconi]

I dont' work with MySQL really at all, so - hoping that this shot in the dark might be of some use to you...
Have you tried defining your connection via the TOOLS > WEB SETTINGS > Database tab? Then recalculate your hyperlinks.

In fact - I would suggest that you first recalculate the hyperlinks since it seems that FP is retaining old connection info in your web - pulling up your system DSN "Students"

Moving to a Windows host though, isn't a bad idea Sorry I couldn't be more helpful on this issue though. I prefer, personally, to figure out that problem and then choose to move to a new host or not.

Tiffany

Microsoft MVP - FrontPage

http://www.at-frontpage.com

http://www.anyfrontpage.com

http://www.frontpage-webtemplates.com