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