VB Forum / Database Access / September 2006

Hi y'all
Trying to save photo data (jpg's):-
---------------------------------------------
Dim rs As ADODB.Recordset

I am working with a VB6 application that uses data environments. All of a
sudden the application is starting to randomly crash upon the closing of the
form. The error is "The object invoked has disconnected from its clients."
Searching via Google has not really provided any real ...

I am trying to put a pdf into a blob field of a sql server. But when i
do this i get only the pathname and filename in this field instead of
the real pdf image. How can i make clear to VB6 that i want the actual
file into this blob field?

I've been running a web site powered by mySQL 4.0 on a Windows 2003
Server, which is working rather well.
The largest query took about 1 second, which was reasonable, since all
the other results after this were "paged" and would only take 0.1

How to connect VB6.0 forms with Foxpro database through ADO coding

I'm trying to teach myself more complicated SELECT statements but I'm stuck
on quite a simple task.  If I have a table containing some records, (Delflag
is a flag to indicate if a line is live or deleted):
Doc  Line  Delflag

I need to use VB code so I can build a query according to user's choice
and base on this new query design a report in MS access. My question is
I know that I can use VB code to create table, but is it possible to
create query also? I mean actually create and store in access?

Is there a way (or function) to read the content of a .MEM file created with
FoxPro 2.6?

I am getting a very strange 'Concurrency Exception' updating records with VS
2005 (language VB) on a SQL 2005 Database Table. To handle data I use strong
typed Dataset with TableAdapters and the interaction with the SQL Database
are handled by the stored procedures automatically ...

Can a database be put outside the rootdirectory (i.e. httpdocs) and
then used by establishing a connection using ado?

I also posted this problem in visual.misc newsgroup, but till now I haven't
recieved any answers,
so I am posting it to this group and asking for any kind of help.
I am working in VS2005 (VB) environment and I have following problem:

I have found that I can access a data souce on the Internet when
creating a connection string using ADO. For example,
Provider=Microsoft.Jet.OLEDB.4.0;Data source=ftp://someserver/somefile
Now what if the FTP server requires a non-anonymous login? I can't seem

My ultimate requirement is transfering data from Excel to SQL Server. I
am using OLEDB to do this. I have created two connection objects of
which one connects to the Excel file and the other which connects to a
table in SQL Server. I have abuilt a recordset (recExcel) and fetched

Is there a way for me to connect to and open an excel workbook with ADO
that will not force the file to read only when I open it in Excel.  I
need to be able to have my code using the file, while I have a
read/write copy of the file open in Excel.

I am trying to transfer data from Excel to a table in SQL Server. Hence
created two connection objects. They are:
  Set objConnTest = New ADODB.Connection
  With objConnSQL