VB Forum / Database Access / October 2004

I am working on a VB6 Sp6 app with DAO 3.6 and am querying an Access 2000
backend database.
I am running a query that has tables and a union query joined together. My
problem is that when I get the results of my query the memo fields only have

I have created a database application; the front end is Visual Basic .NET
the backend SQL Server 2000.
I wish to place the backend somewhere on the Internet, but _keep my current
front end_. I do not wish to create a webpage frontend, so no browser

I use SQL DMO - .ListAllAvailableServers - - this is fine, except it only
retrieves SQL Servers - not any instances of MSDE on the network.
As I understand it - MSDE runs on Port 1434 instead of 1433, so they don't
broadcast.....

I posted this on .sqlserver.security under the same subject and Tom Moreau
suggested I post here and see if you all have any ideas. The dialog between
Tom and I is posted below.
I have a production and development system both running on one PC under W2K

If the database returns an NULLvalue, how can i check this?
I tried to check at objfield="" or NULL but it doesn`t work.
Any hints? thx

Is there a connecton string that will prevent the first row of an excel
file from becoming the headings ?
Thanks
Chris radulich

I have a ASP (on W2K3 webedition) website build on a MS Access
database. The database contains about 10 tabels. One of the tabels
contains 150.000 records an other table contains 10.000 record the
rest contains about 100 records. Totals database size 13mb.

I have a parent-child recordset where the primarkeys are autonumbers and the
child recordset has a foreign key to the parent, example:
Parent ID: 4
ChildID: 1000

I have an variable
Dim ado As ADODB.Recordset.
it gets populated, Now I need a Copy NOT a reference of this recordset.
How do I make a copy of this instead of a reference to this

I keep getting this error when I am trying to requery a disconnected recordset.  Here is my code, what I am basically doing is saving a new record and then trying to open the recordset, requery to get the saved (up to date) data and then disconnect the recordset.  It works on the ...

I am using ADO, in VB 6.0
How can I add parameters to sql query (by something like parameter object) ?
I am doing the follows :
dim sql as string

Group,
I am very confused by the error I'm getting when trying to execute an
update statement using the Connection.Execute method.
Basically, I'm keeping a list of files and attributes in an Access

I have a disconnected recordset, this recordset could hold 1 record or
several records.  If for instance it holds one record and I want to then
save my form so that there will then be two records in the database, I want
to be able to reconnect the disconnected recordset, refresh it ...

How can I execute oracle packages in VB 6.0
(I am using Microsoft ActiveX data objects library - ADO)
Need sample code, please
Thanks :)

How to bind recordset to Flexgrid?
I always fill the flexgrid as follow,
Do while Not Rs.EOF
  'Fill flexgrid row