VB Forum / Database Access / February 2006

Is it possible to fill a predefined dataset with all the tables of a
database without knowing what the table names are. The SQL string would be
something like this: SELECT * FROM *. I want write this in code and not
using the Visual Studio UI.

Hi, bit of a beginner here, used to write a lot in VB5
including a hook to our accounts database which was Foxpro 2.6 dbf's
I'd like to do a similar link written in VB.Net so I can show the contents
of

I am getting this error on a client machine after installing my software on
it.  I have not had this problem with any other other, on all windows
operating systems.
As soon as the program attempts to access the database, the error 'Provider

How can I use my current ADO recordset transfer to data report??
thanks

i'm deciding whether to create a database program in VB6 or MS access, with
VB for applications running in the background. i just wanted some opinions,
as to which one would be better, and wat would be some
advnatges/disadvantges of doing it in vb6 over ms access??

How can you open SQL & Access databases over the internet from my VB6
program without specifying a specific port for SQL.  I believe there used to
be Remote Data Access for Server 2000 but now with 2003 Server that is not
supported or doesnot work, so I have been told.  Does ...

We have a VB .Net form-based application that uses ADO to connect to a SQL
server.  We use Windows authentication in the application to connection to
the database.  Somehow, once a while, the following error pops up
Login failed for user '(null)'. Reason: Not associated with a ...

Here is a sample of the data ...
DW8940L,0.00,,FALSE,0,0,,0.00,
DW8940R,0.00,,FALSE,0,0,,0.00,
"FAS-1/2" FLATWASHER",0.05,,FALSE,0,0,,0.00,33012

When the sql string using in query analyzer it works and we can see the
aggregates parts.
strSQL = " SELECT CustomerID, EmployeeID, OrderID, Freight FROM  Orders
WHERE  CustomerID LIKE 'A%' order by   CustomerID COMPUTE count(Freight),

I am writing a launching program that launches the latest version of my
client software.  I want it to go to the mysql server, extract the exe
from a blob field, write it to the local host and then execute it.
My code works, except that when I look at the written exe in a hex

I have an existing VB program and SQL server database. The program used to
generate crystal report. It works well for few years but since last week,
when I try to print the report, it shows
run-time error '20599': Cannot find SQL Server

I'm using VB6, MS Access 2003, DAO and Excel 2003.  In the VB code I am
trying to import an excel spreadsheet.   I just can't get the syntax correct.
Any help would be appreciated.
Thanks

I have a strange problem. I declared an ADODB.recordset and was working fine
with everything.
When I decided to create a next and previous buttons, the movenext() command
worked fined but the movepervious() one didn't !!!

it say has "JOIN" syntax error
select Order_date as Order_Date, Drug.Drug_name As
Drug_Name,Drug.Registered_Number AS Registered_No, Total_ordered_quantity As
Ordered_Qty, Total_quantity as Total_Qty, Total_amount as Total_Amount,

I have vb.net application which was converted vb 6 apllication, the converted
application use ADODC to grab data from database, but every time it run, It's
open a new connection, the old version didn't have such problem.  Can anyone
give me some advice about how to close the ...