First of all I'm a Newbie <img src=../images/dmxzone/forum/icon_smile_shy.gif border=0 align=middle>

I'm using a mac G4 with OS9.1.
With a Unix/ Apache ISP,
with phpMyAdmin 2.2.5
with a MySQL 3.23.32
With DreamWeaver Ultra Dev 4 i'm using
PHAkt 1.2.6 with a JDBC connection.
when i go into Ultra Dev and Set up my Modified Connection - heres my setup.

Connection Name - conndatabase

Ultra Dev Connection
DB type - MySQL and my check works

Host - www.bigcreative.tv

URL-jdbc:mysql://www.bigcreative.tv /bgerman_Users

User Name: bgerman_bgerman

Password - ****** (it's correct)

PHP Connection
DB Type - MySQL

Host - bgerman@localhost

Database name - bgerman_Users

User Name - bgerman_bgerman

Password - ****** (it's correct)

So then when i test the connection i get
Communication Link Failure:java.io.IOExceptions <img src=../images/dmxzone/forum/icon_smile_sad.gif border=0 align=middle>

I've look around this whole site and i haven't got any info that has helped.
i checked the remote access with my ISP,
and asked them if it mySQL was enabled.
They said it was.

In the Talkzone there was a section Posted - 07 Dec 2001 called Communication Link Failure:java.io.IOException
and mrnine said that “I hadn't setup in MySQL with remote access privileges. So my OS9 partition with Ultra Dev couldn't cross that “silicon border” over my OSX partition and talk. As soon as I got that set up, everything worked fine” now i'm not using OSX but i was wondering if there was anything helpful in the statement?

Anyway i hope someone can enlightment
me, and i can solve this frustrating problem i'm encountering. <img src=../images/dmxzone/forum/icon_smile_8ball.gif border=0 align=middle>

thanks, will <img src=../images/dmxzone/forum/icon_smile_big.gif border=0 align=middle>



















<font size=2></font id=size2><font size=1></font id=size1><i></i><i></i> <BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote> <hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>

Hi Will,

I don't know if it will help, but when reading your Ultradev connection string, you have a space between bigcreative.tv and /bgerman_Users

try to remove that space, because you can't have any space there.

What I can say for sure, is that your problem is situated in your UltraDev connection and not the PHP connection.

PHP does not use the JDBC driver, and what you see is a problem that arise within Ultradev

Secondly, your mysql server is up and running. I successfully connecte to your server, and it should be fine, as long as your user/password is correct (Which you say it is)

--- Better to die trying, than never try at all ---

In many cases the java.io.IOException error occurs because the MySQL server isn't setup to allow remote connections.

This error message has been dealt with before, and if memory serves correctly there has even been either an FAQ or Tutorial discussing this issue.

Tim Green

Extension & PHP TalkZone Manager
<font size=1>-------------------------------------------
<i>Please read the Forum FAQ before posting
a question to this TalkZone.</i>
-------------------------------------------
www.UDzone.com : A dynamic Dreamweaver,
Ultradev and Fireworks site for developers
by developers.
-------------------------------------------</font id=size1>