Frontpage 2000 & Mysql

[rouse01]

I have loaded Mysql Version 3.23.36 with success on my linux server! At the server console, I followed the docs to setup & populate the Menagerie.Pet table. From a Windows client, I try to use the Database Results Wizard in FPage2000 to connect to the table and get the following:

Server error: Unable to connect to a database from the web server using the connection string 'DRIVER={SQL Server};SERVER=linux;DATABASE=menagerie;UID=me'.

The following error message comes from the database driver software; it may appear in a different language depending on how the driver is configured.
-------------------------------------------------------
[Microsoft][ODBC SQL Server Driver][Named Pipes]Access denied.
Source: Microsoft OLE DB Provider for ODBC Drivers
Number: -2147467259 (0x80004005)

OK, I know I have access to Linux via samba from that client(probably not relevant). I'm trying to create a web page on my windows box that can access a database on the Linux server for the purpose of learning technique.
In Frontpage:
Type of connection - network connection to databse server
Type of database driver: Sql Server (I also have an option to select odbc)
Server Name: linux
Database Name: Menagerie

Can someone get me going on this? - Thanks

 

[aasterud]

Hi,

Have a look at the topic "mySQL and multiple databases". I believe this will probably help you in the right direction.

Harry

 

[aasterud]

Hi,

Have a look at the topic "mySQL and multiple databases". I believe this will probably help you in the right direction.

Harry