Shared Data In Multiuser Environment
Aug 18, 2006Hello, I am wondering how to code asp.net to prevent multiuser from modifying a
share data (on sql server) at the same time.
ADVERTISEMENT
Locking Of Data In Multiuser Environment
Apr 22, 2008
Hello,
We are using SQL Server Express 2005 for our application.
I have to lock the data in multi user access.
If user1 access the particular row in employee table, it should lock for the User1.
If user2 tries to access it should prompt the message that the User1 has accessing the particular row. User2 should be able to data in the read only mode. Untill user1 close that row, it should not allow the user2 to make any changes.
Help me how I can achieve this.
SQL Express On Widows XP For Multiuser Environment ?
Dec 31, 2007Hello to all of you,
Can I install SQL Server Express on Widows XP to use it for multiuser environment ?
Is it possible to use SQL Server Express without installing it on Windows Server (2003 or higher) ?
Thanks.
Sharing Website(asp.net) Mdf Database On A Network In Multiuser Environment
Sep 19, 2007simple question:
I have create a web site in visual studio with form user authentication. Thats create a mdf database in this path:
c:inetpubwwwrootwebsiteapp_dataaspnetdb.mdf
thats use Sql server
i would like to access this database with c# form application on a network with multi-user.
if i change the drive letter of the path above to f: (mapped drive) or \serverc, i got this message
System.Data.SqlClient.SqlException: The file "h:InetpubwwwrootwebsiteApp_DataASPNETDB.MDF" is on a network path that is not supported for database files.
An attempt to attach an auto-named database for file h:InetpubwwwrootwebsiteApp_DataASPNETDB.MDF failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.
i read that sql server did not support database sharing with mapped drive or unc share.
So how can i share website database with c# application???
Note: of course if i develop the website and the application on the same machine its work. I want this application run on several work station accessing all the same mdf database with his web user member.
How To Use SQL Express In A Shared Hosting Environment
May 1, 2006
All--
Please help.
I have deployed my site to my shared host and I am getting the following RTE...
An attempt to attach an auto-named database for file... ..App_DataCommerceDB.mdf failed
...and I cannot find the issue.
Note that I have given Full-Permissions on root folder for the IUSR account and for the ASPNET account.
The full error message is below.
Anyway, do you have an suggestions?
My web hosting provider has advertised that they do support SQL Express 2005. What exactly do I need to ask them to do in order to get this working?
Please advise.
Thank you.
--Mark Kamoski
Server Error in '/mkamoski/S16' Application. --------------------------------------------------------------------------------
An attempt to attach an auto-named database for file c:hostingwebhost4lifemembermkamoskiS16App_DataCommerceDB.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share. 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.Data.SqlClient.SqlException: An attempt to attach an auto-named database for file c:hostingwebhost4lifemembermkamoskiS16App_DataCommerceDB.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.
Source Error:
Line 88: ''' <returns></returns>
Line 89: Public Shared Function GetCart() As ShoppingCart
Line 90: Dim rdr As IDataReader = ShoppingCartProvider.Instance.CartGetCurrentCart(GetUserName())
Line 91: Dim cart As ShoppingCart = New ShoppingCart()
Line 92: cart.Load(rdr)
Source File: c:hostingwebhost4lifemembermkamoskiS16App_CodeBLLShoppingCartManager.vb Line: 90
Shared SSIS Staging/Dev Environment
Jul 16, 2007We are in the process of setting up a shared staging/development enviroment in which multiple developers will deploy their packages for testing etc.
The plan is to allow the developers to remote in to execute their packages, but we are worried about the concurrency limit of 2 users per terminal services.
It is my understanding that you cannot execute packages remotely (ie you have to be on THAT box to kick it off. (FYI - we are not planning on using SQL Agent at this point - That will be with DBAs in UA)
Please let me know what options are available/best practices...
Thanks!
Encryption Choices / Best Practices For Hosted Environment (shared Server)
Aug 29, 2007I'm building a hosted website and I am using SQL 2005.
The DBA for the host has told me that i can not encrypt a symmetric key with a certificate, when using that symmetric key for encryption. As i read that this method provided optimum performance/ security for encrypting columns of data.
The DBA told me i can use a cert or a symmetric key for encryption.
I have searched for comparisons and found a blog entry by Laurentiu Cristofor comparing certs with asymmetric keys. Which leads me to believe that certs and asymm are very different than symmetric keys.
My question is which is the best choice in a hosted environment for column encryption, a cert or symmetric key.
Which is more secure? Does one offer a significant performance (dis)advantage?
TIA
Assistance In Connecting A SQL Server Client To SQL Server Sitting In A Shared Environment
Dec 5, 2006Hi,
I need to connect to a SQL server thats running in say abc.trident.com and also sits in a shared environment..
I have couple of questions
1) That SQL server is accessible from my network, yet when I swtich on my enterprise manager I am unable to view that in the list of running SQL servers in the populated list.
Is it because its sitting in a shared environment I am unable to view that?
2) What is the connection striing I should use to connect to the server..When I try to configure a SQL server registrations it normally asks for SQL Server name along with the user authentication
Should I mention fill the Server: field as
abc.trident.com
or
// abc.trident.com/abc.trident.com
to connect to the clustered server.
Can some one tell me the proper connection string if both aforementioned ones are incorrect?
Thanks in Advance
SQL 2012 :: SSRS Data Shared Data Source Connection Login
Jan 12, 2015Was wondering if there was a best practice minimum permissions for creating a SQL login to use when setting up a new shared Data source for SSRS report manager?
Something along the lines of them being a data read for the DB and permissions to update tempdb?
Would have thought it not advisable to have the login be able to update the main db...
Multiuser & Record Blocking
Jul 14, 2000How to block record which is accessed by one user ? I mean how to make this record unavailable to other users ? Please help !
View 1 Replies View RelatedHow Do I Make My Access Db Into A Multiuser On A Server??
Mar 20, 2006I been trying to split my database on a SQL Server but its almost impossible to split and make that multiuser. Other thing it is possible for a multiuser use the database in access without having the program on their computers just connecting to the server???
View 1 Replies View RelatedHow To Deploy Updated Database From Development Environment To Live Environment?
Nov 16, 2005I have finished a change request from our client. I need to update clients' database with the one in developments.Here is the changes i made to database:Added/Changed some tablesAdded/Changed some stored proceduresAdded data to some dictionary tableThe data in clients' current database MUST be kept. So how can I merge the changed information to clients' database?
View 3 Replies View RelatedShared Data Source
Dec 19, 2006I experimented a strange behavior using connections for data source inside packages in vss 2005.
Suppose we have a tab1 in a develpment source db and in a test source db:
tab1 dev db contains 100 records
tab 2 test db contains 200 records
I start developing a package using an 'ole db data source' task inside a data flow. When I change the data source from dev to test, strange thinks happens.
The 'ole db source task' retrieve only 197 records ... but if I open the connection inside the connection manager pane and only after i click on the 'test connection' button tI get 200 records.
The source db is a sql 2000 db server and I use ole db provider for sql server.
Cosimo
Accessing Shared Data Source In VS.net
Aug 10, 2007
How can i get the shared data sources i created in the report manager to be available in VS.net to be able to assign to a report. I want to be able to create the shared data source first in Report manager and then be able to assign it a report in VS.Net
Thanks.
Change Data Source For Shared Dimensions
Jun 21, 2005I have an archive of an Analysis Services database that was created on a server that is not accessible to me. I also have a copy of the source SQL Server database that it uses as a data source. I have restored both of these to my server. I have figured out how to change the data source to point to my server for the fact tables referenced, but I can't figure out how change the data source for the shared dimensions. I would like to be able to do work on this version of the database, but I get errors when I try to browse the dimension data because it can't connect to the original data source. Any ideas?
View 6 Replies View RelatedWhat Are The Intended Boundaries Of A Shared Data Source?
Dec 7, 2007I see that a .rds file was created as a result of me defining a shared data source. So are they meant to be shared across projects only within the same solution, across solutions perhaps with references, system wide etc?
View 1 Replies View RelatedStored Credentials On Shared Data Source
Jan 5, 2007I'm trying to use stored credentials to enable caching. I've created a special windows user account with minimum permissions for just this task, and once set up, it works great (almost).
I can update the shared data source using SQL Mgt Studio or directly via the Report Manager to use a set of -windows- stored credentials. But I don't seem to be able to do the same via VS.NET 2005. I can only store -SQL- credentials, which I have no need to enable and no desire to add to my surface area.
The problem lies that every time I deploy any report that using that data source (which is nearly all of them), the data source is re-published, which wipes out the stored credentials and caching immediately stops.
I've tried messing with the XML directly, with no luck, and changing assorted advanced settings, but nothing seems to stick.
Obviously I can manually update the credentials each time I deploy something, but surely it seems that there must be a better way. Is there a way to either set the DS to use stored windows credentials, or just plain prevent the deployment of the DS every time a dependent report is published?
Suggestions?
Geof
P.S. SQL 2005 Standard Ed SP1 32-bit
Modifying Shared Data Source At Runtime
Mar 20, 2007Hi all,
I have several reports using single shared datasource. I want to change at a runtime database that is used by that datasource. Can this be achieved? If not what are the other solutions €“ I guess that using not shared datasource for each report may be the solution (is it?) but it is not the best solution for me. My goal is to allow users to run the same set of reports, viewed in ReportViewer control, but using different databases (connection string dependant).
Thanks in advance for any suggestions
Error In Accessing Shared Data Source
Aug 16, 2007
I created the shared data source and the report in VS 2005. After deploying the report to the Report server and trying to access it produces the following error.
An error has occurred during report processing.
Cannot create a connection to data source 'kv_testQA'.
ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
I checked to see if the Data source exists in the Report Server and it does. But it still produces the error. What is the issue here.
Thanks for the help.
Integration Services :: How To Set Up Job For Getting Data And Put In Shared Drive
Jul 17, 2015I've one table which is contains sales Tax data and I need to send data(only for past month) to accounting person by every end of the month for Example. Today is July/1/2015 so I need to send data for month of June/2015.Â
Is there anyway I can setup a job to send a data. Also I am not able to send large file using OUTLOOK so is there any other Tool to send a data?Â
Shared Hosting: Web Data Admin And Local Testing
Dec 18, 2004I just recently added 30MB of SQL Server database space on my Share hosting account.
I want to put the SQL Web Data Administrator on the server but it is an MSI file and I cannot figure out how to install it.
Also, I will be testing my .Net pages on my local machine. How do I go about it without accessing the SQL Server on my host? I used MS Access before and I have a copy of both databases on my local machine and on the server. I'm thinking of using MSDE on my machine and I just change the connection string when I upload my code. Is this a good idea or is there a better alternative?
Thanks.
How To Get A Microsoft SQL Server Compact 3.5 Database Multiuser Work On A Network Share
May 21, 2008Hello All,
I need some advise/help how to deploy a small sql server compact 3.5 database on networkshare where about 8 people have access to it(install de client ) and can modify the database with aprox 3000 records.
I'm using visual basic 2008 and created a compact database and filled it with one table of an export of an access database done with data port console.
And created a new windows forms application and saved the project.
Publish is not the problem but how too set it up......
There is not much info to find on how to get a sql server 3.5 database running on a network share.
Who can help ???
Thanks
What Is The Environment For Data Mining Programmability?
Jun 5, 2006Hi, all here, I am new to data mining programmability. And as we know with the data mining programmability, we can integrate data mining with client applications via a series of data mining programmability APIs like AMO.NET, ADOMD.NET,SERVER ADOMD.NET, OLEDB, ADO,ADO.NET and so on. So what is the environment for the data mining programmability then? I mean what kind of IDE can we develop the data mining programmabiliy? Thanks a lot for any guidance and help.
With best regards,
Dynamically Change Initial Catalog In Shared Data Source In Reporting Services?
Oct 30, 2007First off, let me just say that I'm a complete newbie to SQL Reporting Services, and .NET in general. We have a VB 6 application that is trying to launch an SRS 2005 report in a viewer window. This was accomplished by creating A VB.NET "wrapper" window that launches the report, and allows the report to be previewed, exported, etc. I did not write any of this.
The report is using a Shared Data Source, which points to a specific database. My problem is that the users can select which db they want when they launch the VB 6 Application, so I need to find a way to edit the connection string in the report to specify which database to use on the fly. I have the db name in the "wrapper" application, but I can't figure out how to pass it to the report.
thx,
Paul
Integration Services :: Package Failed After Changing Password In Shared Data Source
Jun 19, 2015I'm using a shared data source to connect an Oracle server in my packages. After changing the database user password in the shared data source, I noticed the package concerned would fail with the following description.
Source: "OraOLEDB"Â Hresult: 0x80004005Â Description: "ORA-01017: invalid username/password; logon denied".
Is there a way to ensure the packages will use the latest information in the shared data source? I did do a Rebuild before executing the packages.
DB Engine :: Deleting 1 Million Records From Transaction Table Of 10 Million Data On 24/7 Environment
Jun 12, 2015I have a requirement to delete 1 Million records from a table having 10 Million data and it's being queried on 24/7 basis (don't have a downtime). how can I achieve that?
View 13 Replies View RelatedShared Drive
May 11, 2000Hi,
I have a shared drive mapped to the h: drive letter on my sql server and I want to create new databases on that drive. Is this at all
possible?
I try it and I couldn't see h: even if I typed it in.
Thanks
Shared Hosting
Feb 16, 2008Hello
Maybe someone can suggest me some software which can be used for SQL 2005 shared hosting?
With database size limit, user number restriction and other features.
Thank you for information in advance
Cannot See Shared Datasources
Apr 9, 2008I am new to reporting services, working with RS2000. Roles and security have previously been set up.
Shared Datasources have been created. How is access granted to shared datasources?
Some users have access but we haven't been able to create new users with access to the shared datasources.
Thanks
Using Shared Variables.
Mar 6, 2007Hi,
I am trying to use shared variables in the emebedded code of a report. But
when i assign a value to the shared variable in the detail level and access
the same from footer it shows different value (0).
I declared an integer variable as a shared variable. And changed its value
in the detail level. Then tried to access its value in the table footer.
Public Shared testVal As Integer
Function testValFunc()
testVale = 25
End Function
In detail level i call Code.testValFunc()
In footer -> Code.testValFunc() gives 0
Any Idea??? Is it because the header/footer is computed first and then the detail?
-
HelpSeeker
Dedicaced Or Shared Connection ?
Jul 11, 2006Exit it in sqlserver notion of shared connection or dedicaced connection like there is exist in oracle ?
Exit it a part of memory (like PGA in oracle) who exist just for the connections ?
Else what are constitued the memory in sqlserver ?
Thanks
Shared SCSI Setup...
Jan 12, 2004Ok, got an assignment from my boss.. Need shared storage for a 2 node cluster, with main focus on MSSQL DB Failover. We won't be storing alot of data, speed it not really an issue, just availability..
As far as I know I need 2 SCSI cards, 1 for each node. Node1 has to have ID7 and Node2 ID6 (for example)
this is it.. what's next? what's the best way to configure all this? Do I need a special box for all hard drives to be with certain controller?
I was thinking to link up like this
terminator
|
Node1
|
|
Disk
|
|
Node2
|
terminator
But I wanted to run some sort of RAID on disk, mirroring is fine.. Anyone can suggest me what parts I should get for this setup? my servers don't have 64bit PCI too
Shared Dimensions - OLAP
Mar 25, 2004Hi,
I have noticed the the cubes that we have here use shared dimensions.
For almost all cubes(5-6) there are at least 4-5 common dimensions.
According to what I have been preached so far, the shared dimensions are so that you can reuse them. That is not what is practised here.
for example.
cube1 has somedim1, dim2_c1, dim3_c1...
cube2 has xyzdim1_c2,xyzdim2_c2,dim3_c2..
dim3_c1 and dim3_c2 are the same dimensions, one for each cube.
I don't know if I am missing something. Shouldn't the use the same dimensions? Could there be any reason for this.
pls. advice.
TIA