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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > 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: [EMAIL PROTECTED] > > [mailto:[EMAIL PROTECTED] > >>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 >>>[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> >>> >>> >>> >>>/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 >>>[email protected] >>>http://ns3.123.co.nz/mailman/listinfo/delphi >> >> >>_______________________________________________ >>Delphi mailing list >>[email protected] >>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 >>[email protected] >>http://ns3.123.co.nz/mailman/listinfo/delphi >> >> > > > _______________________________________________ > Delphi mailing list > [email protected] > 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 > [email protected] > http://ns3.123.co.nz/mailman/listinfo/delphi > > _______________________________________________ Delphi mailing list [email protected] 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 [email protected] http://ns3.123.co.nz/mailman/listinfo/delphi
