MySQL
Creation of table and privileges
- Create a new table like this:
#
# Table structure for table roboter
#
CREATE TABLE `roboter` (
`id` int(10) unsigned NOT NULL auto_increment,
`cdnr` int(10) unsigned default NULL,
`cdname` text,
`cdbeschreibung` text,
`cdprivat` tinyint(3) unsigned default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
- Create a username for localhost: robby
- Create a new password for it: robby
- Set the privileges to table: roboter
MyODBC/Connector
Install MyODBC. You find the link in necessity section.
Allow in firewall that MyODBC can connect to MySQL.
ASPI Driver:
Probably you already have installed the ASPI driver, if not please install it. You find the link in necessity section.
Binary speed optimized:
You have to allow (local) changer5004x to listen to port: 1881 and to allow to send SQL commands through port 3306.
 |
Download speed optimized |
Binary size optimized:
You have to allow (local) changer5004x to listen to port: 1881 and to allow to send SQL commands through port 3306.
|
Download size optimized |
Source:
Sourcecode was written in Microsoft MFC Visual C++ 6.0 . You can open it with the projectfile (.dsw). In resouce.h you will find the entrys: DB_BENUTZERNAME and DB_PASSWORT there you can change the login details.
|
Download source |