forum.vdsworld.com

Andy_Fletcher · Posted: Tue Nov 04, 2003 5:04 pm Post subject: VDSMysql.dll

I wander whether anyone can help with getting the query results back from Mysql server.
I am okay with SQL language basics, just can;t seem to get anything other than error 27 when using the @dll mysql('whatever') functions for capturing results of a standard query.

VDS Example successfully logs into the server okay and selects the database I want. It's all the clever stuff i can't seem to get to work.

Any help on this would be greatfully appreciated.

PGWARE · **Web Host** Joined: 29 Dec 2001 Posts: 1566

I don't know if Tommy has updated this dll yet, however it did not work with VDS 5. The dll requires an update before it will work with VDS 5.

X-Tools · Posted: Wed Nov 05, 2003 7:02 am Post subject:

Hi,

yes. Tommys dll is updated.
You can find it at http://www.vdsworld.com/vdsdll/vds5/

I am using the mysql dll since some weeks in vds5 without any problems

Andy_Fletcher · Posted: Wed Nov 05, 2003 11:05 am Post subject: Thanks for your replys all

I am useing 4.50 as I had just upgraded about 3 days before version 5 came out. (teach me to keep in touch I suppose).

I assume the dll wil work perfectly fine on this version even though the example script that come with VDS.dll is 3.

Managed to get vdsmysql.dll to successfully process the following SQL statement.

(rems = databasename)

INSERT INTO applics (name) VALUES ('Andrew');

What I can't seem to do is query the database to get the name "Andrew" back in a result.
Can you suggest the lines of code needed. I get error 27 when using the example script.
Many thanks

Tommy · Posted: Wed Nov 05, 2003 12:15 pm Post subject:

Andy,

I would recommend you to contact Commercial Research (support@dialogscript.com), as I think
a free upgrade to VDS version 5 should be applicable to you because you upgraded so near
the release (I think a limit of about 2 months applies here, so the 3 days is well under that).

This means however that the VDS 5 (un)compatibility couldn't be the cause of the
error. Still I would like to recommend you to download and try the latest version available
from http://www.vdsworld.com/vdsdll/vds5/vdsmysql.dll , as besides the compatibility update,
it contains some other changes. Make sure to download the new libmySQL.dll file with
it. Please let me know whether that helps.

Tommy

Andy_Fletcher · Posted: Wed Nov 05, 2003 12:53 pm Post subject: re: Mysql

Thanks Tommy, I'll check out the issue of free upgrade to VDS 5 and also download the new dll's you mention.
I'll try them out tonight and see how I get on. Let you know later this evening.

By the way I'm using XP, is there any know differences or bugs you know of ?

Many thanks again
Andy Fletcher

Andy_Fletcher · Posted: Wed Nov 05, 2003 9:03 pm Post subject:

Hi Tommy, just an after thought.
Where should the Libmysql.dll file be placed ?

Andy_Fletcher

Hi Tommy,
When useing the updated vdsmysql with VDS vs 4.5 last night I could not get it to logon to server.

Go at error number 1 which indicates "An Invalid Dialogscript command".
This happen immediately you hit connect on the logon dialog.

When I switch back to the custom dll I had made incorporating the old vdsmysql.dll (Inamed it VDSmore.dll) it logs in fine.

Do you have an example script where your version works?

I'm wandering whether the commands are slightly different for the new dll.
i.e dll mysql,login.....

Tommy · Posted: Thu Nov 06, 2003 7:40 am Post subject:

Unfortunately, because the new vdsmysql.dll file is not part of an "all-in-one" dll,
you would have to call it using "mysql ..." and "@mysql(...)" rather than "dll mysql,..."
and "@dll(mysql,...)". This should resolve the error 1.

Andy_Fletcher · Posted: Thu Nov 06, 2003 8:02 pm Post subject: reply

Thanks Tommmy I'll give it a go tonight and let you know how I get on.

Andy_Fletcher · Posted: Thu Nov 06, 2003 8:36 pm Post subject: Re: reply

Sorry Tommy but that did not work either same error code 1 I'm afraid.
Here is the line of code it occurs on:
mysql,login,@dlgtext(eHostname),@dlgtext(eUsername),@dlgtext(ePassword),@dlgtext(ePort)

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

Looks like you've got a comma in the wrong place. The line should read as
follows Smile

:

Andy_Fletcher · Posted: Thu Nov 06, 2003 9:40 pm Post subject: Re: reply

Okay I see that Doh for to make the change when I replace the"Dll" statement. But now we get exception error 1401. whats that all about.
Here the whole code I'm running (It's the example script from the VDS3dll.dll)
directory change,@path(%0)
external c:\rems\vdsmysql.dll,
directory change,@path(%0)

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

Hi Andy,

You must have accidentally left in your serial number for vdsmysql.dll,
I removed it. Please remember to take them out before posting. Smile

Vic D'Elfant · Posted: Fri Nov 07, 2003 10:26 am Post subject:

Hi Andy,

I've changed your post so it now uses the [code:1:7ab397856b] BBcode tag Very Happy

. With this tag, VDS Code is much more easy to read then when just pasting it into your post. And you can download the script with a single mouse click.

For more information about the tag, read: http://forum.vdsworld.com/viewtopic.php?t=1986 Razz

Best regards and happy coding Smile

,
Vic