Subject Re: [ib-support] Connecting to db using C
Author William L. Thomson Jr.
On Wed, 2002-07-17 at 13:36, William L. Thomson Jr. wrote:
> On Wed, 2002-07-17 at 02:25, Paul Reeves wrote:
> > Well, I tried compiling api3.c on an NT box and connecting to an
> > employee database on a remote Linux box. Depressingly (for you), it all
> > worked as expected. I passed servername:/path/to/employee.gdb as an
> > argument to the program. Connection was established and data retrieved
> > without problem.
>
> Great. I was able to get past my localhost issues by using dpb's, which
> I assume I will need either way to pass along a user name and password.
> Not to mention other things I may to have set later in my app.
>
> > Can you use ISQL from the client PC to connect to the database on the
> > remote server? I suspect you have a configuration issue somewhere, but
> > other than that, I'm afraid I'm out of bright ideas.
>
> No I get the same error with that as in my C app.

Ok, I am now able to connect using isql. I had to look up some command
line options and specify a user name and password. After that I was able
to connect to my db.

Now I am specifying the same in my C app, just like in an example in the
pdf docs. pg 48-49 of the ApiGuide.pdf
With the exception that I have entered the user name and password. The
example gets them from command line by requesting it.

Now I have found the problem. The book pdf says to use

isc_num_buffers

Which when I attempt to compile it did not like it. So I commented it
and it's value out.

When I went back to reference the dock I saw that it should have been

isc_dpb_num_buffers

So when I uncommented it and changed it to that, it worked perfectly. :)

Now I can get data to and from my DB from my C apps. Yeah. :)

--
Sincerely,
William L. Thomson Jr.
Support Group
Obsidian-Studios Inc.
439 Amber Way
Petaluma, Ca. 94952
Phone 707.766.9509
Fax 707.766.8989
http://www.obsidian-studios.com