VB Forum / Database Access / September 2005

I'm trying to find a way to handle an error on a failed adodb
connection to a sql server database in vb6 code.
On Error Resume Next and On Error Go To haven't worked.  It fails on
the sqlConnection.Open line, but it doesn't go to my error handler.

I need to know, how can I read an excel file using visual basic and then save
the data in another format.
I do not want to use databases at all.
Is it posible?

Does anyone know how to create an Access ODBC by programming ? Thanks !
Rick

I am having trouble with a SELECT query. I want to be able to create a
recordset with only, say, 5 records in it, based on the currently selected
record. The second recordset would only contain the current record and the
four preceeding records, in order to then create a moving ...

Some colleagues and I are debating the absolute necessity of executing the
Close() method on a recordset once you're done with it.
I have always heard it recommended that you should always execute the
Close() method, and that failure to do so could result in the recordset

Hello, somebody know how can I call a stored procedure from visual basic 6.0?
And this sp return a value.
Regards,
Oswaldo

good morning,
I have several tables in my SQL Server database that use bit data type.
Whenever I display the values of that tables using a datagrid the "1" values
appear as "-1". Does anyone knows how to fix this?

I'd like that  whether there are more different language version of
mdac_typ.exe. or
not If yes, what I should download if I don't know where my app will be
running.

Here goes with (hopefully) a better explanation of my problem. I am using
VB5 and have text files with dates and closing prices of stocks. I want to
be able to display a data bound grid with the information along with a
moving average of the prices. With apologies to those who ...

Greetings,
I have attempted to code the following into a sql server 2000 acccess
database.
        strSQL = "SELECT * FROM tblDocumentTypes" & _

I have a spreadsheet where i pull the data in and then try and compare it
against an access database.  However I seem to have problems with the syntax
of my SQL.  In my spreadsheet columns 1 and 2 are both formated as Text
fields.  I therefore import them into my recordset.  I ...

Hi, it's Rouf here
I want to know more about how to call the stored procedure from vb6.
I have a query which keep on looping getting the results from the first
query and then returning the value back to vb6 program.

The following oracle query runs fine, however I need to use the INNER JOIN
Keyword in Sub Query.
Update Invoice x
set Ticost=

I don't know if this is a right group..
I have a problem with recordset.filter, for example:
recordset.filter = "field1 > 19"
I get rows where field1 is 2, 3, 5 and 20. How can I make this work?

Please help me....I want to made database application with winsock
object for Clients and Server. I have any question about TCP/IP address,
if I run both Server and clients application in same computer. What is
it IP Address?, I have been made application but I can't test it.