VB Forum / Database Access / May 2005

I am getting some problem while creating Windows Services usign VB 6.0 or
Vb.Net. I am trying to connect SQL Server 2000 which is on 'Server' from my
computer i.e. 'Node1'. If I debug or run same application as a standard exe,
it will perform all database operation which i have ...

I would like to call a oracle stored procedure from within vb6 . But I
Keep getting this error "No value given for one or more required
parameters" -2147217904 . Has somebody a working snippet of code or can
explain what I am doing wrong ?

I have developed a system in VB and installed it on user's machine.Whenever
I try to view a report on a users machine, I get the following message:
"Invalid data source". the rest of the other forms works well except for the
report.

I have the following:
Set oCommand = New ADODB.Command
Set oCommand.ActiveConnection = "Provider=SQLOLEDB.1;User ID=SA;
Password=******; Inital Catalog = myDatabase"

I used article 209953 on Microsoft Knowledge base and still cannot get the
code to do what I want.  I want to provdie a splash screen then exit the vb
App leaving Access open.  But with this code, it opens it then closes it when
the procedure ends and the vb app closes.  can ...

The function Round doesn't seem to round correctly if the data is entered
from a text box but would display correctly if I read the value from the
database.
   dTax = Round(dTotal * 0.15, 2)

Private Sub find_Click()
query = "select * from coupon where coupon." & cercaper & " = " &
Text1(index).Text
db.Execute query 'the error is here...

I am trying to update MS Access DB records using a Control Array.
I have created a simple form with text boxes. txtInfo(0), txtInfo(1)...
In the properties of each text box, i have entered the Column name in
the DataField Property.

I just have a quick question and was wandering if any of you can please help
me out. I have a vb6.0 application which uses an MS Access Database to store
customer data. I want to put a password to the access database so that noone
else can go into it but the application. After ...

I would like the to know which is the fastest way to remove
all multiple spaces, not included between couples of given delimiters
such as " " or [ ] or ' ' , from a string or a stringbuilder.
For instance :

I am deploying my application to several sites and need to give the user the
opportunity to change the name of the server. Is the best way to do this to
name a global constant and give the user a button if he wants to change the
value of that constant? How do you guys usually do ...

I am trying to update MS Access DB records using a Control Array.
I have created a simple form with text boxes. txtInfo(0), txtInfo(1)...  In
the properties of each text box, i have entered the Column name in the DataF
ield Property.

I have a simple form where the user enters text, like a memo.  I would
like to then insert this memo to an MS Access DB when they click ok.
The statement i have is:
DB.Execute ("Update Info Set Memo = '" & form.txtMemo.text & "' ")

I have an application written in VB4 that uses an Acces 97 database. This
application has been widely used beginning on Win95 and NT4 through Win98,
WinME, Win2K, and WinXP. The first problems reported on this program was
when someone installed it on a machine with WinXP SP2. The ...

Perhaps I'm missing something obvious ....
I create a recordset and populate it from a stored procedure during form
load. Later on (after some changes have been made to the db) I attempt to
reload the recordset using rs.requery and this results in a 80040e10 error: