ADO Data type question

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Rafael Chemtob (rchemtobb_at_nospam.yahoo.com)
Date: 02/23/04 

Date: Mon, 23 Feb 2004 15:24:27 -0500

Hi,
sorry for the multi-posts on this question. I have a VB app which uses ADO
to communicate with the SQL database. I have a string variable that is huge
and I pass it to the stored proc. THe stored proc is accepting it as a
"text". When I pass it in VB as an ADO parameter, i was using AdChar,
AdVarChar, and now adLongVarChar. All don't work well.
When I call the stored proce with the adChar, it breaks trying to pass the
parameters.
When I call it using the adVarChar, there is a limitation of 8000 which I
must set or it fails. But 8000 is too small.
When I use adLongVarChar, it doesn't work and I don't get an error message.
Any ideas?
thanks

Relevant Pages

  • Re: adVarWChar slower than adVarChar
    ... We did this for both SQL Server and Oracle, ... ADO as well as thousands of dynamic queries etc. ... I have some trouble with importing UTF files into a database: ... the import program used "adVarChar" to pass the ...
    (microsoft.public.data.ado)
  • Re: MSSQL vs. SYBASE
    ... > the stored proc to get any results. ... ADO .Net did just fine, that is I got the result as soon as SQL Server ... cursor, but that is not possible in your case. ...
    (microsoft.public.sqlserver.programming)
  • Re: Very slow access using MDAC2.8
    ... If the performance problem is visible in QA then it likely isn't an ADO ... Would it be possible to locate the stored proc on the machines with the ... > getdate(); statements are just used to time the execution. ...
    (microsoft.public.data.ado)
  • Problem with bit field using MS Sql server and Turbo Delphi 2006
    ... Using ado to connect to this database, I am getting an error when executing a procedure. ... Error converting data type varchar to bit ... ThisValid: boolean; ... I noticed that the parameter list did not match the order as defined in the stored proc, so I cleared the list and re added them. ...
    (borland.public.delphi.database.ado)
  • Re: LongText not suppoeted as output parameter
    ... I tried to user nText, Text, VarChar but at ADO Parameter is I don't user ... adLongVarChar or adLongVarWChar then it trim text upto 4000 or 8000 ... If I use provider SQLNCLI10 then it display error message provider not ... I tried to use SQLNCLI as a provider & ADO 2.8 but same error is coming. ...
    (microsoft.public.sqlserver.programming)