Subject | problem connecting to firebird database through MS C# |
---|---|
Author | clemenslinders |
Post date | 2005-04-20T14:55:58Z |
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
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