HighTechTalks DotNet Forums  

Update SqlDataSource with ODBC.NET

Dotnet Framework (ODBC.net) microsoft.public.dotnet.framework.odbcnet


Discuss Update SqlDataSource with ODBC.NET in the Dotnet Framework (ODBC.net) forum.



Reply
 
Thread Tools Search this Thread Display Modes
  #1  
Old   
ist
 
Posts: n/a

Default Update SqlDataSource with ODBC.NET - 11-08-2006 , 08:17 AM






Hi,
I have an SqlDataSource on my ASP.NET page, UpdateCommand of which is
set to "Update table set @f1=f1, @f2=f2 where @id=id". When bind to a
grid and properly populated, it automatically gets to edit mode and
updates data when using SqlClient as provider. However, when provider
is changed to Odbc, I get error: "Must declare scalar variable @f1"
I guess this is an ODBC specific problem, because NOTHING else is
changed. What is the problem with it?


Reply With Quote
Reply




Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.4
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.