Session Isolation With Local SQL Anywhere Database
Aug 5, 2010
I am migrating an existing set of applications from Win XP to Win 7. We have a 3rd party application which is launched by and runs in the user's session which accesses a local SQL Anywhere 9 database via ODBC (launched on demand using dbeng9). On the same machine we have an ASP.NET website which also accesses the local SQL Anywhere database via ODBC. These two applications play nicely together in Win XP because both processes are running in Session 0.
In Win 7 the ASP.NET site encounters an ODBC error stating that the specified database file is already in use. This is because the 3rd party app starts first and spins up an instance of dbeng9 (via ODBC) in the user's session (usually Session 1). Then, the ASP.NET spins up and attempts to connect to the same database. The ODBC driver sees that an instance of dbeng9 is not running in the current session (Session 0) and attempts to spin up an instance at which time it is unable to access the database file because it is already in use by the logged on user in Session 1.
Does anyone have any suggestions for solving session isolation issues with local SQL Anywhere databases?
I thought about running dbeng9 as a service rather than allowing ODBC to spin up an instance on demand. However, because SQL Anywhere is bundled with the 3rd party product the PCs do not have dbsrv and I'm not sure how this would impact the licensing.
The ASP.NET site is only accessed from the local PC. Would running the ASP.NET site in a 3rd party web server cause it to execute in the user's session? (Note: because this runs on 1,000 machines a free or very low cost option is a must.)
Is the ASP.NET Development Server that is bundled with Visual Studio redistributable in this manner?
Can IIS 7 or IIS 7 Express be configured to run in "local only" mode in which it executes in the
user's session?
View 1 Replies
Similar Messages:
Nov 10, 2010
I am using ShDocVW.InternetExplorer class to spawn a new internet explorer object and to do some form filling stuffs(for some sharepoint works).It works fine in my own machine which has Windows 7 as the OS. But when I deployed the same thing in windows server 2003 machine, it does not pop up the internet explorer window. When I check the Task Manager, I could see a new iexplore process, but with Session ID = 0 (but session ID = 1 in windows 7). So, I see this is something regarding IIS Session isolation.So, is it possible to assign a ShDocVW.InternetExplorer instance to kind of a new System.Diagnostics.Process and achieve this task? Or can we start a new ShDocVW.InternetExplorer instance with session ID = 1?
View 3 Replies
May 19, 2010
Using IIS 6, is Application Isolation happen based on the Application Pool? If so, what happens when there is more than one Virtual Directory in one Application Pool? Do they all share the same memory and if one Virtual Directory crashes, all the other apps crash as well?
View 2 Replies
Oct 10, 2010
I'm building a multi-tenant ASP .NET application. Given that each tenant can configure their application dynamically (which may involve dynamic custom assemblies being loaded into memory), I need a means of isolating each tenant.
I'd prefer not to create a new Web Application per tenant for maintenance reasons.
I've was considering using the AppDomainManager to create an AppDomain per application, but it seems this is not intended to be used for ASP .NET applications.
View 3 Replies
May 16, 2010
I am implementing an Isolation test in my project to ensure the data is the same in the as it was when originaly retrieved before submitting the new form data.I was wondering what would be the best way of handling this error (not an exception). The following code is the function that will determine whether or not an error should be reported, If 1 or more fields of the current record is different from the original it will return false, otherwise it will return true. How should I go about handling a false response for a best practice, Should I use a statcode and transfer to the main page displaying a message with the state code, or should I send a simple msgbox, or simply just log the error and transfer the user to main page.
[Code]....
View 1 Replies
Mar 2, 2010
I'm trying to figure out if it's possible to transfer records from SQL central database (who has a public IP address) into SQL local database (who doesn't have a public IP)?
or if it's not possible can I use a centralized website instead to pass some data into the local website? (but i'm not sure if it will have some security concerns)..
View 3 Replies
Sep 1, 2010
I have production server on our intranet and we have website on remote server with its own database. Now we want to sync some tables from our local database to remote database at some interval of time. I have own idea that if data sync is fail than we should get email about that from remote database.
For above scenario I was looking some ideas from you guys and different method to do it. I know about replication of database how to do that. Can we do it by asp.net, SSIS package which will be easy.
View 3 Replies
Aug 11, 2010
I have written code that uses a .bat file (code: rwvinstat /server:servername) that populates a DataGrid of users logged in to a terminal service session in c#. The .bat lives on the server with the app. files and will run properly if executed manually on the server .Also if i run the app. locally and call the .bat file on the server it works fine.
The problem is when i deploy my web app on the server the DataGrid never populates nor do i get any errors. i have given full permissions to IUSER_MACHINENAME(and various users) and i set the virtual directory permissions to read, run, execute. Ialso have set my web.conf fig to:< "identity impersonate="true" userName="username" password="password"/> Here is my Source code:
using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Text;
using System.Runtime.InteropServices;
using System.Text.RegularExpressions;
using System.IO;
public partial class ilsap01_users : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
System.Diagnostics.ProcessStartInfo psi = new System.Diagnostics.ProcessStartInfo("C:\listUsersIlsap01.bat");
psi.RedirectStandardOutput = true;
psi.WindowStyle = System.Diagnostics.ProcessWindowStyle.Hidden;
psi.UseShellExecute = false;
System.Diagnostics.Process listFiles;
listFiles = System.Diagnostics.Process.Start(psi);
System.IO.StreamReader rawUserData = listFiles.StandardOutput;
listFiles.WaitForExit(20000);
try..................
View 2 Replies
Aug 6, 2010
Initially i had vs 2005 and vs 2008 installed in my machine and both of them were working great.Yesterday i installed vs 2010 in my machine and then i saw that it was also working great.Today when i tried to add a local database in a project that i was working for in vs2008,then i get this error:
then i tried to add a local database in vs 2005 and again i get the same error
This error is not letting me to add the local database
but in the past i had all three vs installed in my machine at the same time and they did not cause any problem like the one i am facing right now.
View 15 Replies
Jan 11, 2011
I have a website used by clients for reporting purposes and would like to give clients the option of my website reading their local database directly (instead of them providing data in a file format).In most instances their database would be SQL Express setup on their localhost.
How can I connect to a clients local SQL server via my website, using asp.net / javascript etc? If the client provides their connection string properties, localhost would just refer to my server's localhost...
Consider the following :Most people connect to the internet via an ISP. THeir database will run on their localhost and will not have a public address as such.Ideally, the client must supply some connectionstring (database name, login etc.) and my server must connect.VPN's wont work for this - I must connect to them (in a programmatic way) and pull data, not the other way around.
View 3 Replies
Jan 31, 2010
I had developed a program a few years back that stored data in an XML file. Over the years, I had accumulated about 500 or so records in the XML file. I wanted to replicate this program online using SQL as the holder of my data.
So I started developing the program using VB 2005 and ASP using the local SQL server on my computer. The first thing I wrote in my program was a piece that took the data from the XML and copied it into the SQL automatically...which was nice, made it easy. Then I continued to work on the program.
Eventually I copied everything to my online area and started running it, everything seems to be working fine so far but I'm stuck.
Is there a way to take the 500 or so records I have locally in a SQL Database and upload it to the SQL Database with the exact same structure that is online so I don't have to re-enter all these things?
View 7 Replies
May 27, 2010
Is there a way to display pdf from local directory or database in a object tag.
My problem is I am trying to display pdf print dialog after pdf is loaded.
This is possible if I load pdf using object tag, but currently my pdf is getting loaded dynamically using response.binarywrite.
View 1 Replies
Nov 2, 2010
I'll be having a website to upload images and am creating the database now , I'll have one original image and about 6 to 7 thumbnails , I just want it to be in the best possible way so I thought I'll save the original image in database and I'll be saving it's thumbnails on hard drive as they're going to be accessed alot so I dont want the httphandlers to be bringing like 20 images from the database while they can be brought easily from the harddrive.
View 7 Replies
Mar 20, 2010
I am wriyng an ASP website for my use on my local PC.
I have setup IIS and eveything works OK apart from accessing my SQL database. As I'm new to this I did not realise that you need to change the connnection string to reflect the place where the DB will be.
Having tried various options like http://localhost/ & db name, without succes I'm looking for some help.
View 8 Replies
Sep 13, 2010
Is it possible for an ASP.NET web application installed on a web server to connect to an Access database stored on a local PC (which is NOT the web server)? I would like the web application to allow the user to specify the path/complete file specification to the database. Or, based on login information specified by the user, the web application might determine the path to the database via an administrative database stored on the web server. The user/customer would be responsible for the storage of the Access database. If the answer to my first question is "YES", how do I programmatically specify/format the path to the Access database on the local PC so the web application can locate the database?
The path has to be something more than "C:foldernamesubfoldernamedatabase.mdb". When I use a path like this, the web application produces an error indicating that the database does not exist or cannot be found. So, I'm fairly sure that the web application is not starting with Drive C: on the local PC to find the database. For all I know, the web application may be interpreting Drive C: as Drive C: on the web server. I'm wondering if I need to specify a computer name before "C:" in the database path.
View 1 Replies
Jan 13, 2010
I had a database on a development server of which I am not the owner. The connection string was:
Dim MM_cnnTraining_STRING
MM_cnnTraining_STRING = "Provider=SQLOLEDB.1;Password=xxx;Persist Security Info=True;User ID=xxx;Initial Catalog=Training;Data Source=xxx"
I copied this database to my local machine, In services MSSQL is set to logon with my computer username and password, I have no idea if this affects anything.Also the local database which I can view in MSSQL Server Management Studio, I can connect by Windows Authentication only. The database copied there seems to have maintained the same permissions.Im completely confused. I finally was able to copy to my local machine but now can not connect. I am using dreamweaver, but using the connection string above.
View 7 Replies
Apr 17, 2010
im trying to transfer my database from local machine to server, im using the publish to provider wizard in visual web developer to generate a scrip, im then using the generated script on the serever database.
[Code]....
View 1 Replies
Sep 1, 2010
Here i want to export my data from local sql server 2000 DB to online sql server 2008 DB.
View 6 Replies
Sep 28, 2010
how to connect an asp.net application running in local IIS to a database residing in a remote web server ?
View 2 Replies
May 17, 2010
My hosting company provider MS SQL Express as part of my hosting package, they have provided me with both the name and IP address of the server running MS SQL Express.
I have created a database on this server via management studio and when I create a connection string like this (connectionString="Data Source=ServerName/IP;Persist Security Info=True;User ID=xxx;Password=xxx") my application works fine.
But if I create a local database file and try to attach this with a connection string like this (connectionString="Data SourceServerName/IP; AttachDbFilename=|DataDirectory|Database.mdf;Integrated Security=True;User Instance = True ; Trusted_Connection=Yes) my application doesn't work.
Therefore my questions are:-
Is there something wrong with my connection string? Can you use a local database file within a production environment?
View 8 Replies
Aug 16, 2010
On my web page I'm trying to manage a tabular control of some kind that supports inserting. The data will be inserted locally on the page, with no connection to any kind of DB. The inserted data will exist only on this page and will be lost after navigatingto another page.A table that shows all the added rows and has an empty row for inserting is perfect.
View 5 Replies
Dec 2, 2010
I have a ASP.Net website that interacts with Dynamic CRM. It's also uses a local ASPNETDB.MDF for forms authentication. For the CRM I need to impersonate the identity created on the domain for this purpose. When identity impersonate is enabled I no longer have access to the local Membership Database. How can I allow the domain user used for the impersonation access to the membership database?
View 1 Replies
Aug 18, 2015
How save and display data from local storage with angular..I want save this data example
View 1 Replies
Jul 28, 2010
Problem: I need to move a local development database to the production server without any of the test data.
I am running SQL Server Express 2008 and SQL Server Management Studio 2008.
To create my ASP.NET Membership 2.0 system I created the DB initialy and ran aspnet_regsql.exe
I then added my own tables manually to store additional information.
I adjusted the web.config file with an application name.
When I ran a sript the application ID name was created and populated in the aspnet_Applications table. My script created a new member created and added to the admin role. Ok so everything go so far.
Now I want to move the local DB to the server. I know the connection string and can change this in the web.config.
My hosting company doesn't provide restore, so I don't think I can backup and restore
Q 1. What would be the best way to move the database across. Bearing in mind I need to clean the database out of test data.
Would it be just generate an SQL Script for the database and run it as a query on the server? And if this is the best way then do I need to set the permissions for the ASPNET user?
Q 2. What is the best way to clear out the data in the local database.?
View 1 Replies
Jun 9, 2010
In remote db, I can be able to connect ms sql db as localhost in my connection string like below,
<
add
name="ConnectionString"
connectionString="Data
Source=localhost;Initial Catalog=DBServer;Persist Security Info=True;User ID=sa;Password=*****"
providerName="System.Data.SqlClient"
/>
This is running in server and its working fine.
If i want to make any changes in db structure or need to modify any data values, i have to login remotely to my server and has to open sql server management studio do db change or value editing stuffs. Its really getting iritating when the remote machine looks slow.
I just want to know how to configure the db hostname like dbname.domainname.com or mssql.domainname.com in server, so that we can open the server db in local using sql server management studio.
The application installed in windows server 2008 and using IIS 7.0 & SQL Server 2008
I have only little knowledge in server.
View 6 Replies