Anyone had any success in connecting with InterBase through ADO.NET?  I
would like to know how to do it.

We have a database that is accessed by the web to display the data.  We
also have programs that insert or update to that database.
What I want to be able to do is insert data using a transaction but I
don't want the web page to display any new rows being inserted until

Let's say I have an existing view on a table which has 4 rows. If I add a
row to the table at position 2, the view treats it as position 5, instead of
it's physical location.
Note: there is no sort on the view.

I am currently getting a General Network Error were I was not getting one
before. The batty thing is the error happens about every other connection to
the database. I have looked at the SQLException that gets generated and the
error number is 20.

I would like to concrete my understanding about my custom object using an
ADO.NET connection object and the behavior of garbage collector.
I have a simple .NET object
   public class DBACCESS

In VS 2003 we used Data access layers intensively.
Is the same pattern valid for VS 2005? Or new data source features ceases
its
existence...

these two parameter field are varchar type in DB.
when I pass an empty string in one of the paramters the result set is empty.
but if I one parameter is something other than empty string, and the other
is existing value in the db, the result is correct.

We have an application server which serves as an access point to a
database.  Each user connected to the server has their own connection
to the database.  Pooling is turned on, but since everyone has a unique
Workstation ID, they share with only themselves.

unable to load oramts.dll
when i am trying to open the connection it is show the above problem.
get me the solution.
From http://www.developmentnow.com/g/7_2004_6_0_11_0/dotnet-framework-adonet.htm

we had strange memory usage / memory leak of our web application which we
could strip down to a (at least for us) unexpected behaviour of a dataset.
Scenario: With application start we open a dataset keeping a reference of
some datatables as long as the app runs. During this time ...

After creating a NewRow and Adding it to a DataTable, it receives it's
autoincrement ID of -1.
If I try to find it by DataTable.DefaultView.Find(-1), it returns 0, which
is incorrect since it is actually at the end of the table (over 1000 records)

My program grabs a single datatable (dt) from an Excel file, loads it
into a dataset (ds) and displays it in a datagrid (dg).
The datatable has a couple of "calculated" columns that start out
blank. After loading the datattable, the program fills in these blank

Does SqlDataAdaptor do an explicit table lock when calling Update? We have
an importer that connect to SQL Server 2000 and anytime imports are being
written to a table and a query is ran against that table at the same time we
get a timeout exception.

I'm new to .NET..  I have multiple related tables that I need to insert data
into.  Lets say for example:  Customers and Orders.  Orders has a foreign key
Customer_Number column in it.  I want to use the dataadapter update method to
do the inserts for me.  Ideally I'd use a ...

Im using OleDb
How do I send a parameter to an In clause ? My SQL is like this.
Select name from contact where accountid in (?)
accountids are char fields of length 15.