VB Forum / Database Access / March 2005

Hello!
I am working on migrating an ASP page writen in Visual Basic into C#
ASP.NET. How do I convert the following 2 select statements? Thanks in
advance.

Does anybody know why I can use the form wizard to create a form with data
bound to a Access 97 database but not to an Access 2000 database. With the
latter I get the message, "Unrecognised database format
'c:\path\databasename.mdb'"

i am porting an application from VB 6 to VB.NET. This application uses an
Access database in various ways. It's a database that holds numerical data
that is updated at least every minute and therefor a lot of (large) records.
The VB 6 app uses DAO as interface to the db.

I have to read and update a CLOB field insiede an Oracle DB by using
ADODB.Stream or similar
Starting from Microsoft article
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q258038 for reading

I have a really confusing problem. I guess this is related to localisation
but i need a way arround it. Firstly i enter a date into the database in the
format of DD/MM/YYYY that enters fine however when i go to read the date i
have to read it in the format of MM/DD/YYYY. Why is ...

I need a few rows of a database im creating to be auto incrementing. So i
found out that i needed to add a line like:
objCatalog.Tables(sTableName).Columns(sRowName).Properties("Autoincrement")
= True

We have a vb6 application which connects via ADO to an access(Jet DB) on a
small local network workgroup server.
We now have a vpn connection to two offices in other countries and would
like them to be able to use the VB6 application from their offices.

I've got a dropdown list with Member's names in it...as you click on a
different name, a query is run that populates the Flexgrid with financial
info. When a Member's name is clicked on that doesn't have any financial
info, the query is blank, and the Flexgrid therefore becomes ...

How can I parse the results of a DIR command so that the filenames are copied
into another directory? This is after I filter out files by using the FIND
command, for example:
dir | find "2/24/04  12:53"

hi
I'm seeing a big performance difference between performing inserts
where the table has BLOBs rather than the old LONG RAW types using
ADO. I'd be interested to know if anyone else has seen the problem.

Hi,
How do I specify the server name that is not 'Local Host' and different for
each customer's environment?  Any sample code for this?
Thanks,

I am firing a SQL, through VB with the help of Command Object, On SQL Server.
e.g. testcmd.execute 'Update tbbtmstr set ....',cn,...
I want to Show Progress Bar, when SQL is getting executed, which will show
how many rows are updated.

I posted this in another group but haven't gotten any responses -
maybe someone here can help me out?
I have a program written in VB6 that interacts with an SQLServer
database.

I am creating an application using Visual Basic 6.0. Its a small application
but it does require use of database tables. Now my question is, do I need to
have Microsoft Access installed on the system in order to import/export data
from the VB application?

Im trying to use the VB Dataform Wizard to create a form in vb6. However
when I select an Access 2000
database as my source I get the message "Unrecognised database format
'c:\databasenameandpath'". When