Subject problem connecting to firebird database through MS C#
Author clemenslinders
LS,

I installed firebird, I made a database filled it with some data. I
installed ODBC drivers.

When I start my MS visual studio C# I use sqlDataAdapter to connect to
the database.

In the list I see there is nothing like InterBase or Firebird. So I
try Microsoft OLE DB provider for SQL server OR Microsoft OLE DB
provider for ODBC drivers (even trying all less obvious, doesn't help).
When I make a choice let's say MS OLE DB provider for SQL server, than
I try localhost as servername and I use a valid loginname with
password.

But it always end up with the error that the database cannot be
found/SQL-server doesn't exist.

PING LOCALHOST works just fine.

When I run FBEASY+, I can connect to my database, so apperently it
does exist.

What do I need to do so that I can connect to my database using the
sqlDataAdapter. I need to make the connection through this
sqlDataAdapter because than I can fill my grid (which is coupled with
this sqlDataAdapter).

I hope someone can help me.

Kind regards,


Clemens Linders