VB Forum / Database Access / November 2004

i have one problem with simple query (this is an example)
Dim dbs as Database
Dim strLocal as String
Dim qryString as String

I'm trying to implement a 'Detach DB' scenario - -
my code is :
oServer.Connect dbName, ServerID, ServerPwd (all variables verified)
Then, I got a message that this connection was closed - so I did an:

I am new to ADO....
I am selecting records from a table using ADO and the .recordcount property
always shows as -1, even when there are records in the recordset.
What do I do to refresh that? I even tried a .movelast and .movefirst but

  I have an application that downloads web pages frm a predefined URL.I
have a  set of 2000 keywords that needs to be checked for each of these
downloaded web pages. If it finds any match it skips the further
matching...Now the issues is if i put this keywords into DB it needs ...

If I sort a recordset from a SQL Server database by using the recordset's
"Sort" property, will the sort use the collating sequence defined in the SQL
Server database for the column I'm sorting on?
I've searched but can't find an answer to this question.  Sorry if I've

How to write informations from database in Page Header section like in Detal
section of DataReport?

I have created a windows application in VB.NET and I want to retrieve
data from an access database. I create the OleDbConnection, an
OleDbAdapter, a dataset and finally a Data Form using the Data Form
Wizard. Everything works fine.

I am attempting to create a recordset based on an SQL statement where the MS
Access 2000 db table name  has spaces in it (this sucks I know)
In Access, you would simply code the table name with sqare brackets around
it like this... "select * from [Cust Service]"

I am using the Data Adapter Configuration Wizard in VB .NET 2003. When using
the Wizard I am getting "! Generated SELECT Statement. There were errors
configuring the data adapter." What were the errors? Where can I go to find
out what errors were detected? How do I fix this ...

I try to run queries that has few links on the tables.   I kept getting
"ODBC - Call Failed" and after clicking "OK" then there is no error message
at all.    How come!
When I use query that has pop-up "Date Parameeter"  (Between [BegDate] and

I wrote an app that has a lot to do with a database.  I'm trying to
follow MSFT's best practices, but I want to distribute my program, and
more people use Access than SQL Server in desktop environments, so
that's what I'm going with.

Scenario: Two servers hosting ASP. Identical scripts use ADO to
retrieve data from back end (DB2). While processing ResultSet reading
database column that is an 8-byte integer, one server correctly
retrieves the value. The other server truncates the value after the

Can I use the absoluteposition,recordcount command for server-side cursor ??
Thanks
Jason.

I have developed a DSN-less app for a network (XP-pro/Access) and it works
perfectly, saving new data and all !. I now would like to place the database
at a certain IP address which I do not have yet, so I am testing the app
using "//127.0.0.1/database/appdatabase.mdb" which I have ...

I have some code running in the field on a test server. I have written stuff
to the event log to debug my code which is not working. (Or I would not be
bugging you all.)
A sql string is create, SELECT...