Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
filf
Yak Posting Veteran
67 Posts |
 Posted - 2001-07-27 : 12:21:25
|
| Hello,I am having a problem related to the use of the following ole automation stored procedure:sp_OASetProperty I am trying to set a variable of dType varchar 2000. When I call this sp, to set the property to the value of the variable, the SQL Server datatype is converted into a Visual Basic datatype, converting my varchar 2000 to string 255 causing unwanted truncation.Does anyone have any idea how I can actually get around this problem? It would be great to get a quick fix for this.Thanks in advance.Edited by - filf on 07/30/2001 04:33:21 |
|
|
|
|
|
Truncation Problem using OLE automation SP