Search the Community

This thread splits off from this part of the conversation: I do not think that this related to the actual ADO.UDF, which does connect successfully to the default RDB$DATABASE. Question is on the actual DDL to use to (a) create database and (b) create table. I cannot create database with ADO.UDF, that may require ADOX and is receiving attention. I have tested SQL queries on PostgreSQL and SQLite which worked, but on the Firebird it just does nothing. Permissions perhaps? Although I use the same connection string... ; My AutoIt sConnectionString = DSN=Firebird;DATABASE=C:\AutoIt\ado_db\firebird\showDB_ado.fdb;SERVER=localhost;PORT=3050;UID=sysdba;PWD=masterkey; Local $new_fdb="CREATE TABLE drinks ( ID INTEGER PRIMARY KEY,NAME VARCHAR(100) NOT NULL ) ; " Local $qResult = _ADO_Execute($sConnectionString, $new_fdb) ConsoleWrite("$qResult " & $qResult & " * "& $new_fdb & " * Line: "& @ScriptLineNumber &@CRLF) ;============== ;Scite output $qResult -1 * CREATE TABLE drinks ( ID INTEGER PRIMARY KEY,NAME VARCHAR(100) NOT NULL ) ; * Line: 64 $qResult -1 Line: 76 I have tried "REcreate table..." as some sources indicate that it is the way to go. No success.