We're building some very high performance database applications, and are
trying to use all of the new Async ADO.Net 2.0 features.
The problem we're having is that we can't find a
SqlConnection.BeginOpen/EndOpen method. We can execute everything using the

I am connecting to a remote SQL Server database from Visual Studio .NET
2005. I have an sql script located on my machine containing the sql code I
want to use to create several tables, and want to execute it. How can I do
this from Visual Studio .NET 2005? I do not like designing ...

I was wondering when to use TableAdapters (TA) and when to use
DataAdapters (DA).
If I've got a typed dataset containing multiple related tables, I would
say use a DA to fill the dataset. Why should I use TA instead? I can

I am using OracleConnection to connect to Oracle 9i Database from a
VB.NET project  the connection string has the parameters "User ID",
"password", and "Data Source". my project import
System.Data.OracleClient

I'm trying to run a query to return all of the customers who have not placed
an order.  This query runs fine in Query Analizer but when I try to run it as
part of a table adapter it returns all rows (customers with orders AND
customers without orders).  It appears that the second ...

I'm trying to run a queries on a schema, and I keep getting ORA-00911:
invalid character error. If I copy/paste it in SQL/Plus it runs fine.
This is what I'm doing in code:
//Set session here to ZGK037_MDB

I want to create a simple procedure in Oracle that returns a resultset
(a select query). In all the examples I've seen, you have to pass in a
"ref cursor" OUT param into the proc from C#.
Is there a simpler way to do this? IWO can I not pass anything in, and

I am moving a project over from VS2003 to VS2005.  It is an adhoc data mining
tool that lets you explore tabular data from just about any source.
In it I use SqlConnection, OracleConnection, OledbConnection, and
OdbcConnection as needed.  For each type I had special code to get ...

I'm using databindings to display data from a datatable.
When I first fill my datatable, it works perfectly, and displays the
current data.
If I remove the datatable, and recreate it with new data, it's not

Does anyone know if the new System.Transactions in .Net 2.0 works with ODBC
and OLEDB data providers?.  Thanks.
Regards,
Kueh.

I am a developer with limited database and zero crystal report experience. I
am very confused.
We wanted the ability to switch database providers easily, so I selected to
use ADO components with our application.

My MSDE database uses Application Roles.  When I run my asp.net application
I cannot open the database, I get a Logon Failed exception.  I need to be
able to open the DB to run the sp_setapprole stored procedure for my role
access.  Is there some other way that I can do this?  So ...

I am using ado to connect to active directory in a web application.
I create the command:
   objConnection = new adodb.connection
   objCommand = New adodb.Command

Visual studio 2003, MySQL database, MySQL odbc 3.51 driver
Is it possible to create the file dataset.xsd programmatically?
I'm trying to create my dataset1.xsd file for using with crystal reports.
The database is mySQL and the data connection is sat in my server exporer

I am having the following problems in getting Microsoft Visual Studio
2005 Professional to link to an Access .mdb
database. Please help me to sort this out.
Problem 1: