Interbase, ASP.net, C#, and a serious headache

[Jay Douglas]

Greetings all.
I'm in need of some serious guidance. I'm working on connecting a c#
asp.net app to an InterBase v6 database that sits on a remote machine. I
can't get any ODBC / Open Source .net data providers to connect successfully
and run queries. I've tried the following things so far:

Firebird .net data provider
Mono (Well, not mono, i couldn't find where to get JUST the Interbase Data
Provider)
XTG Interbase ODBC Driver
EasySoft ODBC Driver

I'm at a loss ... I have a simple demo due in two days ... any and all
suggestions are very welcome. I'm willing to pay for whatever component is
needed.

Thx a ton.

 

[John Saunders]

Greetings all.
I'm in need of some serious guidance. I'm working on connecting a c#
asp.net app to an InterBase v6 database that sits on a remote machine. I
can't get any ODBC / Open Source .net data providers to connect successfully
and run queries. I've tried the following things so far:

Firebird .net data provider
Mono (Well, not mono, i couldn't find where to get JUST the Interbase Data
Provider)
XTG Interbase ODBC Driver
EasySoft ODBC Driver

I'm at a loss ... I have a simple demo due in two days ... any and all
suggestions are very welcome. I'm willing to pay for whatever component is
needed.

Could you narrow this down to a reproducer and provide the details here?

 

[Frans Bouma [C# MVP]]

Greetings all.
I'm in need of some serious guidance. I'm working on connecting a c#
asp.net app to an InterBase v6 database that sits on a remote machine. I
can't get any ODBC / Open Source .net data providers to connect successfully
and run queries. I've tried the following things so far:

Firebird .net data provider
Mono (Well, not mono, i couldn't find where to get JUST the Interbase Data
Provider)
XTG Interbase ODBC Driver
EasySoft ODBC Driver

I'm at a loss ... I have a simple demo due in two days ... any and all
suggestions are very welcome. I'm willing to pay for whatever component is
needed.

The firebird .NET provider (v1.5.3 or 1.6 RC) should do fine. Be sure to
specify the dialect, charset, portnumber and machine number correctly (and of
course the db filename/path) in the connection string. Have you made sure you
can reach the remote machine and the remote machine is not blocking access to
the interbase port? (and the db service is running?)

FB

 

[Jay Douglas]

The DB Service is running great. Access to the remote machine is great as
the development environment has a very small network with very few nodes.
All other network connectivity is clean and consistent on the network
segment. The IB Console from the same application machine to the database
machine is working great. Guess I'll check my versions of the Firebird .net
data provider and keep banging away at it.

Thanks for your input.