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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-03-08 : 15:03:35
|
Janette writes "I have read that using the ODBC call protocol eliminates the parameter parsing that is done by TSQL which leads me to believe that the problems we are having with calling stored procedures with parameters that have embedded single quotes would go away.
So we tried the following as a test:
Set objADOCmd = CreateObject("ADODB.Command")
With objADOCmd
.ActiveConnection = conn
.CommandType = adCmdText
.CommandText = "{call sp_test2('dog', 'ol' yeller')}"
.Execute
End With
I got a syntax error using this in VB that disapeared when I removed the embedded single quote. So what's up, why won't this work? I'd hate to go back and do a replace statement everwhere where we are collecting parameters in our ASP pages." |
|
|
|
|
|
Using ODBC Call rather than TSQL Execute