Page 1 of 1
[MySQLDirect . net data provider] can't generate update command
Posted: Wed 27 Dec 2006 10:09
by RideKick
Hello ,
first I've tried to install MySQLDirect .NET but it dosn'et work so i've installed unidirect and it works but I can generate update command and delete command....
I'm using VS 2005 + framework 2 and Mysql 4.1.12
Can somebody help me please ?
thanks
Posted: Wed 27 Dec 2006 10:21
by Alexey
Please describe the problem in detail. What is meant by "MySQLDirect .NET doesn't work"?
Posted: Wed 27 Dec 2006 10:27
by RideKick
Ok ,
I've installed UniDirect .NET version 2.00 for .NET Framework 2.0 on my XP pro + VS 2005
- i've added unidirect elements on toolbox windows
- created new connection on server explorer to my mysql server
- created a dataset with a datatable from my mysql server
- generated SELECT and INSERT command but UPDATE and DELETE can't be created ....
Posted: Wed 27 Dec 2006 11:09
by Alexey
OK, i see. We are investigating this problem.
You will be notified on results as soon as possible.
Posted: Wed 27 Dec 2006 11:10
by RideKick
thanks
Posted: Wed 27 Dec 2006 11:11
by Alexey
To create update commands use our DataSet wizard from the Tools menu.
Posted: Wed 27 Dec 2006 12:14
by RideKick
ok , but i want dataAdapter generated commands which are automatically built by the wizard
Posted: Wed 27 Dec 2006 12:21
by Alexey
You'll get them using our wizard as well.
Posted: Wed 27 Dec 2006 12:26
by RideKick
It doesn't work , I have to complete Update query manually , only SELECT and INSERT are automatically completed
Posted: Wed 27 Dec 2006 12:32
by Alexey
What is the full version of UniDirect .NET you use? Professional or Standard edition?
Please provide your table definition.
Posted: Wed 27 Dec 2006 12:46
by RideKick
UniDirect .NET version 2.00 for .NET Framework 2.0 (Trial Version for the moment)
CREATE TABLE `ClientsContacts` (
`indice` int(10) NOT NULL auto_increment,
`societeContact` varchar(250) default NULL,
`civiliteContact` varchar(250) default NULL,
`nomContact` varchar(250) default NULL,
`prenomContact` varchar(250) default NULL,
`fonctionContact` varchar(250) default NULL,
`adresseContact` varchar(250) default NULL,
`adresse2Contact` varchar(250) default NULL,
`cpContact` varchar(20) default NULL,
`villeContact` varchar(250) default NULL,
`Pays` varchar(50) default 'France',
`telContact` varchar(250) default NULL,
`telMobile` varchar(20) default NULL,
`faxContact` varchar(20) default NULL,
`mailContact` varchar(250) default NULL,
`provenance` varchar(250) default NULL,
`Commentaire` text,
`ctrEmailing` tinyint(1) unsigned default '0',
`ctrHebergement` tinyint(1) unsigned default '0',
`ctrInternet` tinyint(1) unsigned default '0',
`ctrSecurite` tinyint(1) unsigned default '0',
`ctrDevSoft` tinyint(1) unsigned default '0',
`ctrTeleMF` tinyint(1) unsigned default '0',
`ctrRoutage` tinyint(1) unsigned default '0',
`ctrBackup` tinyint(1) unsigned default '0',
`ctrCVL` tinyint(1) unsigned default '0',
`dateCreation` date default NULL,
PRIMARY KEY (`indice`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
Posted: Wed 27 Dec 2006 13:00
by Alexey
I've just checked this. All the commands are generated with default options of Dataset wizard. Please describe the steps you perform to create your dataset.
Posted: Wed 27 Dec 2006 15:15
by RideKick
in solution's explorer window
- RightClic on projet -> add new element
- Dataset
to add datatable :
In server explorer window
- drag/drop datatble from mysql connexion
Posted: Wed 27 Dec 2006 15:50
by RideKick
Ok , I've found the solution with the unidirect dataset wizard....thanks for your help !
Posted: Thu 28 Dec 2006 07:18
by Alexey
Right. From the Tools menu as I mentioned before.