Data Read-Consistency During Update

Hi folks,

I have 3 tables of related data in SQL 2000/2005 that receive periodic adds/updates every 30 seconds.

I have enabled transactions on all updates, is anything else needed to ensure data consistency during reads in a high # of fetches per second situation?

Thanks,

john

Edit:

Clarification -- I just need the data to be correctly displayed to all users.

Hi,

I am not sure what do you mean by consistency. You may need to change transaction isolation level. Setting "serializable" level ensures complete consistency, but may impact performance of your server.

-yuriy
http://weblogs.asp.net/ysolodkyy

|||

Thanks, that's what I was describing.

Data Processing Extension "Edit" button

I have developed a data processing extension and want to enable the use of
the "edit" button on the data source wizard
This only seems to be enabled for the built in data providers. Do I need to
implement another interface?
Cheers
SimonHi Simon,
From your descriptions, I understood that you would like to custom the Data
Source dynamically. Have I understood you? Correct me if I was wrong.
First of all, I am not very sure whether you need a middle layer,however,
here is an example using ADO.NET Datasets in Reporting Services passing the
filter data to the correct stored procedures. I think it might help
Using ADO.NET DataSets from SQL 2000 Reporting Services
http://weblogs.asp.net/gavinjoyce/archive/2004/01/29/64339.aspx
Secondly, have you tried DataSet object? The DataSet object is central to
supporting disconnected, distributed data scenarios with ADO.NET. The
DataSet is a memory-resident representation of data that provides a
consistent relational programming model regardless of the data source. See
Topic "Using an External Dataset with Reporting Services" in Reporting
Services BooksOnline.
If I misunderstood you, please feel free to let me know further what you
want and it will be highly appreciated if you could show me the scenario:)
Thank you for your patience and corperation. If you have any questions or
concerns, don't hesitate to let me know. We are here to be of assistance!
Sincerely yours,
Michael Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
---
Get Secure! - http://www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!|||I think you have missed the point.
I have written a data processing extension implementing IDbConnection etc.
When I create a data source in report designer the box for the connection
string alows me to enter a connection string directly, however the edit
button on the right hand side is disabled. How can I enable this and have it
display the data link properties box as it does when using the sql server,
OLEDB, ODBC and Oracle data providers.
""Michael Cheng [MSFT]"" wrote:
> Hi Simon,
> From your descriptions, I understood that you would like to custom the Data
> Source dynamically. Have I understood you? Correct me if I was wrong.
> First of all, I am not very sure whether you need a middle layer,however,
> here is an example using ADO.NET Datasets in Reporting Services passing the
> filter data to the correct stored procedures. I think it might help
> Using ADO.NET DataSets from SQL 2000 Reporting Services
> http://weblogs.asp.net/gavinjoyce/archive/2004/01/29/64339.aspx
> Secondly, have you tried DataSet object? The DataSet object is central to
> supporting disconnected, distributed data scenarios with ADO.NET. The
> DataSet is a memory-resident representation of data that provides a
> consistent relational programming model regardless of the data source. See
> Topic "Using an External Dataset with Reporting Services" in Reporting
> Services BooksOnline.
> If I misunderstood you, please feel free to let me know further what you
> want and it will be highly appreciated if you could show me the scenario:)
> Thank you for your patience and corperation. If you have any questions or
> concerns, don't hesitate to let me know. We are here to be of assistance!
>
> Sincerely yours,
> Michael Cheng
> Online Partner Support Specialist
> Partner Support Group
> Microsoft Global Technical Support Center
> ---
> Get Secure! - http://www.microsoft.com/security
> This posting is provided "as is" with no warranties and confers no rights.
> Please reply to newsgroups only, many thanks!
>
>|||Hi Simon,
I have tested it on my side and it works fine. Please refer to the
following document to see whether it helps
Deploying a Data Processing Extension to Report Designer
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSPROG/htm/
rsp_prog_extend_dataproc_9cds.asp
Deploying FsiDataExtension
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsamples/ht
m/rss_sampleapps_v1_16g2.asp
Implementing a Data Processing Extension
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSPROG/htm/
rsp_prog_extend_dataproc_5c2q.asp
Thank you for your patience and corperation. If you have any questions or
concerns, don't hesitate to let me know. We are here to be of assistance!
Sincerely yours,
Michael Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
---
Get Secure! - http://www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!|||Can you tell me what you tested?
For the FSI extension the edit button should not bring up the data link
window because it is an extension for the file system and not an OLEDB
connection.
Do you understand what I am trying to do?
I have read all the online documentation and BOL and there is no mention of
the edit button on the datasource wizard.
Simon
""Michael Cheng [MSFT]"" wrote:
> Hi Simon,
> I have tested it on my side and it works fine. Please refer to the
> following document to see whether it helps
> Deploying a Data Processing Extension to Report Designer
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSPROG/htm/
> rsp_prog_extend_dataproc_9cds.asp
> Deploying FsiDataExtension
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsamples/ht
> m/rss_sampleapps_v1_16g2.asp
> Implementing a Data Processing Extension
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSPROG/htm/
> rsp_prog_extend_dataproc_5c2q.asp
> Thank you for your patience and corperation. If you have any questions or
> concerns, don't hesitate to let me know. We are here to be of assistance!
>
> Sincerely yours,
> Michael Cheng
> Online Partner Support Specialist
> Partner Support Group
> Microsoft Global Technical Support Center
> ---
> Get Secure! - http://www.microsoft.com/security
> This posting is provided "as is" with no warranties and confers no rights.
> Please reply to newsgroups only, many thanks!
>

Data migration from Access to SQL server 2005

Hi,

I am trying to migrate the data from the Access database to Microsoft SQL server on my machine using some scripts. I have enabled the OPENROWSET and OPENDATASOURCE support through the surface area configuration. The script that accesses the excel file works fine but when i run the script that trys to open the .mdb file it gives me following error.

OLE DB provider "MSDASQL" for linked server "(null)" returned message "[Microsoft][ODBC Microsoft Access Driver] Cannot open database '(unknown)'. It may not be a database that your application recognizes, or the file may be corrupt.".

Msg 7303, Level 16, State 1, Line 35

Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "(null)".

Any help would be greatly appreciated. Thanks.

-padu

Make sure that the startup account for sqlserver is not a service account (i.e. localsystem/service/etc.). Just use a domain acct.|||

Hi oj,

How do you check the startup account is not a service account? I am pretty new to SQL server.

Thanks.

-padu

|||You can run SQL Server Configuration Manager. It allows you to change service account there (if desired).