VB Forum / Database Access / August 2004

Anyone:
I was just wondering if I have an ADO .NET Database Transaction in my VB
Project, and I also have a trigger in a SQL table that is involved in this
transaction, then did a Rollback on my transaction, would the record or

I am having a problem with the results of an insert into SQLServer from a VB
component (hosted in COM+, does not support transactions) takes a while to
show up in the table.
The basic flow of the component is as follows:

I am very new to VB 6.
I have two access databases named "isdb" and "crdb" created with visual
data manager and i enter data using form created by data form wizaed in
vb6.I dont know that index has been set or not and primary key is

I have a vb program written that works great, except for one nagging issue.
It' uses ADO connection, however I have to manualy create a OBDC connection
for it to function. Can code be added to check for this OBDC connection to
see if it has been created and if not then create it ...

Any ideas why a query would work just fine in an Access query, but if I send
the same query string from VB6 it would fail?
It works fine until I try to use the phrase
   LIKE '*keyword*'

Hola a todos me encantaría recibir información de lo que significa Ado ya
que no tengo conocimiento para de ello.
Muchas gracias.

Do you need custom programming done for your business, or even your home
projects?
We are an experience computer programmers from Russia.  We do all kinds of
custom jobs for people who need something special,  but  don't need to hire

I have a decent problem. I want to create a database query-tool that shows a
list of cities and let the user choose wether it should be included in the
query or not by switching a radiobutton.
I did the sample from MSDN with two checkboxes (binding the city-name column

My stored procedure create a nonUpdatable recordset becouse I have a complex
structure of data in my select.
All I need is to add some temporary records in that recordset and I don't
need to save that temporary records in database. I need that records just to

I'm trying to find a usable example of accessing a dBase data file using
long file names in a VB app. The problem is the dBase standard is firmly
rooted in the old 16-bit DOS world and is mired in the 8.3 naming
convention.

   Can anyone elaborate the difference between adLockPessimistic and
adLockOptimistic. The way understand is you get more Mult-User protection
with adLockPessimistic in that you can add or delete a physical records
where as adLockOptimistic allows only edits (.Update). If you add ...

I upgraded to MDAC_2.8 and now, during
VB coding in Access, I cannot get context-sensitive help
(i.e. using F1) to pop up for any ADO or ADOX items.
Any clues?

Because the previous message did not post well I try it again.
Hi,
Something strage happens using FilePattern. I use the function below to
display

Is there a way, in ADO - not using DMO - that, once connected to a server,
you can open a  specific SProc and show it in a Textbox, using VB?
If so, can someone point me somewhere to learn the syntax to do so?
Thanks

Need to Create a Data Entry Screen for Users.
The table will be a MS Access DB with 98 fields. The user can either enter a
sortname (7 Chars) or a Zip Code (5 Chars) that will display only the
following fields in the row, Name,Title, Company, Address, City State, Zip.