> Do you just want to use the API to getthings like the server version
> or do you want to use it to run queries and fetch data?

I'm trying just to get the server version. For anything else I use an
OLDEDB provider.

> I could be wrong but I don't think you are going to be able to

access

> firebird in any meaningful way from vb6 using api.

It could be possible - any API function can be implemented in VB, but
it is not meaningful if OLEDB does his work ;)

> --- In ib-support@yahoogroups.com, "paul_damian <paul_damian@y...>"
> <paul_damian@y...> wrote:
> > Hi *,
> >
> > I'm writing an front app for Firebird 1.0.2 (actually porting it

from

> > MS-SQL) in Visual Basic 6. I'm trying to use the

isc_service_query

> > API function to retrieve the server version. And I'm having

trouble

> > to write the Declare Function in VB and call it, and I don't

don't

> > why.
> >
> > In an article on the Borland site, there's a statement that for
> > passive services (like this one) there's no need to attach a

service

> > (isc_service attach) before calling isc_service_query, but in the

API

> > documentation it says that it is manadatory. So, where's the

truth?

> > So, I don't know how exactly to build the SPB, because I have to

give

> > out username, password, server & protocol

(192.168.0.1:service_mgr)

> > and the isc_info_svc_server_version constant.
> >
> > Any help? ;)
> >
> > Best regards,
> > Paul