| Subject | Re: [IBO] Access violation at TIBOQuery.IB_Connection |
|---|---|
| Author | Helen Borrie |
| Post date | 2009-05-05T22:11:17Z |
At 04:05 AM 6/05/2009, you wrote:
Database (e.g. IBODatabase1)
1. Clear out the DatabaseName property
2. Fill in the correct values for Server, Path and Protocol.
-- If the server is using DHCP, or if you are using cp_NetBEUI then do not use an IP address for the Server property.
-- Use of a database alias in the Path property is strongly recommended.
3. Open the Params and clear out anything there.
4. Check that the DatabaseName property is now showing the correct value.
5. Look at all the connection properties in case you have non-default values for connection parameters that are no longer permitted for non-SYSDBA users.
6. Test the connection. Once it is working, then move to the problem query.
Query
1. Clear out the DatabaseName property
2. Drop down the IB_Connection list and select your connection object, e.g. IBODatabase1 if that is the name. When you move focus out of that property, IBO should write a new value into DatabaseName. *Do not edit it*.
3. Drop down the IB_Transaction list and select <default>
Tip: D5 (as I recall) stores the DFM as binary. If you right-click on the GUI of the unit file, you can check on "Text DFM" or something similar, to change it to storing as text. Then you will be able to open the DFM using "View as text". This is sometimes useful for finding inconsistencies in your settings.
4. Test the connection
The other check you should do is to ensure that your application is loading the correct client library. It is conceivable that it is loading gds32.dll from IB 5 which came with Delphi 5. You need it to load fbclient.dll that came with Fb 2.1.2. And of course you must have the correct MSVC8 runtime libraries in the path at both server and client.
hth
Helen
>Hi members,Establish the stability of your settings of your database and query components:
>Well i m facing a weird problem, i m having an application in which i m facing Access violation at a particular query compnent at the connection property, TIBOQuery.IB_Connection, i m not able to figure out for wat reason it is coming.
>The error comes in a very unusual manner, if i restart my application it works fine, i m using IBObjects v 4.8.6 and firebird version 2.1.2
>with Delphi 5.0
Database (e.g. IBODatabase1)
1. Clear out the DatabaseName property
2. Fill in the correct values for Server, Path and Protocol.
-- If the server is using DHCP, or if you are using cp_NetBEUI then do not use an IP address for the Server property.
-- Use of a database alias in the Path property is strongly recommended.
3. Open the Params and clear out anything there.
4. Check that the DatabaseName property is now showing the correct value.
5. Look at all the connection properties in case you have non-default values for connection parameters that are no longer permitted for non-SYSDBA users.
6. Test the connection. Once it is working, then move to the problem query.
Query
1. Clear out the DatabaseName property
2. Drop down the IB_Connection list and select your connection object, e.g. IBODatabase1 if that is the name. When you move focus out of that property, IBO should write a new value into DatabaseName. *Do not edit it*.
3. Drop down the IB_Transaction list and select <default>
Tip: D5 (as I recall) stores the DFM as binary. If you right-click on the GUI of the unit file, you can check on "Text DFM" or something similar, to change it to storing as text. Then you will be able to open the DFM using "View as text". This is sometimes useful for finding inconsistencies in your settings.
4. Test the connection
The other check you should do is to ensure that your application is loading the correct client library. It is conceivable that it is loading gds32.dll from IB 5 which came with Delphi 5. You need it to load fbclient.dll that came with Fb 2.1.2. And of course you must have the correct MSVC8 runtime libraries in the path at both server and client.
hth
Helen