I am using the VS.NET 2003 OleDB objects and C# against MySQL 4.1 Gamma on
Windows XP. The summary of the problem is this: I am doing a series of
queries (no updates) using the OleDB DataReader, and after a few thousands
queries, the SQL server seems to be clogged and starts ...

I'd appreciate some general advice on using ado.net in a VB.net
environment for a particular application:
I need to store a large series of instrument-generated data for later
retrieval and analysis and a database (probably Access to start with

I have a windows service that will insert records into an Access database.  Or at least that's the idea.  The insert isn't happening, but the code runs without raising any errors.  When I run the generated sql statement from a query window in Access, the record inserts just fine. ...

I am running MySQL 4.1 Gamma on WinXP under VS 2003 / ADO.NET and trying to
use the OleDb ExecuteScalar() method (as opposed to the DataReader) and
consistently failing - getting 0 always.
Here is the code:

(Type your message here)
--------------------------------
From: renu
Friends,

Hi NewsGroup,
Hope this is the right news group for this.  Programming data access code in
C#, .NET Framework 1.1, using OleDb classes.  As an example I'm doing
something similar as such;  Keeping it brief sorry about syntax...

Here is my code:
       'open connection to database
       Dim ADOcon As New ADODB.Connection()
       Dim rsOverdue As New ADODB.Recordset()

I'm using a DataView to filter a DataTable based on a long (Int64) value.  I
sometimes get an EvaluateException (with the message shown in the subject
line above) on setting the RowFilter property of the DataView.  I've tracked
it down to certain "magic" column values for a row ...

I installed sql 2000 from my subscription dvd after i have installed
sqlexpress. There seems to be a problem for the SQL2000 service to start.
Is ther something I can do?
I use my computer name as the server name and windows authentication.

A Google Groups search on this topic returns many unanswered posts, so I
must not be the only one  ;)
I have a simple many-to-many situation;
[ tbl_Shots ]

Is there any way to export object and data between SQL server databases
programatically? I would like to create windows form using C# to export data
from DQL setrver to another SQL server database. Your help is highlt
appreciated!!

Im developing some application that is connected to a Sql Server and I need
to read a value and increment it in a multiuser envirnment. I'm trying to
lock the table at the moment of reading the data, but setting a breakpoint
after the select command is executed, the table is ...

How can I automatically creating all the database fields on an Asp.Net form
using VS.Net IDE, like that of FrontPage 2003 that can do it with Databse
Wizard
Thanks

I got an exception telling me that Invalid Casting on a Date field. Here is
what I attempted to do in my Asp.Net app:
1. A class that contains 4 fields called Employee Record (eye), two out of 4
fields are DateTime type. The class name is "eyeClass".

So I'm getting my head aroud the DataSet and the "disconnected" way of
working with data.  One thing that I'm finding is that to work disconected,
I need more data in my query results than I used to.
For example, in my order table I have a FK userID column, since I want to be