VB Forum / Database Access / May 2004

Hi gurus,
I have a strange problem with MSDE 2000 and MSSQL 2000. my vb application
runs a store procedure to insert data usign ADODB (MDAC 2.6), but,
frequently i got the following error:

Im using a vb6(sp6) ActiceX dll which has been registered in a SQL2000 DTS
The function below returns a clients licence number as a string. I know that it does return the correct details ( by the debug code ), but when i try and do a record count i get a -1 instead of a 1  any one ...

How do I tell VB 6.0 to not check accents in a SQL Query?
Best Regards,
Marco Silva.

I have a simple Access database set up and a form and I need to compare two textboxes,
'email1' and 'email2', on the form.
If the two textboxes do NOT match I need to change the background colour of 'email1' to
RED to bring this to my attention.

I can easily stop a second copy of my program from opening.  instead of
giving the warning "You already have a copy open" then closing the duplicate
down, how do I just make the first opened program getfocus and opened and on
top of the desktop?

I've an SQL Server table with a varchar column which allows nulls
Is there any difference between this having a nulls value or an empty value (empty string). Does an empty string consume more space than a null value
TIA
DC

Hey there, if someone could give me a bit of help with my problem it
would be much appreciated.
I'm familiar with the basics of VB, although I haven't practiced it in
a long time. Basically what i'm trying to do is update a query in an

I am prettly much new to the ADO Shape command. I was wondering if their is
anyway to relate the grandchild record to the parent record. I am using
Parameter Based Relation ship here.
Any sort of help will be highly appreciated.

I'm trying to use the GetValues method of a DataReader object and can't seem to get it to work. Here's a code snippet,
Dim dr() As System.Data.DataRo
dataReader.GetValues(dr
When this line executes it throws an Exception error indicating that the value is Null. I assumed that meant ...

I have a database with current inventory levels.
I have another db that I link 2 tables from the main database. Parts and
PartInventory.
I also have another table that will will hold fields (Part, Qty, Date).

Can anyone give me a sample of using VFP OLE DB within VB6? Or info on using
it?
I have downloaded the DLL but do not know how to use it!
Thanks

How can i get the number of affected records in Oracle db when executing sql insert or delete commnad thru connection object  in VB6
Attached code example :
  Set cn = New ADODB.Connectio
   With c

H
How I can change the back color of a toolbar in vb.Net

Is there a way to query a database for a sum by week? Any help is
appreciated.
Jerry

I am hard at work and stumbling all over myself.  Please be kind.
I am writing an app that provides the user with three combo boxes.
The combo boxes are populated with "Suppliers", "Manufacturers", and "Model
Numbers"