CREATE DATABAS fails

Hi,

To create a database we use SQL script

    aSql := 'CREATE DATABASE 'E:\DvpData\NewBase.IB' USER 'SYSDBA' PASSWORD 
'masterkey' PAGE_SIZE = 8192 WITH ADMIN OPTION';

that we pass to the routine

    procedure CreateDatabaseIB (const aSql : string);
    var status: array[0..19] of longint;
        db, tran: plongint;
        rslt: longint;
    begin
        db := nil;
        tran := nil;
        rslt := isc_dsql_execute_immediate (@status, db, tran, 0, 
PChar(aSql), 3, nil);
        if rslt <> 0 then
          isc_detach_database (@status, db);
    end;

It works fine within our D5 project using IB2009 Server.
But, for the same project migrated to Delphi XE8, it fails with

    InterBase SQL code = -904, Unsuccessful execution caused by an 
unavailable resource.
    InterBase error 335544324 : invalid database handle (no active 
connection)

both for IB2009 Server and IB XE7 Developer.

Any hint will be very appreciated.
Kind regards,
JK
0
Jacek
7/15/2015 3:21:21 PM
embarcadero.interbase.general 923 articles. 0 followers. Follow

0 Replies
633 Views

Similar Articles

[PageSpeed] 2
Get it on Google Play
Get it on Apple App Store

Reply:

Similar Artilces:

CREATE DATABAS fails #2
Hi, To create a database we use SQL script aSql := 'CREATE DATABASE 'E:\DvpData\NewBase.IB' USER 'SYSDBA' PASSWORD 'masterkey' PAGE_SIZE = 8192 WITH ADMIN OPTION'; that we pass to the routine procedure CreateDatabaseIB (const aSql : string); var status: array[0..19] of longint; db, tran: plongint; rslt: longint; begin db := nil; tran := nil; rslt := isc_dsql_execute_immediate (@status, db, tran, 0, PChar(aSql), 3, nil); if rslt <> 0 then isc_detach_database (...

failed to create ike-sa
--____BJKFREPWZKLPZBJKXFKW____ Content-Type: text/plain; charset=windows-1252 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline; modification-date="Wed, 29 Aug 2006 10:05:25 -0400" We had a bm3.8sp4 slave servers certificates expire. We renewed the certs = and most of the connections have come back up. Unfortunately it is still = having issues connecting to some sites. Looking at the ike logs of the = servers it can't connect to I keep seeing this message "failed to create = ike-sa - acl check failed" in reference to the server who...

Restore from Interbase 2009 to Interbase XE fails [Edit]
Hello, I have restored .ib file to Interbase XE from Interbase 2009 .gbk file. Restore was successful but IBConsole does not let me to open it with error message: "Attempt to execute an unprepared dynamic SQL statement" What could cause this? I did not execute any SQL. I just tried to open the database using IBConsole Please help Thanks Edited by: Vladimir Nelenson on Mar 7, 2012 10:25 AM Vladimir Nelenson wrote: > Hello, > I have restored .ib file to Interbase XE from Interbase 2009 .gbk file. > Restore was successful but IBConsole does not let me to open it w...

What generals generally do
Reading a McChrystal thread elsewhere, I came across someone quoting a US general http://en.wikipedia.org/wiki/Smedley_Butler > I spent 33 years and four months in active military service and > during that period I spent most of my time as a high class thug for > Big Business, for Wall Street and the bankers. In short, I was a > racketeer, a gangster for capitalism. I helped make Mexico and > especially Tampico safe for American oil interests in 1914. I helped > make Haiti and Cuba a decent place for the National City Bank boys to > collect revenues in. I ...

Why does this fail to create?
create FUNCTION "DBA"."f_test"( ) RETURNS long varchar AS BEGIN DECLARE @XMLReturn long varchar select xmlelement( name root, xmlelement(name audit_log_header, xmlattributes( 0 as log_id, 'rollback' as file_status, getdate() as created_date))) INTO @XMLReturn RETURN @XMLReturn END SQL Anywhere V9.0.2.3137 Removing the "AS" and adding a few semicolons makes it work: create FUNCTION "DBA"."f_test"( ) RETURNS long varchar BEGIN DECLARE @XMLReturn long varchar; select xmlelement( name ...

tbitmap.create fails "Undeclared Identifier
Never mind this. Windows unit defines tbitmap = tagBITMAP and that's the culprit. Don't see how I missed that when searching the units. Had to move the windows unit from implementation section to first in the Interface unit. That fixed the problem. I searched google but didn't find any reference to this problem so I will post this in case someone else runs into it. using D2007 with all updates. Have used a procedure in many other projects with no errors. However, in this unit I get an error on: function LoadBMPfromRCData(rsName: string): tBitmap; var rc: tResourceS...

'526 partition create failed' on creating a partition
In order to upgrade a server we inserted some new harddisks and added them to the raid configuration. The server sees the disks, and soe does netware (6.0SP5) Unfortunately, that's about all the good thing: I am not able to create a partition on the extended disk system. Whenevr I try to do this using nssmu, I get an error '526, partition create failed' Is this a known problem? I failed to find something in the novell Knowledge base for it. In order to solve it, so far, I did the following: - Updated the SCSI controller driver (pedge3.ham) - updated the BIOS of th...

Interbase General Script examples different speed between Interbase and Firebird
This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. --JivePart=_3b42b.zeB8CwDOH5aMJzMl Content-Type: text/plain; charset="Utf-8" Hello this are the scripts of the captured screens --JivePart=_3b42b.zeB8CwDOH5aMJzMl Content-Type: application/octet-stream; name="Actualizaciones.zip" Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename="Actualizaciones.zip" UEsDBBQAAAAIAKuopDxrVeqcLjIAAFU0AQAVAAAAQWN0dWFsaXphY2lvbjA4NjYuc3Fs7X3bkhs3 kui7Iv...

Create Fails...
Hi, I'm unable to create a database table. While creating an ASA database (in the database painter via ODBC) I'm getting the following message: "Catalog tables could not be created and are not available for use" furthermore, when trying to save a newly created table, this message appears: "The following syntax pattern provided in the C:\PROGRAM FILES\SYBASE\SHARED\POWERBUILDER\pbodb70.ini file is incorrect: ColumnElement" Here are some more details, ODBC Driver: Adaptive Server Anywhere 6.00.03.2747 PowerBuilder: Version 7.0.3 Build 10108 ...

Failed to create IKE-SA. ACL check failed, in a VPN S2S.
Hi, I have exact this Problem http://www.novell.com/support/search.do?cmd=displayKC&docType=kc&externalId=3663945&sliceId=SAL_Public&dialogID=14255544&stateId=0%200%2014257497 Im not able to access iManager on the slave vpn to rename the master server certificate without a tunnel. iManager Login does not work on external site. (Error -626) Anyone a idea how to rename the cert without iManager? Thx Marco Actually, it is not the public segment but the public address for the BM box. I will get a valid test this weekend and let you know how it goes. ...

Creating DNS Resource Record operation fails but still creates resource record in DNS
Whenever I create a DNS resource record through the MPS web interface, I get the following error:Error: Server encountered an internal error. For more information, turn on customErrors in the server's .config file. <response> <errorContext description="Server encountered an internal error. For more information, turn on customErrors in the server's .config file." code="0x80131500" executeSeqNo="33" > <errorSource namespace="DNS Provider" procedure="CreateResourceRecord" /> <errorSource namespace="Windows-based Hosting" procedure="CreateResourceRecord" /></errorConte...

superreview requested: [Bug 268331] WARNING creating file failed in NS_SoftwareUpdateRequestAutoReg : [Attachment 165087] look before trying to create .autoreg
timeless@myrealbox.com (working) <timeless@bemail.org> has asked Daniel Veditz <dveditz@cruzio.com> for superreview: Bug 268331: WARNING creating file failed in NS_SoftwareUpdateRequestAutoReg https://bugzilla.mozilla.org/show_bug.cgi?id=268331 Attachment 165087: look before trying to create .autoreg https://bugzilla.mozilla.org/attachment.cgi?id=165087&action=edit ...

superreview granted: [Bug 268331] WARNING creating file failed in NS_SoftwareUpdateRequestAutoReg : [Attachment 165087] look before trying to create .autoreg
Daniel Veditz <dveditz@cruzio.com> has granted timeless@myrealbox.com (working) <timeless@bemail.org>'s request for superreview: Bug 268331: WARNING creating file failed in NS_SoftwareUpdateRequestAutoReg https://bugzilla.mozilla.org/show_bug.cgi?id=268331 Attachment 165087: look before trying to create .autoreg https://bugzilla.mozilla.org/attachment.cgi?id=165087&action=edit ------- Additional Comments from Daniel Veditz <dveditz@cruzio.com> r=dveditz if you still warn for directories (drop the check and "or directory" from the new NS_WARNING t...

Failed to create EGLContext
Hi everyone, I'm to porting B2G in freescale device. I get only bootanimation in loop. I have maybe problems with hwcomposer, gralloc or something. This is my GDB. >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> __dl__start () at bionic/linker/arch/arm/begin.S:35 35 mov r0, sp (gdb) c Continuing. Loading JavaScript value pretty-printers; see js/src/gdb/README. If they cause trouble, type: disable pretty-printer .* SpiderMonkey 1397154085926 Marionette INFO marionette en...

Web resources about - CREATE DATABAS fails - embarcadero.interbase.general

Second FMPD officer resigns for abusing driver's license databas - NBC-2.com WBBH News for Fort Myers ...
A second Fort Myers Police officer has resigned this week for abusing a law enforcement database called "D.A.V.I.D."

Cognizant’s slideshows on SlideShare
Read and download presentations about multinational-pricing

Part 2: Detailed analysis - References - Australia's Future Tax System: Final Report Architecture of ...
Abhayaratna, T & Johnson, S 2009, 'Revisiting tax losses', Australian Tax Forum , vol. 24, pp. 59–76. Abhayaratna, J & Lattimore, R 2006, Workforce ...

Get the All-time popular Health & Fitness apps on AppBrain
See the All-time popular Health & Fitness apps on the Android market. Find, install and share the best apps and games for your phone. Calorie ...

BlinkList.com - Discover, Blink & Share
List of the best sites on the web

Cuba tiene dos nuevas provincias
Cuba anunció este lunes la creación de dos nuevas provincias, Mayabeque y Artemisa, al dividir la de La Habana (campo), con lo que la organización ...

All results for Enterprise Software in Atlanta, GA - 187 items found
Search our extensive database of technologly and IT jobs. Refine your search by skill, company, location and more.

Tha TRiPLE H. DataBASS!
Sorry... Thiz page requirez framez, pleaze update yar browser! However, you can browse the index using the following links...

The Holy Hip Hop DataBASE - The ultimate online Christian Hiphop resource
The Holy Hip Hop DataBASE - The ultimate Christian Hiphop Resource

ID & Specialty Software
Full-service identification and security solutions provider 877-213-8180 What’s This? Home Products ID Products & Systems Capture Plastic Card ...

Resources last updated: 12/16/2015 9:38:37 PM