A
Hello,
I would like to know if somebody could help me with the problem I have to communicate with a mySQL database.
The ODBC connection is no problem. When I try an SQLExec function the following error occured.
(Descriptor type out of range 307). I looked for the help function and called our distributer for this problem. The couldn't give support because Citect and mySQL is not there thing.
I already read something about it and that Matthew Richardson managed the communication between Citect and mySQL.
I was wondering if somebody could help me?
With best regards,
Alexander van Deurzen
(EXCAMPLE CODE THAT IS USED)
FUNCTION
ListNames()
INT hSQL;
STRING sName;
INT Status;
hSQL = SQLConnect("DSN=ZZL_Standaard;UID=Ditis;PWD=kwasie;SRVR=why");
IF hSQL <> -1 THEN
Status = SQLExec(hSQL, "SELECT * FROM tblloog");
IF Status = 0 THEN
WHILE SQLNext(hSQL) = 0 DO
sName = SQLGetField(hSQL, "Name");
Message("Data", sName , 48);
END
SQLEnd(hSQL);
ELSE
Message("ErrorStatus", SQLErrMsg() + " " + IntToStr(Status) , 48);
END
SQLDisconnect(hSQL);
ELSE
Message("ErrorSQLconnect", SQLErrMsg(), 48);
END
END
I would like to know if somebody could help me with the problem I have to communicate with a mySQL database.
The ODBC connection is no problem. When I try an SQLExec function the following error occured.
(Descriptor type out of range 307). I looked for the help function and called our distributer for this problem. The couldn't give support because Citect and mySQL is not there thing.
I already read something about it and that Matthew Richardson managed the communication between Citect and mySQL.
I was wondering if somebody could help me?
With best regards,
Alexander van Deurzen
(EXCAMPLE CODE THAT IS USED)
FUNCTION
ListNames()
INT hSQL;
STRING sName;
INT Status;
hSQL = SQLConnect("DSN=ZZL_Standaard;UID=Ditis;PWD=kwasie;SRVR=why");
IF hSQL <> -1 THEN
Status = SQLExec(hSQL, "SELECT * FROM tblloog");
IF Status = 0 THEN
WHILE SQLNext(hSQL) = 0 DO
sName = SQLGetField(hSQL, "Name");
Message("Data", sName , 48);
END
SQLEnd(hSQL);
ELSE
Message("ErrorStatus", SQLErrMsg() + " " + IntToStr(Status) , 48);
END
SQLDisconnect(hSQL);
ELSE
Message("ErrorSQLconnect", SQLErrMsg(), 48);
END
END