Working with Store Procedures in ADO [0 replies] microsoft.public.data.ado, Friday, June 07, 2002
HELP ME!!
I need to know everything about Stored Procedures in ADO.
ADO Performance [0 replies] microsoft.public.data.ado, Friday, June 07, 2002
When testing ADO performance and usability I designed a
VB6 application that uses the Command object and the
prepare property (a stored proceedure). In one second I
can insert 450 records...
ADO Recordset Binds with Binaries [0 replies] microsoft.public.data.ado, Friday, June 07, 2002
I get a similar error trying toa recordset using VB
6 Pro/ SQL 7
>-----Original Message-----
>I created a class to allow me to do ADO Recordset Binds.
>
>For integers, chars, ...
Error Invalid Scale Value [0 replies] microsoft.public.data.ado, Friday, June 07, 2002
Trying toa recordset results in the following error.
- [Microsoft][ODBC SQL Server Driver]Invalid
scale value
I'm using the exact connection cls on another PC except
...
ASSERT m_dwRef [0 replies] microsoft.public.data.ado, Friday, June 07, 2002
Visual C++ 6.0, Windows XP
I have a dialog with Activex controls: a text form, a grid box and ADO data
control (OLEDB).
The name from the active grid row should appear in the text box.
...
How do I reference an ADO Data Control connection? [1 reply] microsoft.public.data.ado, Friday, June 07, 2002
I need to execute a SQL Server stored procedure against
an ADO data control connection to give it permission to
access certain tables in the database. I can't figure
out how to access th...
Reading tables containing foreign character sets [0 replies] microsoft.public.data.ado, Friday, June 07, 2002
Hi
I am trying to read a table using ADO. I know that the char data in the
table is in the Greek character set; my machine is European.
When Ithe recordset and read a field as a st...
Using ADO Recordsets and ODBC fails to insert records with U... [0 replies] microsoft.public.data.ado, Friday, June 07, 2002
This is a multi-part message in MIME format.
------=_NextPart_000_D51B_01C20E08.D9FE63D0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
First, here's t...
what is correct connection string for Access97? [3 replies] microsoft.public.data.ado, Friday, June 07, 2002
Hello,
I have been using the following ADO connection string
(below)for connecting to an Access97 mdb which works fine
on my workstation -NT4 SP6 (which has Visual Studio loaded
and th...
MS SQL [2 replies] microsoft.public.data.ado, Friday, June 07, 2002
I am trying to get data from two tables, according to a
range of dates. I came up with this query:
select DISTINCT A.SettleDate,
(select Amount from EXPO where Xcode = '0800' and
Set...
Need your advice. [1 reply] microsoft.public.data.ado, Friday, June 07, 2002
What is the correct method and sequence of events to have
ado execute a parameterized sp, check the return_value of
the sp and get the output parameters from the sp in a VB
application.
...
Run-time Error!Cannotany more tables [5 replies] microsoft.public.data.ado, Friday, June 07, 2002
Hello,
After working fine for tables 1-189, I get this error out
of nowhere. I have closed the recordset and red it
such that there are no recordsets See partial code
belo...
ADO very slow on Win98? [2 replies] microsoft.public.data.ado, Friday, June 07, 2002
Hello!
I have an VC++ application that uses ADO and on my computer, which is
WinNT 4, accessing the database takes about 1-2 seconds, but on the
clients computer, which is Win98, the same ...
Key files for programs!!! [0 replies] microsoft.public.data.ado, Friday, June 07, 2002
We're make key files and serial numbers for some programs.
For more information:
dimon_sk
Problems with temporary tables [1 reply] microsoft.public.data.ado, Friday, June 07, 2002
Hello,
We have a transaction that can span up to 1million
records, and because of that, the machine with the SQL
server can't handle it (takes too much memory).
So we tried to put che...
who can I get the information about wrap classes [0 replies] microsoft.public.data.ado, Friday, June 07, 2002
Hi
WhenI use #import "C:\Program Files\Common
Files\System\ADO\MSADO15.DLL" to include the
classes into my project ,but I don't know
where I get the information of the classes.
Can you...
ADO find trouble [0 replies] microsoft.public.data.ado, Friday, June 07, 2002
Hi,
I'm using the ADO find command in Visual Basic as follows:
rst.find "Title = '" & <string> & "'"
(string enclosed by '-characters)
Problem: the string contains special charact...
Colomns from SP [1 reply] microsoft.public.data.ado, Thursday, June 06, 2002
I want to create a tool for myself, which would write SP code.
I'd like to know is there any way to know what of columns is SP generating,
using SELECT within itself, without actually runni...
Error 80004005 whenng ADO.Record [1 reply] microsoft.public.data.ado, Thursday, June 06, 2002
Hello,
I have exact the sanme problem, but vice versa on Win98 it
is running perfectly but not on Win200. I get the message:
maybe is the class installed incorrectly.
Did have solved ...
How do you append a field of type adChapter? [3 replies] microsoft.public.data.ado, Thursday, June 06, 2002
Hi,
I am trying to create a hierarchical recordset that I can
use to generate a Data Report with Group header and footer
sections. I've looked at the structure created by the
Data Env...
Access image dbase MS Photo Editor 3.0 format [0 replies] microsoft.public.data.ado, Thursday, June 06, 2002
I need to move a dbase of images which have been created
with MS PhotoEditor 3.0 and stored in an Access dbase.
The problem is that I see no way to convert these images
to .jpg/.bmp or a...
Cannot create ADO 2.6 objects on XP [2 replies] microsoft.public.data.ado, Thursday, June 06, 2002
This is a multi-part message in MIME format.
------=_NextPart_000_A90F_01C20D6E.FDAA3830
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
Hi,
I've got...
|