BLOB's and VB6 ADO

I have spent the past few days trying everything I could find on google. I am having problems writing blobs using VB6 and an ODBC connection. When i try to use a serverside cursor it says recordset does not support bookmarks. On the Informix website it says you cannot use server side cursors for TEXT and BYTE column types, which is the reason. It says to use a client side cursor. However, I write to it using the AppendChunk and it does not work. I use the exact same code with Oracle and a BLOB column type and it works perfectly fine so I know my VB6 code is correct as far as writing in chunks. Anyone know a solution for writing to BYTE columns from VB6?

Here is my code that is creating the recordset in case anyone is wondering:

Set rsFetch = New ADODB.Recordset
rsFetch.CursorLocation = adUseServer
rsFetch.Open sql, oleConn, adOpenKeyset, adLockOptimistic

SQl2000 / VB6 ADO, cryptacquirecontext error

Having a problem where i'm happily running my VB6 application against a sql2000 database.My VB6 application will do a certain number iterations (reading from a recordset, and then inserting records into a table), and then itwill fall over with the following error message.Run Time Error ='2147467259 ...

Large blob problem with ADO.NET and Fix1

I get a stack overflow with large blobs using ADO.NET and fix1To Reproduce:I created a table something like this:CREATE TABLE blobs { id INT PRIMARY KEY, afield int, ablob BLOB(100000) )";I added a couple of rows (id = 1, id = 2) contianing an 80000 byte blob with noproblems.I execute this query:"SE ...

SQL syntax error in MySQL when VB6 ADO try to update

The connection is successful in accessing table in Mysql using the MyODBC 3.51 Driver but only in query mode can anybody help me get rid out the SQL syntax error when ADO data control try to update record. Im using the Mysql 3.23.53a in redhat7 for my server and VB6 for my frontend. ...

VB6, ADO and OS/400 V5R2

My company recently upgraded to OS/400 V5R2 from V5R1. We have anapplication created in-house using VB6 that worked well before theupgrade, but has been giving problems ever since. The program uses ADOto read several database tables from the AS400. When some tables areopened we have access to all th ...

Finding a Record in VB6 ADO

I hit a stumbling block.I am working on a ancestral research type database and I want to link different records together. Here is my scenario so far:datPrimaryRS is an adoc that is pointing to the Person table.datNameSourceRS is also pointing to the Person Table. This is used to populate the list in ...

Problem connecting VB6 ADO with MySQL5 db

I have installed mySQL5, MyODBC Conn 5 in Local and Remote server, but I failed to conncet my VB6 project ADO with MySQL5 bd via ODBC. Any sugestions? a.lukito,md ...

ODBC VB6+ADO+MYSQL and images

I'm working on a project that will have a vb6 side and the other side will be a web side that has a bit of php on it. My major problem is how to deal with images. On the vb side, i'm working with ADO...how do i insert,delete update images using VB ADO on a mysql database and at the same time, be abl ...

VB6/ADO/ODBC Can't save large WMF image in table (ERROR: Lost connection to MySQL server during query)

I am writing an application in VB6 where a part of it is save image files into a MySQL table. This works for 99.9% of the time. It encounters a problem when i try to save a large WMF (13MB) file. Other file types of this size or greater work fine... The error I get is: "[MySQL][ODBC 3.51 Driver ...

ODBC vb6 ADO connection errors. Any way to debug?

I'm getting a "Data source name not found and default driver not specified" error when I run this code below in a VB6 (it's actually VBA for Visio, but it uses VB6). I've downloaded all the drivers and MySQL versions within the last week, so I should have the the latest versions of everyth ...

VB6/ADO/ODBC catastrophic failure

On most of our machines I get "catastrophic failure" when connecting to a MySQL 4.1.8-nt server via TCP/IP. That is, most machines except my development machine and another developer's machine. I can use: cnn.ConnectionString = "Driver={MySQL ODBC 3.51 Driver};" _ "OPTION=3; ...

Error message due to empty row, (VB6-ADO-ACCESS)

Question TWOI have on and off been using Basic, now VB since “the stone age” long before Microsoft and Windows. However it is only now I enter the issue of using VB6 and a database. I use VB6-ADO-ACCESS plus using DataGrid as the main view to see the database. I use 5 tables with some info in on ...

VB6/ADO problem with Update Criteria

In my application I'm using ADO recordsets with a client-side cursor. I have set rs.Properties("Update Criteria")=adCriteriaKey, but still I'm getting error messages from the datagrid that the row cannot be found anymore after updating, which contradicts the use of the primary key only for ...

VB6, ADO and OS/400 V5R2

My company recently upgraded to OS/400 V5R2 from V5R1. We have an application created in-house using VB6 that worked well before the upgrade, but has been giving problems ever since. The program uses ADO to read several database tables from the AS400. When some tables are opened we have access to al ...

VB6-ADO Connection

A VB6 app appears "hang",then I minimize and then restore the app from the windows' task bar, that gets it going again. What causes the "hang"?Please help. Your comments are appreciated. ...

VB6 ADO SQL2005 sdDecimal

I am using ADO in VB6 to call a stored procedure in SQL2005. The stored procedure is looking for data as "decimal(6,5)". My data is a double in VB6. In VB6, I tried setting up the call as follows (This is right out of an ADO book):SQLCommand.Parameters.Append .CreateParameter("@Offset ...

Autonumber in sql and VB6 ADO

I am using VB6 with a ADO rs object frontend and SQL2000 backend. I have been creating a database program to open ticket orders with a unique ID number. In SQL2000 I have created a field called TicketID. I have set it with both the identity seed and the uniqueidentifier tags, with no luck. When I 'a ...

Oracle Insert and retrive image in BLOB field using ADO 2.6

We are trying to insert and retrive image file in BLOB field in database. facing some problem....if anyone can help.- ...

VB6 ADO ListView

Please help me in VB6 ADO ListView Database Connection ...

Oracle NLS + vb6 + ADO

I've created a table named UniTest with a NUMBER column named pkey and an NVARCHAR2(1) column named nvc1. For all values of pkey from 1 to xCFFF, I INSERT rows with nvc1 set to ChrW(pkey) using N'' on the nvc1 column's value. When I retrieve the rows, for all values of pkey above 127 the nvc1 column ...

Vb6 ADO method

Please help me in the following matter:-vb6 Ado database connectionvb6 Ado recordset connectionshow recordadd record in databasedelete record from databaseedit record from databasefind record from databaseand all sort of ado connectionand add record in datagrid Please give me solution. ...

Retrieving Blob Data using ADO

I have a Table which has a blob DataType for a particular field.I am using ADO to retrieve the Data but i get a exception thrown while callign the open function of the ADO with the select query.Can some one help me out??{strAuditQuery = "select AUDIT_ID,Message_sender,Message_Receiver,Message_D ...

VB6 - ADO - addnew,update - error - record cannot be deleted or changed -because of

here's my problem.i'm working with Visual basic 6 and microsoft Access 2003 database.I use ADO objects for connection and manipulation of the database.In my database there are 3 tables .2 tables(Customers and Events) are the parent tables and 1 table(Orders) is a child table.The order table has one ...

Oracle Write to a BLOB field with ADO and C++

Hi, i have to write an image into blob a field, i try to use ADO method AppendChunk but it raise a stack overflow exception.. Someone can help me?THANKSthe table: T_FILE_ESTERNI(GUID VARCHAR(32), VERSIONE VARCHAR(15), DATA VARCHAR(25), NOTE VARCHAR(512), FILE_DATA BLOB)Here my code:ret = file.Open(s ...

Retrieving Blob Data using ADO

I have a Table which has a blob DataType for a particular field.I am using ADO to retrieve the Data but i get a exception thrown while callign the open function of the ADO with the select query.Can some one help me out??{strAuditQuery = "select AUDIT_ID,Message_sender,Message_Receiver,Message_D ...

VB6 ADO and Data envirnment

Can you use both an ADO data controll and a Data envirnment in the same project? Also I keep getting an error code 91 when I try to run an SQL to find a record. I can't figure out what reference is missing from the Reference list. ...

Puting Data into a DataBase (VB6, ADO, ACCESS, DataGrid)

Old in basic/vb but new to this part of database with VB6. Have created an ACESS Database with several tabels. Have a VB6 project with several forms. ACESS, ADO, Jet 4.0 and DataGrid. If I make a textbox and connect it to the database and say DataBase.Recordset.AddNewthen I can add text into that te ...

VB6 ADO AddNew Mehod Problem

I am created a ADO control on my form which retrieves records from two tables that are JOIN through the common field .I want to insert the values only in one table using AddNew Method and then using update method.I have used addnew method and receives values from the user in text boxes on the form a ...

VB6 ADO problem

I have a form with a bound grid in this case infragistics) .I need to update another table with the contents of this table - row and some other data. I have written the code to transfer the data (ado cmd)but can't transfer memo and ole object data types in the Insert Into statemement (append query). ...

VB6 ADO 2.6 miscalculating sums in an Access Union Query

I’m using ADO 2.6 in VB6 to read in data from a Union query (qryJoinBalanceData) in Access 2000. The Union query contains 3 sub-queries, each of which joins several tables, but they all generate exactly the same fields containing the same type of data.I’m using qryJoinBalanceData as the source for ...