VB Forum / Database Access / January 2007

This question stems from losing the first row from an excel data source when
opening the recordset. Lance kindly helped me by telling me to use the
HDR=No option in the connection string, but this now causes "Could not find
installable ISAM" when trying to open the connection.

I am referencing ADO 2.8 in my VB application and I told my users that they
need to install MDAC 2.8.  However, they are not able to install MDAC 2.8 on
Windows XP SP1. Can users that have Windows XP SP1 run my application?  If
not, what do I need to install on Windows XP SP1 or ...

I'm using the following code to get a recordset of an excel file. I use the
getrows call to fill the variant array p. The problem is the first row is
always missing. Is there a flag or something I can set? Also, when I set a
watch, I see properties called NAME, VALUE and ...

I am using transaction type - TransactionScope in Visual Studio 2005 and .Net
Framework 2.0.  When I access the database over a VPN, I get a transaction
timeout on a longer running stored procedure.  How can I change the timeout
value for the transaction?

I'm trying to test our DBMS for ODBC/ADO conformance, and am running
into something odd.  In the simple code below I'm opening an ADO
RecordSet with a cursor type of  adOpenForwardOnly.   However when the
object is created the Cursor Type property is set to adOpenStatic, and

I've just recently moved into the applications side of things - I've
been a sysadmin for the last 12 years and have dabbled in VB... but I'm
far from an expert.  I've inherited a bunch of apps from a guy who's
retiring, and have a question:

how i load images from ACCESS  database to VB .NET  form ?
This images are in field type : OLE OBJECT.
Any example ? Any ideia ?
HELP ME !

I have a VB6 application that works opening MS Access 97 (.mdb) files, but
does not recognize MS Access 2000.  I have Office 2000 (including MS Access)
installed on my machine, so the drivers should be up to date.
I am using:

I have an adodb record set, rstPhone, for a table in an Access database.
There are two Primary key fields: ListID (text, max size 40) and LineNumber
(long integer). There are no other indexes and ListID does not have to be
unique. I am testing to see if the ListID and LineNumber ...

I developed one application in  vb. In this my database is on one pc &
i want to access my application from different pcs. I have added
datareports in this application. I distributed the exe of this
application to multiple users. All Program is running properly. All

I am relatively new to Visual Basic 2005 Express Edition.
I am trying to create a simple program that:
1. Creates and populates a dataset in the form_load handler
2. Transfers control to a new form to input user changes to the data in a

I have a commercial product built with VB6 that has an mdb backend via
DAO and I am happy with it.
There is a point with high usage among some clients where  I will need
to make an upgrade to something like SQL server Express in about a

I know how to retrieve the fields of a table.
I know how to find out whether a field is nullable or not.
I know how to find out whether a field is primary key or not.
These are all clear to me.

I'm reading from a fixed length file into a SQL database. Currently, I'm
doing it record by record, but I think I could get much better performance
if I did a bulk insert. I'm just not sure how to go about doing it. I have
to parse 2 lines out of the file for each record. Any ...

Does anyone have an example of how to add a field to an XML document that is
generated via an ADO Recordset.Save?
Stub example:
rs.Open "SELECT * FROM Table"