forum.vdsworld.com

Andy_Fletcher · Posted: Mon Nov 17, 2003 7:03 pm Post subject:

Many thanks for that Vic.
Did you see any errors there which would stop the VDSmysql.dll from working ?

Vic D'Elfant · Posted: Tue Nov 18, 2003 10:12 am Post subject:

Vic D'Elfant · Posted: Tue Nov 18, 2003 10:26 am Post subject:

FreezingFire · **Admin Team** Joined: 23 Jun 2002 Posts: 3508

Andy_Fletcher · Posted: Tue Nov 18, 2003 9:10 pm Post subject:

Hi Vic, So you are saying that I should only have VDSMysql.dll or the custom dll & Libmysql.dll in the c:\windows\system directory ?

I think I'm running Libmysql in c:\mysql\bin and also in the VDS root directory also

and vdsmysql.dll is in a custom dll that I stored in the directory I created for the application I'm trying to write.

Vic D'Elfant · Posted: Wed Nov 19, 2003 9:12 am Post subject:

Yeah, just put the vdsmysql.dll and libmysql.dll in C:\windows\system (NT system: C:\windows\system32) and try again...
Leave libmysql.dll in c:\mysql\bin, otherwise your mysql server won't work anymore Wink

Best regards Smile

Vic

Andy_Fletcher · Posted: Wed Nov 19, 2003 2:01 pm Post subject:

Okay I'll do that and fingure crossed that will work, Smile

I'll let you know later how I get on. If I'm using Windows XP should I then place in Windows\System32 ?

By the way, It does seem strange that I seem to be able to use the example script to add rows or update rows to a database table
but then cannot get any information back using the query box.
Could this be that I only have 1 row (i.e a record of a person) in the table ?
I used the db dll for accessing MS Access databases a while ago before trying SQL and had no problems at all Confused

Many thanks Vic

Andy_Fletcher · Posted: Wed Nov 19, 2003 7:51 pm Post subject:

Just another thought Vic, What version Mysql Server are you using ?
This might be the problem ?
I'm using 4.1.0-alpha....

Regards

Vic D'Elfant · Posted: Thu Nov 20, 2003 8:18 am Post subject:

I'm at school right now, but I thought it was 3.23 Confused

Best regards Smile

Vic

arcray · Posted: Thu Nov 20, 2003 8:57 am Post subject:

I think the latest versions of mysql.dll and vdsdb.dll both have problems retrieving numerical data that were introduced in the VDS5 compatible versions...

I have emailed Tommy to request he looks into it, but in the meantime I cannot convert my progs to VDS5 until it is resolved...

Andy_Fletcher · Posted: Thu Nov 20, 2003 9:57 am Post subject:

Hi Andy,
Are you saying don't bother with version 5 at the moment if I want to use vdsmysql ?

Have you used this successfully with version 4.50 ?

If so what version of Mysql server did you use. ?

Regards
Andy Fletcher

Andy_Fletcher · Posted: Thu Nov 20, 2003 10:32 am Post subject:

Thanks Vic, Thought that might be the case. Looks like I'll have to role back to 3.23. Can you double check for me later.

Do you have an example of script that you know works on yours, that I can test on my 4.1.0 - alpha ?

Also can you confirm the Properties of your Libmysql.dll and VDSmysql so I can check that I'm using the rite one. File size and created dates should be enough.

Many many thanks Vic

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

Hi:
I was reading the last few posts in this thread and I hope this was not addressed earlier and if it was I'm sorry.

I was wondering if the problems you are encountering is due to the fact that the grant tables were changed in MySQL version 4.x and above.

I only run the MySQL 3.23.58 on all of my servers, but I did do some testing a while ago on a 4.x version and I think I did run into some privleges problems. I was to busy to investigate the real reason so I'm not sure of the real cause of the problems I had.

Nick

Andy_Fletcher · Posted: Thu Nov 20, 2003 1:41 pm Post subject:

Hi Nick, Thanks for getting in touch, your input is always welcome.

I think you may be onto something there as GRANT tables seem to be a specialist area when setting up Mysql servers.
As I'm a novice programmer in the first place I have probably bitten off more than I can chew. Crying or Very sad

I have set up the server as you no with 4.1.0-alpha and I think for now I have applied "GRANT ALL" rights to the "use". However I can't seem to varify this as I seem to have problems reading anything from the mysl database.
That said the VDSmysql.dll seems to communicate okay with a simple SQL query like: INSERT INTO applics (Name,lname,refid) VALUES ('Andrew','Fletcher',01);
So if I can add to a record I must be able to view it yes ?

Regards
Andy

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

Hi Andy:
Are you using any MySQL frontend program to actually view the databases on you MySQL server.

Nick