VB Forum / Database Access / October 2005

hello mr or mrs and miss
now, i am learning vb with sqlserver
now i have a problem with
read binary from from sql server

I have an Access97 application I would like to be able to
distribute, to people who may not have Access installed
Through work (site license at a University) I was able to
download a [Licensed and Legal !!!] copy of VB 6 Pro, but

Im hoping someone might see an error that I cant figure out.  Im trying
to write to a database with the following structure:
RecordID    (AutoNumber) - primary key
CourseID     Long Integer

I have to put the contents of a cell from a clicked data grid row into the  
Caption of the Data Grid.  The data grid is populated from an access DB (if
that makes any difference!)  I can get the index of the selected row, but
referencing the cells appears a mystery!

i have got a client server application made in VB6 using an oracle91
databse .It was working fine earlier but now we have deployed server
application in another computer.Doing which it throws the error.
"DATA SOURCE NOT FOUND NO DEFAULT DRIVER SPECIFIED"

I am using VB6 to create Access databases, but with Access 2000 it wants to
convert the format.  When I do that it seems to work okay.  Is there any
known problems doing this?  Also how can I create an Access 2000 mdb file
from VB6?

I have a VB6 Application wich connect to an Access 97 database. We have a
function to connect to the database like this
Dim wrkDefault As Workspace
Set wrkDefault = DBEngine.Workspaces(0)

I'm trying to update a SQL 7 table with Visual Basic.Net and just getting
question marks in the column values... with no errors.  I am able to update
this same table using a standard VB 6 app.  The SQL syntax is the same.  The
update statement looks like:

I have tried to compact and repair Access 2000 database from VB 6.0. I am
using Data Reporting from Data Environment for my reports. As soon as I use
data environment to print the report which is consistent from Parent and
Child command object I am getting a message Permission ...

I am looking to do the following:
I have a textbox a user enters a SQL query in and runs it.
The results are displayed in a datagrid (using a dataset).
How do I do this?

Hi, I have recently reloaded VB6 PRO SP6 onto a replacement computer
(win88se) and I am continuing development of an application. I have tried to
load the ADODC control through the project-components area but get the
message "c:\windows\system\msadodc.ocx could not be loaded. I ...

I don't know why but since we changed the OS to win2003 this format of the
dates sends the first digit of the hour in my vb6 application textbox when my
date is long as 8 (1\1\2005).It's ok when I have 10\10\2003. My database is
Sybase.

References to calendar
Hi all I am working on a for and I have a textbox with the date and I want
when the click on the textbox I load a form with the calendar giving the
option to chose a date of any month and fill the textbox on the other form.

Can someone please help.
I am new to VB6 and i am trying just a simple insert in to an access
database using ADO.
the connection to the database onto but when i tries to execute the insert

Reply to goobil@hotmail.com
Hi all,
Can someone please help.
I am new to VB6 and i am trying just a simple insert in to an access