Sorry your browser is not supported!

You are using an outdated browser that does not support modern web technologies, in order to use this site please update to a new browser.

Browsers supported include Chrome, FireFox, Safari, Opera, Internet Explorer 10+ or Microsoft Edge.

DarkBASIC Professional Discussion / mySQL DLL

Author
Message
Chewy
19
Years of Service
User Offline
Joined: 1st Jan 2006
Location:
Posted: 3rd Jan 2006 01:25 Edited at: 3rd Jan 2006 03:20
Link
howdi all.. i downloaded the mySQL.dll and the test code that i found using the search on here etc...

how is it i set it up, ive tried putting the dll in system32 under windows, put it under the DBP directory etc and within the projects directory..

but when i go to run the test code to access my mySQL i get the following error:

'Subscript must be an Integer or DWORD when referencing an array at line 22'



i apologise im a newb still with DBP.. im not sure how i use load dll and call to use the mySQL.dll ?

anyone able to help me out, would be great thanks!

Chewy
Back to top
Profile PM Email
Chewy
19
Years of Service
User Offline
Joined: 1st Jan 2006
Location:
Posted: 3rd Jan 2006 02:45
Link
crap ive just realised ive posted my password etc.. i must be tired lol

could a mod please edit my post cuz some reason its saying there is an unknown system error my end?

Chewy
Back to top
Profile PM Email
Dave J
Retired Moderator
22
Years of Service
User Offline
Joined: 11th Feb 2003
Location: Secret Military Pub, Down Under
Posted: 3rd Jan 2006 03:27
Link
Done.


"Computers are useless, they can only give you answers."
Back to top
Profile PM Email
OSX Using Happy Dude
21
Years of Service
User Offline
Joined: 21st Aug 2003
Location: At home
Posted: 3rd Jan 2006 10:30
Link
I dont support the mySQL plug-in anymore,so the following is just as guess : It sounds like the plug-in isn't in the users plug-in directory and you dont have the main SQL system installed.

Blog:http://spaces.msn.com/members/BouncyBrick/
Web Site:http://www.nicholaskingsley.co.uk
Back to top
Profile PM Email Website
Chewy
19
Years of Service
User Offline
Joined: 1st Jan 2006
Location:
Posted: 3rd Jan 2006 12:56
Link
main sql system? i have an actual webserver set up etc and I can access it externally...

I have your plugin which should be more than enough to work?

am i suppose to have any other files for this to work?

Chewy
Back to top
Profile PM Email
Chewy
19
Years of Service
User Offline
Joined: 1st Jan 2006
Location:
Posted: 3rd Jan 2006 13:07
Link
hmm okay, the blowout function isnt working...

i downloaded libmysql as i found some threads on the forum about it...

I am now presented with the following error:

'command in DLL command-table duplicated (mySQL.dll:mySQL_initialise)'

there about 4 of them ^ in one box... if i click ok it then comes up with another error saying:

'the procedure entry point mysql_get_client_version could not be located in the dynamic link library LIBMYSQL.dll'

any clues?

Chewy
Back to top
Profile PM Email
the_winch
22
Years of Service
User Offline
Joined: 1st Feb 2003
Location: Oxford, UK
Posted: 3rd Jan 2006 18:18
Link
Are you planning on distributing a dbpro game that connects directly to mysql running on a remote webserver?
How do you plan on stopping people connecting with any old mysql client and having fun with the database?

I think this sort of stuff is better handled by a program running on the webserver. This program can communicate with the dbpro game and mysql. The program can also make sure that data coming from the game is sensible and there isn't something funny going on.

By way of demonstration, he emitted a batlike squeak that was indeed bothersome.
Back to top
Profile PM Website
OSX Using Happy Dude
21
Years of Service
User Offline
Joined: 21st Aug 2003
Location: At home
Posted: 3rd Jan 2006 18:37
Link
oh, forgot to mention. It will only work with mySQL 4.1

Quote: "main sql system? i have an actual webserver set up etc and I can access it externally..."

You need it for the libmysql.dll file

Blog:http://spaces.msn.com/members/BouncyBrick/
Web Site:http://www.nicholaskingsley.co.uk
Back to top
Profile PM Email Website
Chewy
19
Years of Service
User Offline
Joined: 1st Jan 2006
Location:
Posted: 3rd Jan 2006 18:50
Link
hmmm...

stinky stoat... how do you actualy go about making your own DLL? and is it possible to make it work for any other database such as BDE Admin?

thanks for help btw... just want to keep learning lol

btw when will my posts actualy not have to be checked by staff because its annoying lol

Chewy
Back to top
Profile PM Email
TheL0grus
19
Years of Service
User Offline
Joined: 21st Apr 2006
Location:
Posted: 21st Apr 2006 21:55
Link
Hello Nicholas,
I know that you don't support this Dll anymore but I need one that will talk to mysql 5.0. I need the stored procs and triggers. I'm not good enough to create one or even to port yours and try to add the new features.
I'm ok with SQL as a language and I'm trying to learn Darkbasic. Can you offer me any advice in this matter?

Thank you for anything you might offer.

TheL0grus
Back to top
Profile PM Email
Back to top

Login to post a reply

Server time is: 2025-06-04 17:59:14
Your offset time is: 2025-06-04 17:59:14