VB Forum / Database Access / January 2004

I'm back again folks. The newest problem comes up when I used the button I
have for adding a record from a form into the database. The interesting
thing about it  is that it only occurs with any form after the first
interface form. The "add data" button works fine on the first form.

i have a VB6 ( SP5) project that is using one of two
systen DSN to connect to either a live SQl2000 server or
a devolopment one.  The user selects the desired DSN when
starting the system.  One of the problems i have is i

HI..
I wanted to ask a very generic question. I had developed a small project in
VB-Oracle. I nowhere used PL/SQL...everywhere i had to manipulate or delete
record i used...ado..recordset.movenext or .delete .....etc.

2004-01-07
Hi everyone,
VB 6.0 Enterprise
SQL-server 7.0

If you create a parameterized query in Access and use the DataEnvironment to
execute it, the Parameters collection has no @RETURN_VALUE in the
collection. and the first index (0) is the first real parameter.
If you make a stored procedure in MSDE and use the DataEnvronment to ...

How do I make an  SQL query command with a join to tables in two databases
on different connections within the dataenviroment designer.
I have a small VB6 application. which will connect to two Jet 4.0 databases
one which I have control over and one which is part of another ...

I have several workstations that login to a WIN_2000 Server and Connect just
fine to a SQL-2000 Server (different machines) over a dedicated VPN.....
They have a x.x.2.1 addressing scheme and we have x.x.1.1 addressing scheme.
Everything works beautifully for a while.

Is it possible to reference and use an object written in VB.NET (with
ADO.NET)  in VB6 (Standard exe or ActiveX exe)?
Any help or tips would sincerely be greatly appreciated.
Thanks

According to the docs, this should produce a recordset that will allow me to
see changes made by other users to the recordset yet I do not get this
behavior.
adOpenDynamic does allow me to see the changes, but has no visibility of

Running VB6 and SQL Server6 on Win2k
I have 2 dtpicker controls that are not binding to the ADO data control.
 All the other controls are binding fine.  This was from an example
program that used OLE and I am using ODBC - could this be the problem?

is it possible to have 2 columns in a DBCombo.
By example: I wnat to have Customer ID + Customer Name in the scroll down
list of the combo.
It's possible in VBA Access because the access combo is able to do it but

I use SQL server as backend and use VB6 as front end.
I create a sql statement , I use a where clause to find the data. My
question is how do I make the program ask for an input where i can enter the
data. How to make the sql statement ask for the data.

I use SQL server as backend and use VB6 as front end.
I create a sql statement , I use a where clause to find the data. My
question is how do I make the program ask for an input where i can enter the
data. How to make the sql statement ask for the data.

I am working with VB 6 (SP5). I have an application that
uses the Microsoft ADO Data Control (SP4). There is a
DataList associated with the data control. I am connecting
to an Oracle 8.1 database with the Oracle ODBC driver.

Anyone know a Data access combination that enables you to see updates to the
underlining table's current record without performing a Resync (not
available due to provider) or any Move? Would like to not Requery as well.
Probably not doable, but jsut wanted to make sure.