RE: Frontpage 2002 problem with mysql database connection - Brian E. Conklin - com.mysql.lists.win32

2 messages in com.mysql.lists.win32RE: Frontpage 2002 problem with mysql...

From	Sent On	Attachments
l2...@juno.com	03 Sep 2001 23:09
Brian E. Conklin	04 Sep 2001 06:27

Subject:	RE: Frontpage 2002 problem with mysql database connection
From:	Brian E. Conklin (bcon...@conklincomputing.com)
Date:	09/04/2001 06:27:54 AM
List:	com.mysql.lists.win32

The first thing I would check is the user name & authorization being used to connect to your MySQL DB. You may be able to connect from your machine during development, but your ISP's web server may not.

The only other thing that comes to mind is the fact that if your ISP doesn't support asp or php scripts, it will never work.

I sent this email to mys...@lists.mysql.com & the postmaster said that is not a valid email address. So I am sending this email to win32 instead.

Steps I took to create a database connection (which does not work yet):

I downloaded the driver for mySQL & put it in my system DSN.

Then I went to Frontpage 2002's Tools, Web Settings, Database. I selected 'Network Connection to DB Server'. I selected mySQL driver, input my server ip address & the database name. I clicked Verify & it confirmed the connection was OK. After doing this, Frontpage created a global.asa file which looks like an HTML page but is an ASP page. When I published this file to my web hoster's server, an error message said my web server does not support .ASP files. I said upload anyway & tested my site; my query did not execute. See below *.

Some documentation re: if your server does not support ASP says to go to Tools, Page Options in Frontpage and uncheck ASP support. I don't know if I should do this or not. If Frontpage needs to use this global.asa file for connectivity but my web hoster's server does not support ASP pages, how do I connect????!

BTW, my web hoster supports Frontpage 2000 extensions & I have this enabled on my web site setup. As far as I know, I am not using Frontpage 2002 features at all in my web site.

I have contacted my web hoster & they just give me sites to go to like mysql or php to read documentation, so they are not helping me at all since I've read the relevant documentation & that's how I got this far by myself but now I'm stuck!

* In the script below, the results I get on my site is that I can only see "Here is the current schedule:"; nothing else is on the page! I don't get any errors! I changed the username & password below in order to send this to you.

My .php script which I created a hyperlink to is:

<html> <head> <meta name="GENERATOR" content="Microsoft FrontPage 5.0"> <meta name="ProgId" content="FrontPage.Editor.Document"> <meta http-equiv="Content-Type" content="text/html; charset=windows-1252"> <title>Dave's Schedule</title> </head> <body> <?php // Connect to the database server $dbcnx = @mysql_connect("localhost", "fakename", "99999"); if (!$dbcnx) { echo( "Unable to connect to the " . "database server at this time." ); exit(); } // Select Dave's database if (! @mysql_select_db("dauerbac") ) { echo( "Unable to locate the schedule " . "database at this time." ); exit(); } ?> Here is the current schedule: <BLOCKQUOTE> <?php // Request the students' schedules $result = mysql_query( "SELECT First, Last, Monday, Tuesday, Wednesday, Thursday, Friday, Sunday, Comments FROM dauerbac`.`students` LIMIT 0, 30"); if (!$result) { echo("Error performing query: " . mysql_error() . ""); exit(); } // Display the text of each row in a paragraph while ( $row = mysql_fetch_array($result) ) { echo("" . $row["First, Last, Monday, Tuesday, Wednesday, Thursday, Friday, Sunday, Comments"] . ""); } ?> </BLOCKQUOTE> </body> </html>

To request this thread, e-mail <mysq...@lists.mysql.com> To unsubscribe, e-mail <mysql-unsubscribe-alexey=123b...@lists.mysql.com> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php