forum.vdsworld.com

Andy_Fletcher · Posted: Thu Nov 20, 2003 2:44 pm Post subject:

No I don't think so.
I just go to a DOS screen, change to the mysql\bin directory and at >
prompt. login using mysql >mysql -127.0.0.1 (for localhost) -u username -pPassword Database name the press enter.
That logs me in and then use SQL query to get data from the data base.

I want to get VDS Script to get the data but thats the problem I'm trying to solve and failing miserably with Crying or Very sad

Should I have some other softerware in place first ?

Regards
Andy Fletcher

nick · Posted: Thu Nov 20, 2003 2:57 pm Post subject:

Hi Andy:
I develope and manage databases for the company I work for and I have found the following MySQL GUI to be the best.

http://www.webyog.com/

It is free for 30 days and then I think it is $40 to register.

MySQL has there own GUI. It is free but not quite as good as the above.
Find info on the free one here:

http://www.mysql.com/products/mysqlcc/index.html

These GUI's allow you to connect to your MySQL server and to view, alter, add and basically manage the server in a Windows friendly environment.

Best Regards,
Nick

Andy_Fletcher · Posted: Thu Nov 20, 2003 3:17 pm Post subject:

Thanks Nick I'll check them out tonight and see how I get on.
I assume your suggesting to use either of these as a way to set the database up properly.

The challenge for me is to build a Management system with VDS and as part of that I have to get it to retrieve, add and update Data. So altimately I really want to get the script to work as it should do.

Still the Windows GUI will be brilliant for getting the initial data in and organised.

Have you managed to use the VDSmysql.dll successfully yet ?
Have a go and see how it performs and then let me know what you were able to acheive. Question

nick · Posted: Thu Nov 20, 2003 3:45 pm Post subject:

Hi Andy:

Andy_Fletcher · Posted: Thu Nov 20, 2003 4:02 pm Post subject:

Great, Thanks Nick. I'll put a few hours in tonight after work. Jsut one other thing. Should I still delete the mysql 4.1.0 and install 3.23.0 instead ?

nick · Posted: Thu Nov 20, 2003 4:18 pm Post subject:

Hi Andy:

Andy_Fletcher · Posted: Thu Nov 20, 2003 6:25 pm Post subject:

Thanks Nick, I'm on it now. Let you know how things go tomorrow.

Also noted you other comment about using GRID elements. Hadn't known about that so was going to get results into a list box element instead.

I take it you would recommend the VDSOBJ.dll then to get results in ?

Andy_Fletcher · Posted: Thu Nov 20, 2003 8:01 pm Post subject:

Whow!!!!

I can't believe it, The GUI you recommended (The Sharewhere on) just helped me do everything so much easier. I would have taken weeks to acheive thisa level of organisation if I had to type out each one in DOS.

Thanks so much for that advise.

Tried the Mysql GUI but is did not work at all, complete rubbish.

Now I am going to try and run my scripts again and see what happens.

Fingers crossed eh! Rolling Eyes

Many thanks Nick.
Andy Fletcher

Andy_Fletcher · Posted: Thu Nov 20, 2003 9:00 pm Post subject:

Well guess what, The Gui worked brilliantly and mysql is all nice and tidy.
But I still get error 27 at the line "dll mysql,query,@dlgtext(equery)"
when I put a simple "SELECT* FROM applics" into the box.

You'll not I'm useing the custom dll rather than the updated VDSmysql.dll cause that just did not work at all.

I'm so annoyed, how come its just this command that won't work. it's like I can put data in, move it about, change it what every. But when I want to read it again Bammmmm Nothing Error 27 Mad

Tommy · Posted: Fri Nov 21, 2003 12:21 pm Post subject:

For managing MySQL databases I would try MySQL-Front which is entirely freeware:
http://www.mysql-front.de/
That's what we use for maintaining the VDSWORLD database.

Unfortunately currently I'm unable to comment on the VDSMYSQL DLL problem as
I'm very busy with work.

Regards,

Tommy

Andy_Fletcher · Posted: Fri Nov 21, 2003 12:34 pm Post subject: re: Mysql GUI

Many Thanks Tommy, appreciate the help and guidance you have already ggiven me and totally appreciate how busy you must be.
When ever you get time please do revisit this topic as I find you input invaluable.

Note:
I did try the freeware mysql gui but it crashes on mysql 4.1.0 alpha running on XP so had to go for the shareware version which I have to say worked brilliantly. No problems at all.

Now I have a nicely set up database in terms of Grant tables etc.

Now all I have to do is get this flaming VDS query command to work on the "Select" statment which is the only part that seems not to work.

Don't work to hard now Tommy
Regards
Andy Fletcher Rolling Eyes