oSes := DacSession():GetDefault()

oSes:getConnectionString()

//DBE=ODBCDBE;DRIVER=SQL 
Server;SERVER=ADEKWIN10;UID=sa;PWD=??????????;DATABASE=PAN;WSID=ADEKWIN10

oData := DacSqlStatement(oSes):fromChar("SELECT * FROM Katan (NOLOCK)")


ERROR:Session does not support SQL (DACSQLSTATEMENT)
SQLERROR:RAISE(61) SQLERROR:RAISECLEARTEXT(88) DACSQLSTATEMENT(169) 
TESTDATABASE(1739) (B)RUNTESTY(1072) (B)RUNTESTY(1099) 
XBPPUSHBUTTON:HANDLEEVENT(1556) RUNTESTY(1115) DLL_PROC(323) 
(B)GETTABMENU(0) RUNBLOCKSES(411) THREADRUN:EXECUTE(204)
Nazwa zbioru : (DBFNTX)
Proces/Nazwa operacji : (6) DACSQLSTATEMENT
Specyfikacja : USQL/9999/9999 (DOS:0)
1:Var(U) : NIL,

Dear Adrian!

I have the same problem with MySQL. Could you tell me how did you solve this
problem? I can create a session but when I want to create a SqlStatement
object I get the same runtime error as you did.

Here is my sample code:

cConnStr := "DBE=ODBCDBE;DRIVER={MySQL ODBC 5.3 ANSI
Driver};SERVER=localhost;DB=testDB;UID=user;PWD=passwd;"

oSql := DacSession():New( cConnStr )

IF .NOT. oSql:isConnected()
*  MsgBox( "Error code : " + oSession:getLastError() )
   MsgBox( "Description: " + oSession:getLastMessage() )
ELSE
   MsgBox( "Connection to server established." )
ENDIF

cCmd := "INSERT INTO test_table (Name) VALUES ('Joseph');"

    ... this is where the problem begins ...
oSqlStmt := DacSqlStatement(oSql):fromChar(cCmd)  -

DacSqlStatement(oSql) gives me the above mentioned error message...

Thanks in advance for your help!

Regards,
Akos Deak

Adrian Wykrota wrote in message
news:79eb1401$400c2457$7f3c@news.alaska-software.com...
>oSes := DacSession():GetDefault()
>
>oSes:getConnectionString()
>
>//DBE=ODBCDBE;DRIVER=SQL 
>Server;SERVER=ADEKWIN10;UID=sa;PWD=??????????;DATABASE=PAN;WSID=ADEKWIN10
>
>oData := DacSqlStatement(oSes):fromChar("SELECT * FROM Katan (NOLOCK)")
>
>
>ERROR:Session does not support SQL (DACSQLSTATEMENT)
>SQLERROR:RAISE(61) SQLERROR:RAISECLEARTEXT(88) DACSQLSTATEMENT(169) 
>TESTDATABASE(1739) (B)RUNTESTY(1072) (B)RUNTESTY(1099) 
>XBPPUSHBUTTON:HANDLEEVENT(1556) RUNTESTY(1115) DLL_PROC(323) 
>(B)GETTABMENU(0) RUNBLOCKSES(411) THREADRUN:EXECUTE(204)
>Nazwa zbioru : (DBFNTX)
>Proces/Nazwa operacji : (6) DACSQLSTATEMENT
>Specyfikacja : USQL/9999/9999 (DOS:0)
>1:Var(U) : NIL,