[DUG] dbExpress Error

[Paul McKenzie]

That should connect correctly...
What version of IB are you using ?
Do you only have 1 version of GDS32 installed ?
You have installed the interbase Client ?
Have you installed IBConsole - and can you conne4ct with it ?
The IBConsole test is probably the quickest way to confirm/test the connection.

Regards
Paul McKenzie
Wellington
New Zealand


Hayward, Phillip wrote:
> No, not using UNC paths. Have been using the format 
> Server17:H:\data\prod_data\prod_data.gdb
> This seems to be the format that we have been using with other
> applications.
> At least from within the Delphi IDE we can test the connection and it
> Tests OK
> 
> Tried unc address \\Server17\prod_data\prod_data.gdb and can't even get
> the test connection even though the share is valid. 
> 
> Tried modifying an example application I found on the internet over the
> weekend and it is working with the address format
> Server17:H:\data\prod_data\prod_data.gdb and not coming up with the
> "Database Server Error" so I can only guess I have got something wrong
> in the application.
> 
> Phil Hayward
> 
> -----Original Message-----
> From: delphi-bounces at ns3.123.co.nz [mailto:delphi-bounces at ns3.123.co.nz]
> On Behalf Of Paul McKenzie
> Sent: Monday, 25 September 2006 8:39 a.m.
> To: NZ Borland Developers Group - Delphi List
> Subject: Re: [DUG] dbExpress Error
> 
> Are you using UNC paths ?
> 
> Regards
> Paul McKenzie
> Wellington
> New Zealand
> 
> 
> Hayward, Phillip wrote:
> 
>>As I thought. The only other time I have come across this is with
>>IBManager which actually wants you to point it to Admin.ib.
>>The issue I am having here is some parameter that Delphi is picking up
>>is directing it to look for a local copy on C:\Program
>>Files\Borland\Interbase
>>It is this parameter that I need to change to point it to the server.
> 
> I
> 
>>am just not sure where to find the parameter.
>>
>>Regards 
>>Phil Hayward
>>
>>
>>
>>-----Original Message-----
>>From: delphi-bounces at ns3.123.co.nz
> 
> [mailto:delphi-bounces at ns3.123.co.nz]
> 
>>On Behalf Of Paul McKenzie
>>Sent: Friday, 22 September 2006 4:37 p.m.
>>To: NZ Borland Developers Group - Delphi List
>>Subject: Re: [DUG] dbExpress Error
>>
>>The Admin.ib location (unless connecting directly) is controlled by
> 
> the
> 
>>IB Server itself.
>>
>>Regards
>>Paul McKenzie
>>Wellington
>>New Zealand
>>
>>
>>Hayward, Phillip wrote:
>>
>>
>>>Delphi 2005 Win32 using a TSQLConnection. There is nothing in its
>>>parameters for this setting. I believe it is server security database.
>>>
>>>Regards 
>>>Phil Hayward
>>>
>>>
>>>-----Original Message-----
>>>From: delphi-bounces at ns3.123.co.nz
>>
>>[mailto:delphi-bounces at ns3.123.co.nz]
>>
>>
>>>On Behalf Of Paul McKenzie
>>>Sent: Friday, 22 September 2006 4:18 p.m.
>>>To: NZ Borland Developers Group - Delphi List
>>>Subject: Re: [DUG] dbExpress Error
>>>
>>>Is this Win32 .Net ?
>>>What Deplhi version ?
>>>
>>>We are D7 Win32 and use a TDatabase component which contains the
>>>connection info...
>>>
>>>
>>>Regards
>>>Paul McKenzie
>>>Wellington
>>>New Zealand
>>>
>>>
>>>Hayward, Phillip wrote:
>>>
>>>
>>>
>>>>Making a connection through dbExpress to an Interbase database on the
> 
> 
>>>>network.
>>>>
>>>>I get an error "Database Server Error: no permission for read-write 
>>>>access to database C:\Program Files\Borland\Interbase/admin.ib"
>>>>
>>>>
>>>>
>>>>That's not a problem. We don't keep the admin.ib on the local drive
>>>
>>>but 
>>>
>>>
>>>
>>>>where needed, point to the copy on the database server.
>>>>
>>>>My problem is I don't know where Delphi is picking this parameter up 
>>>
>>>>from so I can't edit it.
>>>
>>>
>>>>Have done a search of all my .ini files on the local hard drive and
>>>
>>>have 
>>>
>>>
>>>
>>>>done a complete search of the registry. Other programs we use like
> 
> SQL
> 
>>>
>>>>Manager keep this string in the registry but I am at a loss as to
>>>
>>>where 
>>>
>>>
>>>
>>>>Delphi stores it.
>>>>
>>>>
>>>>
>>>>Can anyone point me in the right direction?
>>>>
>>>>
>>>>
>>>>Regards
>>>>Phil Hayward
>>>>
>>>>System Analyst
>>>>Pinepanels Rangiora
>>>>ph  (64) 3 313-2764
>>>>fax (64) 3 313-2739
>>>>Ext 38824
>>>>Phillip.Hayward at chh.co.nz <mailto:Phillip.Hayward at chh.co.nz>
>>>>
>>>>
>>>>
>>>>/DISCLAIMER:  This electronic message together with any attachments
> 
> is
> 
>>>
>>>>confidential.  If you are not the intended recipient, do not copy, 
>>>>disclose or use the contents in any way.  Please also advise us by 
>>>>return e-mail that you have received the message and then please 
>>>>destroy.  Carter Holt Harvey is not responsible for any changes made
>>>
>>>to 
>>>
>>>
>>>
>>>>this message and / or any attachments after sending by Carter Holt 
>>>>Harvey.  We use virus scanning software but exclude all liability for
> 
> 
>>>>viruses or anything similar in this email or any attachment./
>>>>
>>>>
>>>>
>>>
>>>
> ------------------------------------------------------------------------
> 
>>>>_______________________________________________
>>>>Delphi mailing list
>>>>Delphi at ns3.123.co.nz
>>>>http://ns3.123.co.nz/mailman/listinfo/delphi
>>>
>>>
>>>_______________________________________________
>>>Delphi mailing list
>>>Delphi at ns3.123.co.nz
>>>http://ns3.123.co.nz/mailman/listinfo/delphi
>>>DISCLAIMER: This electronic message together with any attachments is 
>>>confidential. If you are not the intended recipient, do not copy,
>>
>>disclose or 
>>
>>
>>>use the contents in any way. Please also advise us by return e-mail
>>
>>that you 
>>
>>
>>>have received the message and then please destroy. Carter Holt Harvey
>>
>>is not 
>>
>>
>>>responsible for any changes made to this message and / or any
>>
>>attachments after 
>>
>>
>>>sending by Carter Holt Harvey. We use virus scanning software but
>>
>>exclude all 
>>
>>
>>>liability for viruses or anything similar in this email or any
>>
>>attachment.
>>
>>
>>>_______________________________________________
>>>Delphi mailing list
>>>Delphi at ns3.123.co.nz
>>>http://ns3.123.co.nz/mailman/listinfo/delphi
>>>
>>>
>>
>>
>>_______________________________________________
>>Delphi mailing list
>>Delphi at ns3.123.co.nz
>>http://ns3.123.co.nz/mailman/listinfo/delphi
>>DISCLAIMER: This electronic message together with any attachments is 
>>confidential. If you are not the intended recipient, do not copy,
> 
> disclose or 
> 
>>use the contents in any way. Please also advise us by return e-mail
> 
> that you 
> 
>>have received the message and then please destroy. Carter Holt Harvey
> 
> is not 
> 
>>responsible for any changes made to this message and / or any
> 
> attachments after 
> 
>>sending by Carter Holt Harvey. We use virus scanning software but
> 
> exclude all 
> 
>>liability for viruses or anything similar in this email or any
> 
> attachment.
> 
>>_______________________________________________
>>Delphi mailing list
>>Delphi at ns3.123.co.nz
>>http://ns3.123.co.nz/mailman/listinfo/delphi
>>
>>
> 
> 
> _______________________________________________
> Delphi mailing list
> Delphi at ns3.123.co.nz
> http://ns3.123.co.nz/mailman/listinfo/delphi
> DISCLAIMER: This electronic message together with any attachments is 
> confidential. If you are not the intended recipient, do not copy, disclose or 
> use the contents in any way. Please also advise us by return e-mail that you 
> have received the message and then please destroy. Carter Holt Harvey is not 
> responsible for any changes made to this message and / or any attachments after 
> sending by Carter Holt Harvey. We use virus scanning software but exclude all 
> liability for viruses or anything similar in this email or any attachment.
> 
> _______________________________________________
> Delphi mailing list
> Delphi at ns3.123.co.nz
> http://ns3.123.co.nz/mailman/listinfo/delphi
> 
>