VB Forum / Database Access / June 2004

I am executing a stored procedure that inserts values into database.
When inserting a string parameter i see that when it is inserted it is
inserted with spaces (as many as it was defined with)..
I want to know how to cancel these spaces!

Its is always said closing a recordset before setting it to nothing is good
practice. Why is it so and what actually is happening behind when we do so
Thnaks

How can I access to dbf file (clipper) for example Client.dbf using ADO
Thank you for your help!

If anybody can help me with the following problem in VB6:
I've got 3 Tables that are linked in an Access mdb file. Using ADO. In vb
the connection is working properly and all related subtables are linked. The
tables are as follows:

hola, me gustaria saber en VB6 como puedo hacer el OPEN si tiene clave,
pensaba que era así, pero no:
Set BDD = OpenDatabase("bd1.mdb", , , "DATABASE;UID=;PWD=miclave")
Por otro lado en ASP si tuviera clave usando el siguiente codigo como lo

Have been writing a database handling program using VB4 on a Win98 system.
the .mdb databases are held on the HD with no external references.
Since updating to a new, much faster system using XP most of the SQL queries
operate a lot faster yet some have ground to a halt.

I have a column in SQL Server defined as Numeric(12,3)
A Stored Procedure is used to insert data into a table.  From ISQL, the
sp runs fine.  The VB ADO code works if I create and execute a string.
However, I want to be able to get the return value back from the stored

I got following error whenever I use RS(<fieldname>) = fieldvalue.
Error Type:
ADODB.Recordset (0x800A0CB3)
Object or provider is not capable of performing requested operation.

Is there an object that will allow you to get a directory of a file? What I want to be able to do is get a directory of a file and copy that file to another location.

Im running VB6 (SP6) and SQL 2000. I have a Stored Procedure on the SQL server that generates a Recordset of clients & details to be invoiced. Ive looked through the help systems and have come up with the following code which works fine on my laptop connecting to a local SQL ...

I install a update to date ODBC and running following code to connect with
DSN and get following error.
My server binds with 2 IP and hosts 2 separate web. e.g. A and B. I test the
code in web A. It is ok but fails in B. I don't know why. because the same

Okay, add me to the list of folks who are beating their brains
out trying to get Connection.Errors to return more than
the first error.  No matter how many low-severity errors I put
into my SP or my SQL, no matter how many PRINT statements, no

We have built a small VB6 application to isolate a deployment problem
we have with some servers since we have migrate MDAC from 2.5 to 2.8
recently.
The program is using Microsoft Data Environment 1.0 (MSDE.dll &

What command syntax to use to delete all the data in a table ?
Not delete the table itself.
The only way I know of is to loop thru the entire table RS count
and do RS.DELETE in each of the loop.

I've developed an application (VB 6.0, DAO 3.6 Object library, Access 2000).
I need to password protect the MDB file. And I made the changes in
application also, where I was opening the database.
Code is as follows: