dbExpress Error: [0x0015]: Connection failed - SQL Server Error: unsupported on-disk structure for file C:\Ontrack\ONTRACKDATAIB.IB; found 12, support 11

[m***@cogeco.ca]

Hello all,

We have a Delphi 7 application that connects to InterBase 7.1 and InterBase
7.5 databases.

However, when I attempt to set the SQLConnection in code to "Open" the
application gives the following errors;

dbExpress Error: []: Connection failed
SQL Server Error: unavailable database


Notes
- I have InterBase 7.1 installed on workstation
- I have InterBase 2007 installed on workstation (Installed as
multi-instance)



I am not sure if the dbExpress components in Delphi 7 Enterprise are not
compatible with InterBase 2007 database or if it is a conflict between
InterBase 7.1 and InterBase 2007.

Any help would be appreciated.
--
Best regards,

Michael Bull
***@hmmm.ca

This message (including any attachments contains confidential information
intended for a specific individual and purpose, and is protected by law, If
you are not the intended recipient, you should delete this message and are
hereby notified that any disclosure, copying, or distribution of this
message, or the taking of any action based on it, is strictly prohibited.

[Bill Todd]

1) Have you downloaded and installed the latest IBX components for D7
from Jeff Overcash's page on CodeCentral?

2) What are the connection settings you are using to connect to the
IB2007 instance and what is the name of the instance?

[Mike Bull]

Hello Bill,


(1) Have not downloaded and installed the IBX components from Jeff Overcash
web site.

Specifics: We are using dbExpress components (i.e. TSQLQuery ) not the
InterBase components (I.e.TIBQuery) for our project(s).


(2)
[2.01] The Connection Settings are as follows:

object dtbsOnTrack: TSQLConnection
ConnectionName = 'IBConnection'
DriverName = 'Interbase'
GetDriverFunc = 'getSQLDriverINTERBASE'
LibraryName = 'dbexpint.dll'
LoginPrompt = False
Params.Strings = (
'DriverName=Interbase'
'Database=C:\Ontrack\IBData\ONTRACKDATAIB.IB'
'RoleName=RoleName'
'User_Name=sysdba'
'Password=masterkey
'ServerCharSet='
'SQLDialect=3'
'ErrorResourceFile='
'LocaleCode=0000'
'BlobSize=-1'
'CommitRetain=False'
'WaitOnLocks=True'
'Interbase TransIsolation=ReadCommited'
'Trim Char=False')
VendorLib = 'gds32.dll'
Left = 40
Top = 32
end


At runtime we are using an ini file to pass the Server, User and Password to
SQLConnection:
SERVER NAME=localhost/3060:C:\Ontrack\IBData\_IB2007\VEW\ONTRACKDATAIB.IB
;SERVER NAME=C:\Ontrack\IBData\_IB2007\VEW\ONTRACKDATAIB.IB // I have also
tried this connection as well
USER NAME=ontrackuser
PASSWORD=xhGtyihytvnm17xilopQs2U5210cvOp0trd345fpooewcfyycvb89


[2.02] The name of the instance= "gds_db"



Notes:
- I have installed the InterBase 2007 Developer Edition to run as
"Multi-Instance" on port 3060 (since IB 7.1 is already running on port 3050)
but when I check the InterBase 2007 Manaager (gds_db) Properties it shows
TCP Port No= 3050.



Best regards,

Mike Bull


This message (including any attachments contains confidential information
intended for a specific individual and purpose, and is protected by law, If
you are not the intended recipient, you should delete this message and are
hereby notified that any disclosure, copying, or distribution of this
message, or the taking of any action based on it, is strictly prohibited.

Post by Bill Todd
1) Have you downloaded and installed the latest IBX components for D7
from Jeff Overcash's page on CodeCentral?
2) What are the connection settings you are using to connect to the
IB2007 instance and what is the name of the instance?
--
Bill Todd (TeamB)

[Bill Todd]

Post by Mike Bull
Specifics: We are using dbExpress components (i.e. TSQLQuery ) not the
InterBase components (I.e.TIBQuery) for our project(s).

Whoops. Sorry about that.

It looks like you are trying to connect to a named instance of IB
using a local connection. To do that you must have the InterBase
environment variable set to the path to the root directory of the IB
instance.

A better solution is to make a remote connection using
localhost/instance_name as the HostName parameter.

[Mike Bull]

Hello Bill,

Thank-you for your help - we will look at using a remote connection.
--
Best regards,

Mike Bull
This message (including any attachments contains confidential information
intended for a specific individual and purpose, and is protected by law, If
you are not the intended recipient, you should delete this message and are
hereby notified that any disclosure, copying, or distribution of this
message, or the taking of any action based on it, is strictly prohibited.

Post by Bill Todd

Post by Mike Bull
Specifics: We are using dbExpress components (i.e. TSQLQuery ) not the
InterBase components (I.e.TIBQuery) for our project(s).

Whoops. Sorry about that.
It looks like you are trying to connect to a named instance of IB
using a local connection. To do that you must have the InterBase
environment variable set to the path to the root directory of the IB
instance.
A better solution is to make a remote connection using
localhost/instance_name as the HostName parameter.
--
Bill Todd (TeamB)