VB Forum / Database Access / August 2003

I have a VB6 application I'm developing that has to be able to query both
SQL Server and Oracle databases. The queries it has to submit will be
different depending on the database. Eventually we will probably move the
data calls into Stored Procedures but, at the moment, we're just ...

I am trying to think of ideas to help me implement the following
application.
The application is some kind of "barcode creator": you select a
"desktop computer"

as propably anyone knows RecordCount of ADO Recordsets doesn't work
reliable.
In many cases I get "-1" as the result.
Does someone knows hoe to solve this problem ?

I am trying to revive a program I did pre-1995.  Kind of
dates me - right?  I used vb3 and Access 2.0.  I still
have vb3 and loaded it on my xp box.  But I upgraded my
access to 2000.  Is there going to be any way to connect

I want to delete a record in a table. The sql statement has Joins. I
have the recordset open as
(on the air code, might have syntax error here)
Set DnTemp =  New ADODB.Recordset

because i don't know type or size of parameter
so i can't use createpameter method of ado.command.
i must use paramterter.refresh to get these information.
problem:

I have an access DB with a table called MP3--it has fields like Artist,
Title, Genre, etc.
Then I have another table called Artists.  Its only fields are Artist &
Count.

We have created a VB application in Windows 2000 Environment and created a
deployment package.
This is working fine in Windows 2000 Machines.
But when tried to use the package on Windows 95/98/XP , it give the

I have an Access database with one table and 4/fields with a lot of data.
How can I read in these 4/fields to 4 arrays and then paste the data to
4/list boxes????
Can anyone please show me any example that I can modify???

USING VB.NET / SQL SERVER 2000 / ADO
I am currently writing a multi-user booking application.
I have a program which updates a group of clinics in a
clinic file, this can take a few minutes as there is a

I created a connection (OleDbConnection) of a MS Access File on a map drive
(on the server). And I got an error:
System.Data.OleDb.OleDbException: The Microsoft Jet database engine cannot
open the file 'F:\CUPData.mdb'. It is already opened exclusively by another

Can some one assist me in understanding array's?  I need
to build an array that pulls a desired number of fields
from a database table.  The desired number of fields can
be a selection from the end user.  Any assistance would be

I am in the middle of transferring a database-driven web site to a new
server. The database was in MySQL on a Linux server, going to SQL Server
2000 on a Windows server.
The database has been transferred, and the web pages load properly. The web

I have nt2000 sp3 server running sql2000 sp3.  
The workstation are win2000 sp4 that is using vb6 exe.  
It calls a store procedure using ado 2.7 that updates a
table.  It only put in 8 records and it should be 48

Hi. I have a question. I would like to use paging. So I need a recordset
that is either keyset or dynamic cursortype. I would like to use the
ado.command object because then I can have single quotes ( ' ) in my
parameters. However I do not see anywhere that I can change the command