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:

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 ...

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. ...

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 ...

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 ...

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 ...

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 ...

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 ...

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; ...

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 ...

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 ...

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 ...

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 ...

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 ...

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 ...

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. ...

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 ...

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 ...

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 ...

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. ...

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 ...

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 ...

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). ...

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 ...