When I create a new recordset, I pick the database and table and everything and when I do in the box below nothing shows up, I can still hit OK. and then all the columns show up. But when I try to hit something like log in user it gives me an error saying that their are no columns or something. Does anyone know what might be causing this??

Keith Slater

<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
But when I try to hit something like log in user it gives me an error saying that their are no columns or something.
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>

What is the precise error message showing at this point ?

I've noticed that in previous posts you've mentioned that you use a couple of different DBMS's. Which DB are you using when you get this error ? And how are you connecting to that DB (ie ODBC, JDBC) ?

Is this a remote DB ?

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>

sorry, its a MySQL database, on my local machine and Im connecting with JDBC. The other thing is I can hit test and see the info so I dont know whats going on

Keith Slater

That's a strange problem. Never heard of it before.

Try deleting all of your current connections, and delete the adodb directory, and recreate the connection.

I can't offhand think of any reason why this should be happening.

If this problem persists, please let me know, and also give me the exact steps you have taken to get this problem and I will attempt to reproduce it.

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>

OK, I deleted the ADODB and the connection forlder and it recreaterd it and I'm still having the same problem. So I took some screen shots of the steps I took:

<img src="www.chuckconners.com/error/1.jpg" border=0>
The connection was made successful


<img src="www.chuckconners.com/error/2.jpg" border=0>
The recordset has no columns....


<img src="www.chuckconners.com/error/3.jpg" border=0>
but the database does


<img src="www.chuckconners.com/error/4.jpg" border=0>
After I hit OK the columns show up on Data Bindings anyway


<img src="www.chuckconners.com/error/5.jpg" border=0>
But I can't log in a user

Keith Slater


Edited by - keithslater on 09/08/2001 17:16:04

Thanks for the screenshots Keith, they make life a little easier.

Oooops I found an error in the JDBC tutorial !

Your connection string reads :-

jdbc: mysql://localhost/vermund

In the tutorial it should read :-

jdbc: odbc://localhost/vermund

mysql: is not a protocol, and I'm 99% sure this is where your problem lies.

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>

Edited by - rawveg on 09/09/2001 02:58:55

Edited by - rawveg on 09/09/2001 03:02:06

Edited by - rawveg on 09/09/2001 03:03:45

Im not making an odbc connection though..

Keith Slater

Ooops.... I'm going mad..

The tutorial isn't wrong at all. I must have been working too hard, so ignore my last post ! Sorry..

Looking a little deeper into this, are your password fields blank solely for the purpose of the screenshots, or are they indeed blank ?

The reason I ask is that MySQL for many of its operations requires some form of authentication. If you haven't assigned a password to your root user (which by the way is a major major mistake, as the root user has full admin rights), then you need to assign a password there.

If this is not the case, then you may well be looking at an uninstall/reinstall of UD....

Edited by - rawveg on 09/10/2001 01:47:42

Edited by - rawveg on 09/10/2001 01:49:14

ok.. I'll re-install UD, I think theirs something wrong with it anyway when I try to add extensions it gives me an error. I'll reinstall and tell you if it works,

thanks

Keith Slater

Hey tim I re-installed and I get the same results...
I dont know what the next step would be. I got it working perfectly at work but at home theirs somethign wrong...

Keith Slater

Other than making sure that you are using a password in your connection and that a password is assigned to the root user, the only thing I can suggest now is that you report the bug to www.interakt.ro/phakt/bt

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>