VB Forum / Database Access / January 2007

Does anyone know if it is relatively easy to access SDF (SQL Server Compact
Edition) databases from VB - desktop app, not mobile?  Are there a set of
free data access objects out there (boss has a bit of a phobia about
third-part components.)?

i use VB6 and i want to make an ODBC Connection to a Excel File. Do
somebody have an example to make the connection and get only special
data. For example i need the Data from then colum "AE" and row 1 to
1000.

Is it possible to connect to SQL Server 2005 using VB6?
If it is possible would anyone share the code?
Cheers,
Max.

I want to enumerate alla sql server in a know damain named DIP, and
store the name of server fopund in Excel, Access or other db.
Tks.

i am doing a project on zodiac sign.when we enter day and month the zodiac
sign should get displayed accordingly. eg. when we select 23rd march the
zodiac sign aries should get displayed because it comes in between 20th march
and 20th april.now the problem is that when i enter ...

I am pretty good with VB, but I don't understand how to use databases
with VB yet. I prefer to use VB6 over 2003 or 2005 because I don't have
to worry about the bloated permissions.
I am trying to access an MS Access 97 database called "DB.mdb" with

Why doesn't the requery method work?  I have code similar to this in LOTS of
spots throughout my program but the rsCCIPinCheck recordset will not requery
when I move to the next record in the rsCCIDistinctDias recordset.  I
suppose I could close and reopen rsCCIPinCheck recordset ...

Why doesn't the requery method work?  I have code similar to this in LOTS of
spots throughout my program but the rsCCIPinCheck recordset will not requery
(refresh the data)
when I move to the next record in the rsCCIDistinctDias recordset.  I

I'm developing a VBA vs. SQL Server 2000 application , and I have a problem
with some Stored Procedures.
All SPs have their own Error Trapping, so if there's an error during the
execution, we have a VB validation reading Output parameters in order to

Is there anyway to import RTF to ADO using VB?
Thanks in advance,
Michael

We would like to create an MsAccess.Mdb in office 2000 to obtain individual
table details from Accpac Plus in Dos (an accounting program)?
Can we receive any ideas or a sample database of how to do this?
Thank you

I'm using vb 2005 with a sql database, and have managed to delete the
current row from the datagrid, but am not having much luck getting it
deleted from the table.
The first two commands work fine for the datagrid, but the last command

I want to display all the tables for the ODBC conection. By using
Set objRs = objConn.OpenSchema(adSchemaTables)
I can get the list of Table Names. Now, how do I sort it furthure to show
the list of tables by table owners.

Why does my recordcount return -1 when I have 100 records?
-Lou

We would like to create an MsAccess.Mdb in office 2000 to obtain individual
table details from Accpac Plus in Dos (an accounting program)?
Can we receive any ideas or a sample database of how to do this?
Thank you