Db: MySQL
Server: Unix - PHP 4.0.5
UD Server Model PHP
Driver: org.gjt.mm.mysql.Driver


I can't use server behiavior (even the simple connection)
because I have always the same error: can't retrieve tables, verify the
connection. But the connection works perfectly.
I have made a recordset with the sql instructions with the advanced recordset mode and I have made navigation bar with the live tool. It works.

But I am a database newbie and I desire now use all scripts made by UD, but when it needs the tables there is the same problem.

Thanks for any suggestions.

It's quite possible that even though the connection tests successfully that you don't have permission to access the MySQL server from a remote connection.

Check the permissions, or ask your ISP to check them.

Tim Green
Webmaster
www.rawveg.org (Coming Soon)

I think to have all ISP permission. I have created a table on the same db with MsqlFront. I have manually added sql code in a UD page that adds a record in the table and it works.
I don't find the solution <img src=../images/dmxzone/forum/icon_smile_sad.gif border=0 align=middle>

In this case I would say that there has to be a problem with your SQL code.

If you are able to retrieve a simple recordset and make other types of remote connection to your DB, then the only thing left is a problem with the SQL you have written in advanced mode.

Tim Green
Webmaster
www.rawveg.org (Coming Soon)

In the advanced mode I have created the recordset and it works, but it's in the SIMPLE mode that it don't works because it don't retrieve tables.
I know that if I write all the code it works but I am not able to do it, I would be very happy to use PHAkt.
note: it's the same problem (unable to retrieve tables) that I have found with the JSP server model.

Please post the information from your connection. I suspect there might be an error somewhere. (Do not include passwords).

Tim Green
Webmaster
www.rawveg.org (Coming Soon)

configuration with php server model by PHAkt

Data Source Name - Advanced
Connection information
Conn. name: name
Ultradev conn
DB type: Mysql
driver ---
Host: sql.domainname.it
URL: jdbc:mysql://sql.domainname.it/dbname
user name: user
password ***

PHP conn: Mysql
host: sq.domainname.it
dbname: dbname
user: user
pass: ***

thanks for your help <img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>

The connection information looks OK too. Looking back at the rest of this thread I see that nowhere is it mentioned what Platform you are using UD on.

Are you by any chance using a MAC ?

Tim Green
Webmaster
www.rawveg.org (Coming Soon)

I'm using a PC on Windows 2000 professional. I have a Mac too but without UD.
I can't believe there is't a solution <img src=../images/dmxzone/forum/icon_smile_sad.gif border=0 align=middle>(

Well, I'm trying to work out what has gone wrong. I use a similar setup, and have never had problems like this, even from the early betas of PHAkT.

The difficulty here, is establishing where the problem lies.

As you are using an ODBC compliant Operating System, try to connect using MyODBC. You can download it from www.mysql.com

Follow the tutorial for creating a connection using MyODBC, and see if that works.

The MyODBC Tutorial can be found at :- www.udzone.com/go?1201

The JDBC Connection Tutorial can be found at :-
www.udzone.com/go?1202

Tim Green
Webmaster
www.rawveg.org (Coming Soon)

In the tutorial that you hav indicated me there is a information may be very important:
"Remember that the database name should not contain any punctuation or spaces."

My Sql database name(that I cannot change, it is directly controlled by the ISP) is like this "mickeymouse.1243minny".

I hope with all my herat that it is the problem, if you say me that can be that I contact the ISP tomorrow morning in order to change the name.

Let me now, if you can.

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

<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
mickeymouse.1243minny<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>

That is very probably the problem. The problem with this database name is that it would break any and all SQL syntax.

To the MySQL interpreter this name says :-
" The table called 1243minny on database mickeymouse " which is of course not what you want.

I would definitely speak to your ISP. In the meantime, you can get a free MySQL database at www.freesql.org this will allow you to set up a database for testing purposes, and allow you to create a connection to check everything works (which I am sure it will).

Tim Green
Webmaster
www.rawveg.org (Coming Soon)

<img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>
thanks, my isp has changed the db name and now it works perfectly.

Excellent ! Thanks for letting us all know (I can stop chomping my nails now... lol)

<img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>

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>