VB Forum / Database Access / March 2007

Please help me... Somebody have a VBScript that export data from SQL Server
database to Exel?

I am trying to fetch Primary keys for different tables in Oracle and
Sybase. After doing some search, I found the following code, but I am
not sure how to get the primary key from recSet
recSet = objConn.OpenSchema(adSchemaPrimaryKeys,

I have various MSFlexGrids in my application. I was wondering if there is a
property uou can set that re-sizes all the row hights together when the user
resizes one of the rows? Each seems independant of the other!
Guess its unlikely,

I have a VB6 application that currently allows the user to create and access
multiple Access databases (each database is for a different project), via an
DSN-less ADO connection.
Users can create a new database or access an existing database. Once a

We would like to limit the use of our Database application per number
of licenses issued for our software. In other words,
we want to prevent the same user to login from 2 different machines.
We are thinking of creating a table with a record per user and flag

I am trying to validate the value entered in a text box with the value in
the database using ado.net by the click of the Check button. For eg: If
someone enters a domain name in the text box and they click the Check button,
I want to validate that value with the value in the ...

I'm trying to find a method in VB.Net to store images and other files in an
Oracle database. I already have a routine that stores images and files in SQL
Server but it does not work with Oracle. The method I use for SQL Server is:
Dim cn As New OleDbConnection(gstrAdminDBSource)

I have code that in some cases works with recordCount and others doesnt
(always returns -1 even if there are records).
Is there a rule about using recordcount or alternative other than looping
through a recordet and counting manually?

Can any one tell me how can create a Master/Detail View using DataGridView
in VB.NET 2005
I could able to add/edit/delete the records

Dear readers,
I've found this algorithm
(http://weblogs.sqlteam.com/jeffs/archive/2004/11/10/2737.aspx)
to find the differences in two tables, whch I try to implement in Visual

I am having difficulties distributing our application to Vista workstations.
When it comes time for the VB6 application to initialize the Connection (open an MDB file) it fails with...
        "ActiveX component can't create object"
I am in the Administrators group and have UAC ...

Can you connect to a SQL Express server from VB 6.0?  If so, is the
connection string the same as you would use for connecting to a SQL 2000
server?  I have a program that i need to update and wondered if it would
require re-writing in .net or if I could substitute a new ...

Hi! Everybody,
How do you call a dataset member from your vb code?  Thanks for your help.

I wants to create a Mater/Detail Form in VB.NET 2005.
Can any one direct me to a good tutorial
I went through http://www.15seconds.com/issue/051117.htm but it is not
straight forward