VB Forum / Database Access / August 2005

we are working with excel vba and we are quering data from DB2 using
odbc driver from IBM.
This works without a problem as long as I do no mistake (syntax for
example). But if my sql-syntax is not correct, the makro crashes. I

My table has a numeric data type but when I try to use adNumeric to pass a
numeric data type to my stored procedure, I get an error. It only seems to
work if I declare the parameter as an int data type and add the parameter to
the command as adInteger. Any help would be appreciated.

i have a search form where the user input there search criteria, this is
written to a public variable, declared in the form. When the user clicks
search, a second form appears and it should display the result using the
public variable form the previous form. the second form ...

Hi peeps.
I'm using VB.NET 2003.  I have a Jet 4.0 database with 1 table inside.  
I want to open the table and add new columns/fields from my VB app.  Can anyone give me the punchline on how to do this please?
Ray.

I am using
VisualStudio2003,
Access2003
Vb.Net and ADO.Net for db access.

I'm trying to use the ADO 2.8 GetPermissions and SetPermissions methods in
ADO 2.8, as described in this article:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado270/htm/adms
cgrantingpermissionsexample.asp
But I keep getting Error 3251: Object or provider is not ...

How would I initiate a make table query from vb.net?

I was wondering if anyone could help me. I have DataSet that contains
the following data tables Customers, Calls, Quotes, QuoteDetails,
Competitors, Contacts, Notes, and I have setup relationships between
them. Each row in the customer?s data table contains an area number.

I need to sort the listbox order by the third field in the database table,
namely the date.
At present the listbox  is sorted by the first (1) field, which are names,
alphabetically.

I run Windows XP SP2. In VB, under "References" it does not show ADO 2.8. So,
I tried downloading it from the MSDN site. When I try to install it, it says
"This setup does not support installing on this operating system".
A friend told me that ADO2.8 comes with XP SP2, and that it ...

When I set a datagrid control's record source and display the data it works
fine.  The fields that contain NULL values are blank; however, when I double
click on a particular row to extract the values it errors with a type
miss-match message #13.

I have a VB client that calls a stored proc sp1 in an oracle server.
The stored proc sp1 inturn calls another stored sp2 in another oracle server
via dblink.
This works fine.

I have an old Access 2 database that several of my clients are using.
I used the Access Run-Time component so my clients don't have to own a
copy of Access to use the database.
I've just finished re-writing my application in VB6 and have used

I have just been experimenting with Data Reports in vb6 using the Data
Environment to link to my queries in Access. After using Data Reports (it
looks like not much effort and thought has gone into it by MS) the report
produced is just about acceptable.

Can someone show me a sample code on how I can insert a binary data into a
database ? How do I retrieve it ? Thanks!