| DataMiner + MySQL [message #40555] |
Thu, 19 August 2004 02:37 |
Philip Kershaw
Messages: 5
Registered: March 2004
|
Junior Member |
|
|
Hi,
Has anyone had any experience using DataMiner with MySQL? I'm on slightly
dodgy ground I realise as officially MySQL is not supported with DataMiner
but I know of it being used successfully used elsewhere.
I've encountered problems adding new records to an existing database. When
adding text fields using the AddRecord or SetField method I get an error.
e.g.
Connection to database is OK:
IDL> oDB = Obj_New("IDLdbDatabase")
IDL> oDB->Connect, DataSource="testDB", User_ID="test", Password="test"
Create record set object and set record in "Reports" table:
IDL> oRecord = Obj_New("IDLdbRecordSet", oDB, Table="Reports")
IDL> Stat = oRecord->MoveCursor(/Last)
IDL> oRecord->SetField, 1, "GST"
The SetField command fails with an ODBC error. It should set the second
field "ReportType" of the last record.
I've had similar problems with the AddRecord method. However, setting
numeric and date type fields works OK but not text fields.
I can list the table from the mysql command line:
mysql> select * from Reports;
+----------+------------+------------+
| ReportID | ReportType | GenTime |
+----------+------------+------------+
| 1 | | 2004-08-18 |
| 2 | | 2004-08-18 |
| 3 | | 2004-08-18 |
I can also insert / change records from the mysql command line so the
problem must be somewhere in the MySQL <-> MyODBC <-> DataMiner interface.
System configuration is as follows:
Platform is Sun Solaris 8
IDL version: 6.0
MySQL: 4.0.20
MyODBC: 3.51
Anyone have any ideas or experience with this kind of thing?
Cheers,
Phil Kershaw
Space Science Dept.
Rutherford Appleton Laboratory
UK
|
|
|
|
comp.lang.idl-pvwave archive
Members
Search
Help
Login
Home
