Hello,

Finally making the shift away from using IBX to access my interbase database
to ADO. This is because I can see a growing need for me to connect to a
variety of unknown SQL servers and as far as I can tell ADO is the current
prefered method (BDE being phased out and dbExpress to limited).

I have a VERY simple example application that is trying to connect to an
interbase db (one table, 6 fields of varchar(50) and a primary index). A BDE
table connects (through an ODBC configuration) fine BUT an ADO table causes
problems. It can determine the available TableNames but when I try to
activate it I get "unspecified error".

Versions of relevant software is (as far as I can tell)...

D6 enterprise
IB OpenSource
Firebird/interbase ODBC V1.00.00.05

Any help appreciated

Thanks

Stuart

Avoid using the odbc drivers through ado. Microsoft have deprecated that.
see the list of oledb providers for interbase here
http://www.adoanywhere.com on the third party page.

The oledb providers for interbase behave differently. I prefer this one
http://www.lcpi.lipetsk.ru/prog/eng/ because it has steadily improved over
the last months, it worked best when I initially tested all the providers
and they respond quickly to any questions I have (as well as providing me
with free samples for evaluation on everyone's behalf), but try them all
with adoanywhere to choose one that works best for your needs.

You will probably find your error will go away when you switch to ado
without the odbc, if your problem persists then it may be a field specific
problem so try opening different tables to see what happens.

--
Mike Collier
ADO Tool, Support & Development
Free Trial http://www.adoanywhere.com/download/aaBrowser.zip

Thanks very much for this. In the usual way of these things shortly after
posting I came to this conclusion! I have now tried a oledb provider for
interbase and found that the error does indeed go away. I have also managed
to run a test program that creates an access db or an interbase db depending
on the udl description which is what I was ultimatley trying to achieve.

Once again, many thanks

Stuart

news:3d8b0af9@newsgroups.borland.com...

Glad to have helped, best o' luck.

--
Mike Collier
ADO Tool, Support & Development
Free Trial http://www.adoanywhere.com/download/aaBrowser.zip