Skysnake

[RESOLVED] Firebird SQL create database ... create table problem

2 posts in this topic

#1 ·  Posted (edited)

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.

Edited by Skysnake

Skysnake

Why is the snake in the sky?

Share this post


Link to post
Share on other sites



 I was under the mistaken impression that the IBProvider was included in the standard Firebird installation.  In addition, Firebird is free, and the standard free installation can create dbs using iSQL, but the IBProvider is not free, but comes with a trial version.

If the choice is to pay for IBProvider to create Firebird db's or create for free manually, I will stick to iSQL.

ttp://www.ibprovider.com/eng/download.html

It appears that ADO itself can not create Firebird databases.


Skysnake

Why is the snake in the sky?

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now