Windows Vista Forums
Vista Forums Home Join Vista Forums Windows 7 Forum Vista Tutorials Tags
Welcome to Windows Vista Forums. Our forum is dedicated to helping you find solutions with any problems, errors or issues you are experiencing with Windows Vista. The Vista forum also covers news and updates and has an extensive Windows Vista tutorial section that covers a wide range of tips and tricks.

Go Back   Vista Forums > Misc Newsgroups > .NET General

Vista Tutorial - problem with data access?!?!?!

Reply
 
Old 06-18-2009   #1 (permalink)
merrittr
Guest


 
 

problem with data access?!?!?!

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'.


My System SpecsSystem Spec
Reply

Thread Tools


Similar Threads
Thread Forum
Opinion on XML data access .NET General
USB Flash Disk access problem; Vital Data at Stake =[ Vista hardware & devices
How to access encryptise data Vista General
Vista can't access USB data Vista General
Data Access Vista installation & setup


Vista Forums is an independent web site and has not been authorized,
sponsored, or otherwise approved by Microsoft Corporation.
"Windows Vista", the Start Orb, and related materials are trademarks of Microsoft Corp.
© Designer Media Ltd

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46