VB Forum / Database Access / January 2004

How does the timestamp column  works in sql server. For
example if I have three columns in my table-
Job | DoneBy | TimeStamp
Now when I want to insert row from my vb program, what

I have searched Google but just cannot find any details.
I have some details but this is for Transact-SQL which I don't know if I can
use.
I need to create a SQL2000 table within a VB6 program. I am connecting to

I have created a DataReport using a "command" that i setup under the
DataEnvironment. The report displays (and prints) perfectly well.
Heres the problem - with the application running, if the user changes
any information and then reruns the report, the report does not show the

I want to use a connection string without DSN, but when I try:
Dim db As DAO.Database
Set db = Workspaces(0).OpenDatabase("", False, False,
"ODBC;DRIVER={Oracle ODBC Driver}; DBQ=myDBQ; UID=myUser; PWD=myPassword;"

i need re-use a .mdb v.30 file, in a new vb6 program, when
i try for first time (Jet 3.51), open the file, i
read/write, all is ok, i return to the old program for
compatilibity purpose, its open the same .mdb file, all

Is it possible to get back to the underlying string which specifies the
calculation which defines a calcuated field in a query.
e.g.  If my underlying SQL is this,
SELECT MyField1, MyField2, MyField1 + MyField2, Format(MyField1, "0.0"),

An Access 2002 database application often does not delete
the .ldb file when a user exits.  The users have delete
rights in the folder with the database and .ldb files.
Anybody have any ideas to help with this?

In the event that the connection parameters for connecting to a SQL
server are incorrect I am currently getting a SQL Server Login dialog.
I would like to stop this from occurring and, instead, prompt the user
with my own dialog and then point them toward my own data connection

CREATE PROCEDURE dbo.spcn_update_transaction
@custname varchar (50),
@custst varchar (50),
@custzip varchar (50),

When creating a record set that is disconnected, I'm not sure whether I
should close the connection object or simply set it to nothing....if I
explicitly close the connection,  does this stop it being pooled?
For my code example, see the ***** below

Does anyone know why I am getting this error:
Run-time error '-2147418113': Catastrophic failure
, from the following:
Set rstCat = New ADODB.Recordset

 i need to know. how to implement text drivers.i'm using
text file as my data storage. how do i perform sql
statement with the files. Try giving me some example.

Hi
I know that this has been asked 1000 times, but I cannot seem to
understand the answers that were given. Could somebody please explain
what I am doing wrong here.

Ok, first thanx for answers in advance.
I am wirting a VB6 application that loads it's images from a database (ADO
2.7). At the moment I have do the following steps.
1) load the image (as binary data) from the database using an ADODB.Stream

One of our customers neglected to install the latest
release of a product, on all servers that use the product.
The new release added two new fields to a table in the
database.