VB Forum / Database Access / February 2005

What's the difference between the rs.update and rs.save commands in ADO??
Gavin.

First of all, many thanks for reading this.
I am trying to enable Active Directory's "Contacts" system to be *the*
contacts database for my company.  I need to refer to it in various Access
databases.  It is not possible, apparently to use "link tables" etc, and so

I fill the Janus Gridex Component with a table. (don't worry problem is not
related with component. I tried listbox also). Then I add a record with
rst.addnew/rst.update methods.
When I call .rebind method to refresh grid, nothing happens. if I refresh it

In a vb6 app using ado connecting to a sql server 2000 stored procedure,
am seeing this error:
"Syntax error converting the varchar value 'True' to a column of data
smallint"

Sometimes I get the above error (ie. Row cannot be located for updating
etc...) exactly on the RS.Update line below:
Private Function UpdateRow(ByVal sTable As String, oFields As clsFields) As
Boolean

I migrated an ASP code to IIS 6.0
Now I'm experiencing problems with the connection to the ADO.
This function is from a dll which is called by a VB script.
The client run on server 2003 at the same location as the IIS server

I have created an update query in my dataenvironment to change the date in
the bound table to the sys date. However, the query will not accept '=Date'
in the new value box. Does anyone know the correct function. The help gives
it as 'Date'

I am trying to call a stored procedure in Oracle from my Visual Basic code.
I am using MS ADO 2.7 library to do this. Everytime I call the stored
procedure it creates a new entry for the SP in the global sql area as if it
is not using bind variables to call the SP. This only happens ...

Hello --
I can't figure out how to get the Data Project and blank form on the screen
at the same time so that I can drag the Command node onto the blank form.
I am following the tutorial on p 182 in

I have an app for tracking mileage on company vehicles.  On the first form
you select a vehicle(via combobox getting vehicle names from database) and
enter the appropriate info.  Then I need to export that data back to the
database. The ? is how do I update each vehicles info ...

Hello --
I can't figure out how to get the Data Project and blank form on the screen
at the same time so that I can drag the Command node onto the blank form.
I am following the tutorial on p 182 in

I have created an ADO recordset (from an Access table) & want to INSERT INTO
this using the Execute method.
When I do this, VB says it cannot find the table.
Code snippet is:

I'm trying to build a generic routine that will load a combobox from a
table:
Public Sub Load_Class(InCntl As ComboBox, s_Table As String, s_Item_Name As
String, s_Index_Name As String)

I have a problem,I have connected to mySql successfully. My problem is
for example, when you log in it runs through this code fine and I get
the correct results but....then when i log off and i log back in i get
an error saying "Object invalid or not set".

what should I change in the procedure below that I can call it with more
variables...(i,e)
File2SqlBlob("c:\pic1.jpg","tablename","colname")
I am having problem defining the variables within the procedure ..thank you