I am creating an ASP web service and wish to connect
to an MS Access 2003 database.  However, when I
attempt to access the database I get the following
error

I have used ExecuteNonQuery with no trouble for inserts, updates and
deletes. The best practices book I have says this is also the most efficient
way to return multiple column values from a single row. The requested fields
can be changed by users adding/removing fields from the form ...

Can somebody help with this problem please.
I need to create a temporary table from a table in SQL Server
database.  The database table looks like:
id    description                                             other

I have tried for an answer on another forum with no direct answer. I have my
forms that have a connection to an Access db with all the connections
created by the wizard. No problems with the operations of the forms in the
design environment /  machine. However, when I deploy the ...

I am using .NetFramework 1.1. and SQL2K.
I am calling a stored procedure and it has multiple results set and some
output parameters.
If the output parameter does not meet certain condition, I am quitting the

I am trying to extract the unique rows from a child table. Currently I am
set the create contraints vaue in the datarelationship to False. Because of
this, it will ignore the unique values in the child table. I want to be able
to figure out how to know which rows are unique.

I'am getting "System.Data.OracleClient requires Oracle client software
version 8.1.7 or greater" in ASP.Net apps while trying to open Oracle
connection.
I am using Oracle Data Provider to connect to oracle database and

I?m trying to connect with a paradox database from my windows dot net
application(vb.net) and web application(asp.net) using odbc driver. vb.net
project works fine, but the asp.net it doesn?t. The following code is the
same from both, except the way to display the error messenger ...

I've encountered a table that stores dates in Gregorian format so that the
dates and time looks like straight integers that cannot be easily discrened
as a date or time by just looking at it.  I'm using SQL to query the table
and retrieve the data as an integer.  I'm tyring to ...

Sahil,
Now you got me *puzzled*
I've written already:
"

I get this exception when I try to run open on the MySQLConnection
object.  It goes like this:
System.TypeLoadException: Invalid PInvoke metadata format.
  at System.Net.OSSOCK.gethostbyname(String host)

Theoretically this seems a simple thing but...can anyone help on how to do it?
I have two tables and a relationship between them.
The parent table is databound to a repeater
the Child table is databound to a nested repeater.

Does anyone know how to rename an Access table in VB.Net with OleDb?
For instance, this does NOT work:
cn = New OleDbConnection(ConnectionString)
cn.Open()

CR does have export to excel.
However the excel export is not usable, it is all messed up.  Multiple excel
row for each line & so on
Is there anyway around this one ?

I have seen difference approaches in handling transactions on the msdn site.
One approach is that you open a connection and then begin the transaction.
Next you execute command objects using this connection and after you are done
you commit or rollback thereby giving a global ...