problem with data access?!?!?!

  • Thread starter Thread starter merrittr
  • Start date Start date
M

merrittr

Hi Al I was getting an error:


Description: An unhandled exception occurred during the execution of
the current web request. Please review the stack trace for more
information about the error and where it originated in the code.

Exception Details: System.ArgumentException: Keyword not supported:
'provider'

with the line 21 which is just SqlDataSource and the connstring int
the web.config is:

<add name="BOConnectionString"
connectionString="Provider=SQLOLEDB;Data
Source=msqlserver.scs.sk.ca;Integrated Security=SSPI;Initial
Catalog=matbrdoff"/>
<add name="BOServerString" connectionString="msqlserver.here.ca"/>


any ideas what might be stopping me here ?


Sub btnTest_Click(Sender As Object, E As EventArgs)
Dim SqlDatasource1 As New SqlDataSource
Dim stnum As Long
Dim test, test2, cnt As Integer
Dim strBOConnection As String = ConfigurationManager.ConnectionStrings
("BOConnectionString").ConnectionString
lblMessage.Text = strBOConnection
stop
SqlDataSource1.ConnectionString = strBOConnection

SqlDataSource1.UpdateCommand = "update divassessment set term =
null,aterm= 0,final=null,afinal = 0 where subjectcode = 'RR' and grade
= '2' and year = '2009'"
SqlDataSource1.Update() <--- System.ArgumentException: Keyword not
supported: 'provider'.
 
Back
Top