VB Forum / Database Access / March 2004

From: "WStoreyII" <papastoreyii@sbcglobal.net>
Subject: How Do you use a data connection on all forms?
Date: Sunday, March 07, 2004 3:31 PM
From: "WStoreyII" <papastoreyii@sbcglobal.net>

I am using VB6 to create and navigate (using .Find) disconnected (ADO) recordsets. This works great.  I now want to modify some fields in an existing row (rs.field = "Some Data") and/or add new rows (rs.addnew).  I have researched this through various forums and find snipets ...

Can anyone please tell me how to connect to oracle9i database using ODBC
in Windows 2003 server. i've tried both through system DSN & user DSN
with ORAOLDB
provider but the connection failed when i tested it. (it gives

I have a VB 6.0  client that uses a SqlServer 7.0 db as a data source.
I use ADO to get data from the DB, for example in this segment:
Dim cmd As New ADODB.Command
cmd.ActiveConnection = ConnectString

In my application, should I use a single global connection object or should
I create/open a connection each time I need it. The application is fairly
simple, there no 'transactions'.
Right now I'm using a single global connection and it seems to work fine.

I would like to know if it is possible to pass the contents of a populated
recordset(A) on to another empty recordset(B) ?
Example:  Set rsRecordsetB = rsRecordsetA
And, if so how? Thanks.

I would like to know if it is possible to pass the contents of a populated recordset(A) on to another empty recordset(B) ?
Example:  Set rsRecordsetB = rsRecordsetA  
And, if so how? Thanks.

I have a small application in visual basic to access some Paradox tables
from Excel.  My problem is that I cannot be sure that all fields I
SELECT in the SQL statement do indeed appear in the queried Paradox
table.  In case they do not, a rather cryptic error appears later on.

i have a multiport capture card 4 cameras, i can use a number of 'video ocx'
files to capture 1 camera image but none of them have instruction or the
ability to switch between the cameras.
thanks for any help

If i make a program that is bound to an access database and i deploy it to
a computer that does not have access will the program still work?
also i do need to use an outside source or is there away to create a
database from within visual basic?

Hi,  
I'm wondering if there's a way to connect to an online database using
VB 6 so I can query a database on my website.... or does the database
need to be local?  Can someone please let me know how this could be

I have a web ASP application using Access 2000 format databases which I
developed in vb script on Windows 2000. The product works fine on  IIS
in the development machine and was fairly widely used for customer
demonstration

Dear Sir,
I am havind database contain following Values.
Invoice
-------

I am using code to connect to the database tables. There are two tables I am working with to add new info and update the records. I am able to update one table but not the other. WorkInfo table is my problem child.
I create a Public gdbEmployee As ADODB.Connection to connect to ...

I'm trying to use an sql update string to update a database via ado code.
The string, as sent across, would look like this:
update avisegments set startpoint = 12736, endpoint = 15291, timestamp =
#3/5/2004 2:04:55 PM# where segmentID = 66