[vwnc] SQL Server and BLOB's

_______________________________________________
vwnc mailing list
[hidden email]
http://lists.cs.uiuc.edu/mailman/listinfo/vwnc

There is a known problem with SQL 2005 Express, if you’re using the new “SQL Native Client” interface instead of “SQL Server” for your OD BC data source. Even SQL Native Client works fine, unless your lob column is declared as varchar(max) or varbinary(max). These new column types confuse the EXDI code by insisting that the column size is 0 bytes. There are at least two workarounds. The first one is to redefine the column type as TEXT or IMAGE (the old types). The second known option is use a different data source (declared under Control Panel/Admin/ODBC). Change the “type” to “SQL Server”, and this invokes a different DLL which treats varchar(max) as if it were TEXT.

 

The only other AR I can think of (54544) involves using threaded interface, and passing a very long literal String or ByteArray. Somehow the literal isn’t handled properly within the call. The workaround for this issue is to either use non-threaded, or ‘long … literal’ gcCopyToHeap instead.

 

If these don’t match your situation, we’ll need some more details.

 

- Dave W

 

---

From: [hidden email] [mailto:[hidden email]] On Behalf Of Maarten MOSTERT
Sent: Thursday, August 07, 2008 3:14 PM
To: VWNC; [hidden email]
Subject: [vwnc] SQL Server and BLOB's

 

Hi,

 

When trying to insert blobs into SQL-Server Express 2005 I encounter problems.

 

I get the Error: [Microsoft][ODBC SQL Server Driver]Fonctionnalité optionnelle non implémentée

 

Which in English means somemehting like non implemented optional functionality.

 

I didn't have this problem before ( VW7.5 and a previous version of SQL-server 2005 Express) and the same code works fine with Acces.

 

Does anyone has an idea where to look or better experience ?

 

Regards,

 

@+Maarten,

 

 

 

 

 

_______________________________________________
vwnc mailing list
[hidden email]
http://lists.cs.uiuc.edu/mailman/listinfo/vwnc

Thank you very much !

@+Maarten,


Wallen, David a écrit :

There is a known problem with SQL 2005 Express, if you’re using the new “SQL Native Client” interface instead of “SQL Server” for your OD BC data source. Even SQL Native Client works fine, unless your lob column is declared as varchar(max) or varbinary(max). These new column types confuse the EXDI code by insisting that the column size is 0 bytes. There are at least two workarounds. The first one is to redefine the column type as TEXT or IMAGE (the old types). The second known option is use a different data source (declared under Control Panel/Admin/ODBC). Change the “type” to “SQL Server”, and this invokes a different DLL which treats varchar(max) as if it were TEXT.

 

The only other AR I can think of (54544) involves using threaded interface, and passing a very long literal String or ByteArray. Somehow the literal isn’t handled properly within the call. The workaround for this issue is to either use non-threaded, or ‘long … literal’ gcCopyToHeap instead.

 

If these don’t match your situation, we’ll need some more details.

 

- Dave W

 

From: [hidden email] [[hidden email]] On Behalf Of Maarten MOSTERT
Sent: Thursday, August 07, 2008 3:14 PM
To: VWNC; [hidden email]
Subject: [vwnc] SQL Server and BLOB's

 

Hi,

 

When trying to insert blobs into SQL-Server Express 2005 I encounter problems.

 

I get the Error: [Microsoft][ODBC SQL Server Driver]Fonctionnalité optionnelle non implémentée

 

Which in English means somemehting like non implemented optional functionality.

 

I didn't have this problem before ( VW7.5 and a previous version of SQL-server 2005 Express) and the same code works fine with Acces.

 

Does anyone has an idea where to look or better experience ?

 

Regards,

 

@+Maarten,

 

 

 

 

 

_______________________________________________
vwnc mailing list
[hidden email]
http://lists.cs.uiuc.edu/mailman/listinfo/vwnc

Hi Carlos,

Well rememeber that Blobs are not treated the same way among different
platforms.

Some platforms only allow for updates and others only for inserts. That
is why I use an intermediate objects which keeps track of the BloB in a
platform independant way.  For as far I know only PostgreSQL manages big
blobs directly through Glorp. I do the other platforms with direct SQL
comands as descriped in the manual, see also the example below.

Regards,

@Maarten,

 

Carlos Crosetti a écrit :
> Please send me the table description where you are insrting and the
> glorp descriptor for that table.
> --
> Carlos Crosetti


_______________________________________________
vwnc mailing list
[hidden email]
http://lists.cs.uiuc.edu/mailman/listinfo/vwnc