Subject Re: SQL Error Accessing Database Server (GDB)
Author Gary
Thanks, Aage!

--- In ib-support@yahoogroups.com, Aage Johansen <aagjohan@o...>
wrote:
> On Thu, 12 Jun 2003 16:35:01 +0000 (UTC), Gary <glablj@h...> wrote:
>
> >> ...
> > A bit of clarification...
> >
> > The string supplied to the connection path specifier the very
first time
> > a client runs the app and connects to the database is the UNC
path to the
> > GDB file. That gets translated to look like the following in the
BDE and
> > ODBC entries:
> >
> > "Cnv-eng-lab-si1:\CMMS\AppServer\Database\DATABASE.GDB"
> >
> > That's in the lab. "Cnv-eng-lab-si1" is the name of the Win2k
Server;
> > CMMS is the share; \AppServer\Database\DATABASE.GDB is the path
to the
> > database server file.
> >...
>
>
> Forget about the share. Use a connect string like:
> <servername or IP-address>:<drive>:\<full path>\<database name>
> e.g.
> THESERVER:D:\DB_AREA\mydatabase.gdb

That makes sense. We were never given any documentation with this, so
I've had to learn everything by butting my head against it, hitting
it with sticks, or asking questions when I can't figure it out. <grin>

> or
> 198:168.123.100:D:\DB_AREA\mydatabase.gdb
>
>
> --
> Aage J.

Take care,
-Gary