Re: [Firebird-odbc-devel] ASP Blob

[Daniel D. <da...@cv...>]

I'm usign with ADO objects, so:

> Dim sisConnection, sisRecordset, SQL
> Set sisConnection = Server.CreateObject("ADODB.Connection")
> Set sisRecordset  = Server.CreateObject("ADODB.Recordset")
>
> sisConnection.Open "DRIVER=Firebird/InterBase(r) 
> driver;UID=SYSDBA;PWD=masterkey;DBNAME=127.0.0.1:" & 
> Server.Mappath("data.gdb")
>
> SQL = "SELECT FIELD1, FIELD2 FROM TESTTABLE"
> sisRecordset.Open SQL, sisConnection

I have found a way to insert blob on ADO table/query, but it doesnt work.
Its raise an error in "AddNew" procedure:
"Microsoft OLE DB Provider for ODBC Drivers (0x80040E21). ODBC driver does 
not support the requested properties."

See below:

> Set sisConnection = Server.CreateObject("ADODB.Connection")
> Set sisRecordset  = Server.CreateObject("ADODB.Recordset")
>
> sisConnection.Open "DRIVER=Firebird/InterBase(r) 
> driver;UID=SYSDBA;PWD=masterkey;DBNAME=127.0.0.1:" & 
> Server.Mappath("data.gdb")
>
> sisRecordset.Open "TESTTABLE", sisConnection, 2, 2
>
> sisRecordset.AddNew               'odbc error
> sisRecordset("FIELD1") = 11
> sisRecordset("FIELD2").AppendChunk BlobData
> sisRecordset.Update
> sisRecordset.Close

How may i procced?

thanks...
Daniel Dummer


"bill_lam" <bil...@my...> escreveu na mensagem 
news:44D...@my......
> Daniel Dummer wrote:
>> Hi...
>>
>> how can i assing data to insert a blob data working in ASP?
>>
>> normally i use:
>>
>> SQL = "INSERT INTO SOMETABLE(FIELD1, FIELD2) VALUES(1, 'test')"
>> Connection.Execute(SQL)
>>
>> how do i assign a binary blob data?
>
> Usually its depend on your programming language rather than back-end 
> database or
> middleware. ASP is not a programming language, so that you may consult
> documentation of your programming language instead.
>
> HTH
>
> -- 
> regards,
> bill
>
> -------------------------------------------------------------------------
> Using Tomcat but need to do more? Need to support web services, security?
> Get stuff done quickly with pre-integrated technology to make your job 
> easier
> Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
> _______________________________________________
> Firebird-odbc-devel mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel
>