MS SQL Server :: Support For SQL Express2005 My Host Provider Does Not Provide Support?

Current Recordset Does Not Support Updating. This May Be A Limitation Of The Provider

Mar 25, 2004

I keep getting this error when I try to update

Current Recordset does not support updating. This may be a limitation of the provider, or of the selected locktype.

It worked fine in Access, but when I switched to SQL Server it stopped working.

Can someone help! Please!

thx

Justin

View 11 Replies View Related

Current Provider Does Not Support Returning Multiple Recordsets From A Single Execution

Jun 14, 2007

Hi all -

I know this is prolly an old one but I would certainly appreciate some assistance =)

environment:

SERVER (IIS6, .NET2.0, SQL2005)

CLIENT (WIN2000,IE6,VBScript)

I have an aspx that is invoking ado on the clientside. I read somewhere that javascript does not support connecting to SQL clientside. I may be wrong. In any case I am using VBScript on the client.

I am using something like this to invoke the script

Code Snippet

<a href="#" onclick="doReport()">Click Here</< FONT>a>

doReport() looks something like this ...

Code Snippet

' ========================================================

sub doReport()

Dim stSQL, rs, oWord, oDoc, oRng

Dim stCurrentSection, stTemplatePath, dtNow, dtSOR, dtLastDataPoint

Dim iLastDataPoint

set oWord = CreateObject("Word.Application")

stTemplatePath = "http://crivm-ccdev/ccprocharts/supportfiles/CCWordReport.doc"

set oDoc = oWord.Documents.Open(stTemplatePath)

oWord.visible = true

stCurrentSection = "a"

loadDebug

'loadLive

openConnection()

' == THIS DB CALL GETS 2 RESULT SETS

'set rs = getrsCustomerInfoReport(mstUnits, left(mstCycles,3), mstAppName)

set rs = getReadOnlyRS("sCC_GetCustInfo_Report '" & mstUnits & "','" & left(mstCycles,3) & "','" & mstAppName & "'")

' == POPULATE VARS FROM 1st RESULT SET

dtLastDataPoint = rs(0)

iLastDataPoint = rs(1)

set rs = rs.NextRecordset ' <== THIS IS WHERE IS ERROR IS

msgbox rs(0)

end sub

here is my openconnection sub ... oConn is global

Code Snippet

<script type="text/vbscript" language="vbscript">

'== Cursor Location

CONST adUseClient = 3

CONST adUseServer = 2

' == Cursor Type

CONST adOpenStatic = 3

CONST adOpenForwardOnly = 0

CONST adOpenDynamic = 2

' == Lock Type

CONST adLockReadOnly = 1

CONST adLockOptimistic = 3

CONST adLockPessimistic = 2

' ========================================================

sub openConnection()

Dim stConn

set oConn = CreateObject("ADODB.Connection")

'stConn = "DRIVER={sql server};Server=crivm-ccdevsql2005;Database=catcheck;Integrated Security=SSPI"

stConn = "Provider=SQLOLEDB;Server=crivm-ccdevsql2005;Database=catcheck;Integrated Security=SSPI"

'msgbox oConn.state & vbcrlf & stConn1

oConn.open(stConn)

'msgbox oConn.state

ApplySecurity

end sub

' ============================================================

Sub ApplySecurity

'gbhasDBAccess is a global variable on both client and server sides.

'Server side is set in seccheck.asp, which should be at the top of every page

'Client side is set in ApplySecurity() of ConnectServer.asp

Dim appRole

appRole = "appWriters,(tsvc123)"

oConn.Execute "sp_setapprole '" & split(appRole,",")(0) & "','" & split(appRole,",")(1) & "'"

End Sub

</< FONT></script>

Before we moved to SQL2005 I always used this

Code Snippet

' ========================================================

Function getReadOnlyMultRS(strSQL)

set rs = CreateObject("ADODB.Recordset")

rs.CursorLocation = adUseClient

rs.Open strSQL, oConn, adOpenForwardOnly, adLockReadOnly

'Disconnect the Recordset

Set rs.ActiveConnection = Nothing

'Return the Recordset

Set getReadOnlyMultRS = rs

End Function

and this always allowed me to use set rs = rs.nextresultset

but now that we switched to SQL2005 it does not seem to work. I have verified in sql studio that this sp does indeed return 2 resultsets

View 4 Replies View Related

ADO Error 3251: Current Provider Does Not Support Returning Multiple Recordsets From A Single Execution?

Jul 20, 2005

I posted this in the MS Access group, but no luck.------------------------------------------I've got another stored procedure in the same app that returns multiplerecordsets and the code works.But now I've written another SP and the code traps out with the 3251 message.The SP is writing two recordsets.When I run the SP in Query Analyzer, both recordsets appear.But when I step through the code, when the first RS should be there, it's"Closed" and nothing I've tried will make it open.Provider=SQLOLEDB.1 (which works on the other screen...)Seems like I've been here before, but I can't remember what the problem was.--PeteCresswell

View 7 Replies View Related

Please Provide Help On How To Get Connection Tab For A Selected Provider In Web Application

Oct 15, 2007

Hi Sir

In My web application i am using the ".UDL" file functionality.

<![endif]-->The ��Select Provider�� tab will be used to allow users to specify the OLE DB Provider to be used for the connection. now i am able to get all provides available in system. But i have a problem how to get the cossesponding connection tab at runtime.

please save, i am in crusial stage.

Thanks In Advance.

etlu me srinu

View 3 Replies View Related

CE Support From ASP.Net 2.0

Dec 29, 2006

MS states that CE does not work with ASP.Net applications 'by default'. What is needed to change this default?

Bascially, my desktop app. is configured from a browser app. (ASP.Net 2.0) and I want to use CE as the datastore for the application.

Thanks.

View 12 Replies View Related

RAM Support

Jul 24, 2007

My documentation tells me that SQL Server Express only supports 1 gigabyte of RAM.
My computer can take 2 gigs, but I presently only have half a gig.

If I install 2 gigs on my machine, will that cause SQL Server Express to malfunction?

Or does it just mean that the extra gig will not be utilized?

Any advice would be much appreciated.