VB Forum / Database Access / February 2005

How would I do a SELECT on a ADODB.RecordSet?
I have created the recordset from an Oracle database using a Select
statement with a Group By. Now I need to Select from that result and
further Group By and Sum. The logic of the statements don't allow for

Is there a way VB6 can send an email? if there is a guide to do this it will
be very helpful.
Thanks

i have created a little form to add records into an existing database. the
code looks correct, as follows;
Dim Assignment2 As Connection
Dim rs As Recordset

Its been 3 years since I coded and I'm trying to remember little things.
This is one of them.
I want to run a select count(*) statement and get the number of records
meeting the criteria.  What is the syntax for assigning the returned value

I'm trying to connect MSDE server connection for class.  After loading into
VB .NET, there should be a "add server" button in the server explorer.  I
can't seem to add the button or connect to the Db server.  Please help me!!!  
thanks

I have written a VB6 app for a user that uses ADO to connect to a MySQL
database (through the MyODBC driver). Not being much of a internet
programmer, the user asked me if it is possible to move the the database to
a web server and have the client program access the database on the ...

When I try to update my ADO Recordset like this:
     recSet.Fields(2).Value = strFileNum
I get this:
   Current Recordset does not support updating. This may be a

 I would like to store a image file to my MSSQL.
 how can i program it .. ?
 Thanks all

How can i Add Column into a table with Default Value option in Access
Database?
I have given the following command but showing error"
ALTER TABLE tbl ADD COLUMN rrr Number Default 0

February 1st, 2005
More and more professionals use ContourCube in their products as the
embedded Business Intelligence. It allows companies dramatically reduce
their expenses on reporting and provide users with new quality

I have a VB6 form with several text boxes I would like to use to display
data stored in an Access db.  I've used ADODC to bind the appropriate
form fields to the recordsource fields.  If I use the ADODC in
adcmdTable mode, I get all the records and it works fine.  However, I

   I was hoping to implement disconnected recordsets for sorting purposes
in my legacy application. On the existing tables, there is a sort order
specified among the primary keys. Is there a way to enforce this in a
disconnected recordset?

i have a msflexgrid. And the data comes from a stored procedure with
parameters. My problem is to get the data out of the stored procedure into
the msflexgrid.
Does anybody have an idea how to do this?

I'm trying to connect to an SQL database from my vb.net form, but getting an
error message. The code I used is the following:
Private Sub ConnectSQL_Click(ByVal sender As Object, ByVal e As
System.EventArgs) Handles ConnectSQL.Click

Is there anyone who would like to have a look at my simple to give me some
advice for improvements?I'll send it in zip-file.