VB Forum / Database Access / June 2004

I am trying to debug a stored procedure with VB6 on SQL Server Developper
2000.
I always have a mistake. Searching the net, I have seen that I have to copy
the files from the installation CD (x86\Other\Sdi ) to the mssqlServer\Bin

I am fairly familiar with programming in Access, but I want to start using
VB for databases.  
I want to write a check-writing program (store address data for vendors,
account transactions, simple report to print checks, balance account,

I'm trying to figure out a way to retrieve the name of the underlying table
of an ADODB.Recordset regardless of the status. When a Recordset is closed
there are no Properties, so I can't sift through that list.
Is there some slick trick where I can add a quasi-property to an

I'm trying to sort a recordset using ADO's sort property, and I came across
this bit of info in the ADO docs...
"The data is not physically rearranged, but is simply accessed in the sorted
order."

I need to catch the error returned by RaiseError in the stored procedure in my VB 6.0 ActiveX DLL
I am using MDAC 2.8 and MSDE as the database
Here is the stored procedure
CREATE PROCEDURE sp_GetFirstNames A

Hi all,
I use the following code for connecting to an access97 db, using mdac
2.8, win2k, vb6 sp5.
I open my connection using

hi.. i have a question i have recordset    rsSomething and connection myCnn
that connects to sql
then i have an access mdb file with one temp table...
i need to get data from sql (filtred) to the mdb file...

I've tried all day to make this work, and yes I've searched also in
the groups but all the examples I saw didn't worked for me.
zee zettings:
 VB6 sp6

I was working on an app today and ran into a weird problem. I have a Access 2000 database I'm working with with ADO 2.7. I had some code that used the Addnew and delete functions of the recordset and they seemed to fail without any error. What I meen is that, I run delete, ...

After installation Jet SP3 (I think this is for MDAC 2.6) on MDAC 2.5  SQL with ".. WHERE... " began to give out a error 3709 (" ISAM SEEK ") on DBF-files. Say, please, what it is necessary to do for correction of job with DBF-files?
Any help would be appreciated.
Alexander ...

I'm facing the following problem : My database (MDB file accessed with Jet
and OleDb connection, I'm programming with VB.NET) contains DateTime fields
and I've noticed that the way these fields are formatted depends on the
current CultureInfo defined in a my application :

I have a VB.Net app connecting to an SQL database.  I have a dataset with
one record in it and need to check each field for a null value.  I am trying
this but cannot get the if statement to work with the null.  Thanks for any
help.

So I tried to use Null but got this error:
'Null' is not declared. 'Null' constant is no longer supported; use
'System.DBNull' instead.
So I used System.DBNull but then got this error:

I have been going around in circles trying to understand the method of
creating a database in VB.Net 2003 and distributing that application and
database.
It seems if I use the Server Explorer to create the pledbConnection etc,

hi
I am a begginer in vb and i want to know how i can search a word in a
database(Access) and then show all the items relating to that .
thank u