[ezRETS-logs] RE: [ezRETS-users] ezRETS and Microsoft DTS onSQL Server 2000

[Spencer Tabbert]

Keith,
Thanks for the feedback.  This is interesting.  Unfortunately it doesn't
appear that I can modify the way that DTS is asking for the data stream.
Nor do I know why DTS behaves this way.  Instead I have created a suitable
VBScript inside of the DTS package that works just fine and allow me to not
have to stage the image data in a database table which isn't ideal anyways. 


Spencer Tabbert
Voice: 262-442-3721
Fax: 262-364-2117 
stabbert at purestrategy.net
 
Pure Strategy
W276 N2744 Trillium Ln
Pewaukee, WI 53072
 
 

-----Original Message-----
From: ezrets-users-bounces at crt.realtors.org
[mailto:ezrets-users-bounces at crt.realtors.org] On Behalf Of Keith T. Garner
Sent: Monday, March 19, 2007 12:20 PM
To: Support and talk for users of the ezRETS ODBC Driver
Subject: Re: [ezRETS-logs] RE: [ezRETS-users] ezRETS and Microsoft DTS onSQL
Server 2000

Spencer Tabbert wrote:
> Here are both the HTTP log as well as the Debug Log.  If you want I 
> can also send you the DTS package from SQL Server.  When I ran it this 
> time I had the settings as Ignore Metadata Type Off with Treat DECIMAL 
> as VARCHAR on and the same exact behavior was experienced.

Spencer,

You found a good bug.  What's interesting is that it looks like SQLServer
DTS is asking for the BLOB as a character stream (or CLOB, I guess.)  You
ended up triggering a small error in how I handle character data.

So, while there is a bug, there is also the question of why you're asking
for a binary stream as characters.  I don't know enough about DTS to steer
you either direction, but I'm afraid of the null termination in strings
breaking any binary image you have.  Any ideas if you're doing something
either way on this?  (I.e. you could be fixed faster by switching to asking
for binary, instead of character data.)

I want to put another libRETS out this week, and after I do that, I'll try
to get an ezRETS out with that fix.

Keith

--
  Keith T. Garner - Managing Director - Center for REALTORR Technology
   kgarner at realtors.org - 312-329-3294 - http://blog.realtors.org/crt

_______________________________________________
ezRETS-users mailing list
ezRETS-users at crt.realtors.org
http://mail.crt.realtors.org/mailman/listinfo/ezrets-users