A few years ago I wrote an active-X server to maintain a single
connection to a file .mdb from multiple apps on same PC because I was
having to many database curptions.
Should I use the same Active-X server for the same in a MS SQL Server
DSN connection or is it ok to have multiple apps from the same pc using
the DSN?
New to MSSQL
Management is getting frustrated with the increase in number of NT servers for MSSQL and Vendor packages. Currently we purchase a box for each app. We would like to go to one or two MSSQL servers running multiple application database's (based on size etc) . How are you handling this? Do you do this for test only or both test and production? Any gotcha's. Any help will be appreciated.
Thanks
john
HI all
I have a relativley unique setup
where all the sql servers have been consolidated
so multiple applications are connected to their respective databases on the same SQL server
The problem I have is when an app locks tempdb all the other apps that require it are blocked/slow
The ?
can tempdb be split or multiple tempdb's be created
Hi guys,I've got two apps that are going to have pretty much the same users and i wanted them to have the same ASPNET.MDF user database. Is it possible to store the ASPNET.MDF in a different location and then have the two apps access it from there or alternatively have it in the App_Data folder of one of the apps and then have the second app access it from there?Thanx
View 2 Replies View RelatedI have an application that was developed under Visual Basic .NET 2005 Standard that I keep continuously running to monitor and gather data and store that data in a SQL Server Express database. This is all done on a single computer that's not networked to anything. The trouble is, I'd like to look at the data in the database from time to time without shutting down the application, but I'm not able to do so. If I try to copy the database files, named lamination.mdf and lamination.ldf, to another location, I get the following error message;
"Cannot copy lamination: There has been a sharing violation. The source or destination file may be in use."
I would like to be able to copy the file to my office computer where it would be convenient to use Management Studio Express to look at the database tables. I can't even use Management Studio Express on the computer where the application is running, as I get the following message when I try to attach the database:
"CREATE FILE encountered operating system error 32(The process cannot access the file because it is being used by another process.) while attempting to open or create the physical file 'C:Documents and Settings barnardMy DocumentsVisual Studio 2005ProjectsLamination Phase ILamDataBaseLamination.mdf'. (Microsoft SQL Server, Error: 5123)"
Here is the connection string in the VB application:
"Data Source=.SQLEXPRESS;AttachDbFilename="C:Documents and Settings barnardMy DocumentsVisual Studio 2005ProjectsLamination Phase ILamDataBaseLamination.mdf";Integrated Security=True;User Instance=True"
In the VB app, connections to the database are made only every few minutes, and the connections are immediately closed.
Is there anyway I can either copy the database files, or at least look at the database tables with Management Studio Express without stopping the VB application?
Thanks,
Tim
I have SQL Server 2000 with databases on the NetApps filer CIFS share.For example, the datafiles are located at \network shareserversharemicrosoftsqlservermssqldata...Whenever there is a filer failover, some of the databases go in suspectmode. Is there a setting on SQL Server like a time out setting from thenet apps that can be modified so that the databases will wait for awhile before going into the suspect mode?Raziq.*** Sent via Developersdex http://www.developersdex.com ***
View 1 Replies View RelatedWe are currently migrating our sequel 6.5 databases to sequel 2005
We have a handful of vb6 apps that connect to the current 6.5 database.
Can anyone recommend the "best practice" for connecting vb6 apps to sequel 2005 databases ?
Thanks in advance.
I'm planning an SQL 2005 deployment and would like to know if an SQL server should be kept as dedicated as possible. Should apps that access SQL be kept on other servers? What are the do's and don't's along these lines? The plan here is to install everything that accesses SQL on the same server with the database, but this seems like a bad move to me. Am I right?
Thanks!
Gregg
Hello there
I have a customer that wants to start using SQL Server 7.0 instead of Oracle, but they have a lot of Oracle applications (made in Developer 2000 and Forms). Due to the big effort needed to convert those applications (to Visual Basic), they want to be able somehow to migrate only data from Oracle to SQL Server, and then use some tool that will allow them to use the same applications with the SQL Server 7.0 engine.
I found on the "SQL Server Developer's Kit" a document describing the process of migrating data and applications from Oracle to SQL Server. There is a mention to an Oracle tool called "Oracle Gateway to SQL Server" that will translate calls received by the Oracle engine to the SQL Server engine, but this approach will still require the existence of Oracle servers (which is the thing the customer no longer wants).
The second option mentioned on that document, and the one that seems more attractive, is the use of Oracle "Open Client Adapter" (OCA) that will allow Developer 2000 applications to communicate directly to SQL Server via ODBC. However, I have been unable to find (on the Oracle site) any documentation regarding this tool.
Has anynoe heard or used such tool (OCA) ? Any comments, tips, drawbacks, experience you could share ? Any other idea on how a thing like that could be accomplished ? Perhaps a third-party application that can act as a gateway between the Forms app and ODBC/SQL Server, or that will be able to generate VB code from a Developer 2000/Forms app...
Any help will be appreciated.
Please respond directly to me, as I am not a member of the distribution list.
Luis Francisco Silva
Ok guys, I am trying to install Sql server 2005 on Vista but I am still stuck with this warning message in the System Configuration Check during Sql server 2K5 installation :
SQL Server Edition Operating System Compatibility (Warning)
Messages
* SQL Server Edition Operating System Compatibility
* Some components of this edition of SQL Server are not supported on this operating system. For details, see 'Hardware and Software Requirements for Installing SQL Server 2005' in Microsoft SQL Server Books Online.
Now, I know I need to install SP2 but how the hell I am going to install SP2 if Sql server 2005 doesn't install any of the components including Sql server Database services, Analysus services, Reporting integration services( only the workstation component is available for installation)?
Any work around for this issue?
P.S.: I didn't install VS.NET 2005 yet, can this solve the problem?
Thanks.
I have a Windows 2003 Server running IIS 6.0 and SQL Server 2005. I have just (Today) deployed the first ASP.NET application (developed in Visual Studio 2003 and, as such, dependent on .NET Framework 1.1) on this server and am getting HTTP Error 403 (You are not authorized to view this page). This ASP.NET application runs fine on another server that is configured with the OS=Windows Server 2003, IIS=6.0 but without SQL Server 2005 and without the .NET Framework version 2.0. I found in the IIS Application configuration (on the troublesome site) that my app (in the Default Web Site folder) was pointing to the version 2.0 aspnet_isapi.dll. All efforts to use aspnet_regiis to "re-align" my app with version 1.1 have been fruitless to eliminate the HTTP Error 403. I granted the NETWORK SERVICE account privledges to the wwwroot folder. At this point, I don't know if I have a Framework error or a privileges problem.
Please help.
Thanks,
Rob
Hi SSIS-fellows!
I am stuch at a problem that sould be very simply but it is not. At least for me
Here is the initial state:
Working folder: E:123DTS and E:DTSArchive
files: akarmi.zip, akarmi2.zip (there are one-one mdb files inside)
What I want to do with the package:
a) unzip the first file (there is an unzip.exe for this task)
b) rename the unzipped mdb (its name can be anything) to default.mdb
c) use the mdb with another package (that is not yet designed so I haven't added this one)
d) delete the default.mdb
e) move the first zip file into E:123DTSArchive
f) do a-e with all other zip files in the folder (so only once more in this case)
What I did:
1) I created a foreachloop container to do these with all the zip files, I correctly configured the enumerator to *.zip and created a user::zip_files variable
2) put an unzip ExecuteProcessTask. Its argument was the user::zip_files variable (this worked great)
3) I created another foreachloop container because I don't know how to rename the only existing mdb file in the folder (I wasn't able to use wildcards here)
3.1) this time the enumerator was *.mdb and the variable was user::mdb_files
3.2) I put a file system task into the container to rename that mdb file to default.mdb. I used variables for source and destination, too. Source variable (SourceRename) was an expression made of WorkingFolder variable (that was E:123DTS) +
user::mdb_files. This supposed to work but didn't When I put the exact name of the mdb instead of the user::mdb_files variable it worked without any problem.
4) another 2 file sytem tasks to move the original zip file into the E:DTSArchive folder and to delete the default.mdb file
5) end of the loop
I had problems with task 3) I even tried to make it run separately but without success
I would think that the solution is very simple. I would be grateful even if someone just send or upload me a package that renames every mdb file in a directory into default.mdb (it might sound stupid but if there is only 1 mdb that's okay and since this container is inside another the other default mdb files can be overwritten after using them in another package).
I've uploaded my packages with the files here: http://www.sendspace.com/file/mrd2jh
I was dealing with this one all day (with some interruptions) and I can't believe it can't be done.
Thanks in advance,
MartinIsti
My current environment has multiple packages stored in SQL server (MSDB).
When working on a set of packages I want to bring them into my local development area
Add existing package only allows you to pull one package at a time - anyone have the secret to selecting multiples
Thanks
Would it be possible to handle multiple file systems (e.g. xlsx, csv, mdb) with different /similar headers in single package without Script Component?
View 1 Replies View RelatedHow many "applications" can be loaded onto Microsoft SQL Server 6.5?
Additional Information:
The OS platform is Windows NT Server 4.0 (SP5) on a Compaq ProLiant 1600 (PII 450) with 256Mb RAM
Proposed applications, although this probably will mean little, are Dataview (club membership) Peterborough (payroll) and Positive (HR).
Any assistance would be appreciated.
Thanks
Robert
robert@whiteley.com
Hey guys, my first post so here goes...
I'm wondering if anyone here knows how to write a program (or download a program) that pretends its a sql server and listens for connections, so that when an app thinks its sending its connection string to a server, its sending it to the locally installed program, so that you can get the UID and password from the connection string.
I'm working at a company where we need to write an extension to the software we use but we don't know the login to use for it. These programs are horribly designed. If you run it with the net card disabled it dumps the connection string to the screen but of course it has the UID and pass starred out. Any thoughts?
I'm struggling to connect to my SQL server whilst running a dot net application which is located on a network drive.
the program will run perfectly from my c drive, but as soon as i move the program file on to the network, it no longer recognises my windows permissions, and does not connect to the database.
can someone help?
is there some code that i need to add to my dot net code?
Help!
Does anyone know where can i find some windows or web applications using ssis for manipulations?
If a user's pc needs to run 2 different applications (sold by 2 different vendors) and one must be 6.5 and the other must be 7.0, are there any problems with the client machine?
My understanding is that each of the apps comes with the pieces it needs to connect. I'm trying now to reach the tech types at the vendors and ask what kind of custom setup (if any) is needed on a user workstation or if the install does everything. If they come with their own dlls and odbc data sources, might all be well?
Does anyone have apps loaded on a desktop that connects to both a 6.5 and a 7.0?
Thanx,
Dick Scherrer
Hello,
i am planning to build Pocket Pc App and i would like to know if i can use Sql Mobile as my data store. The data base design is quite complex.
I wont be using any recplication/synchronization in my app since its a standalone app.
pls suggest.
Thanks
Karthik
most articles I read suggest that apps need to retry upon failure in a mirrored environment, using a different connection string, not worrying a whole lot about waiting for the retry. But I heard somewhere that the original connection string can also contain info about the mirrored db, thus eliminating the need to use two different connection strings, and perhaps not even needing to retry programatically. Which is correct? I also heard that programatic retry could be required anyway because of some bug involving the "first" failure and disappearance of a connection pool. Can someone just provide the 50,000 foot view of what it takes to make an app "mirror aware"?
View 1 Replies View RelatedHi
My console applications work for SA and no other user. I can run the Stored procedures used in the console application from Query analyser when logged in with username/password that I am attempting to use for console applications. I am using SQL server authenication. User access permissions look ok in Enterprise Manager. Access is permit for my user.
Any suggestions?
Thanks
i'm building apps using sql server express and I want to deploy to servers that have the 2.0 .net framework but have sql server 2000 database.
Can this be done, and if so, how?
Observing God€™s Holy Spirit, I see God saying that The Lord Jesus influences every natural occurrence of kindness, righteousness, and judgment (Jeremiah 9:23-24). I believe God, so I thank The Lord Jesus for your grace in these matters.
Is there a way to execute ETL packages programatically? Specifically, is it possible to
manually invoke the ETL package to execute from, say, an ASP.NET
application?
If so, how do you do that?
I've been searching MSDN regarding this but all I see are examples on programatically building packages.
I have created a windows library control that accesses a local sql database
I tried the following strings for connecting
Dim connectionString As String = "Data Source=localhostSQLEXPRESS;Initial Catalog=TimeSheet;Trusted_Connection = true"
Dim connectionString As String = "Data Source=localhostSQLEXPRESS;Initial Catalog=TimeSheet;Integrated Security=SSPI"
I am not running the webpage in a virtual directory but in
C:Inetpubwwwrootusercontrol
and I have a simple index.html that tries to read from an sql db but throws
the error
System.Security.SecurityException: Request for the permission of type 'System.Data.SqlClient.SqlClientPermission, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.
at System.Security.CodeAccessSecurityEngine.Check(Object demand, StackCrawlMark& stackMark, Boolean isPermSet)
at System.Security.PermissionSet.Demand()
at System.Data.Common.DbConnectionOptions.DemandPermission()
at System.Data.SqlClient.SqlConnection.PermissionDemand()
at System.Data.SqlClient.SqlConnectionFactory.PermissionDemand(DbConnection outerConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection,
etc etc
The action that failed was:
Demand
The type of the first permission that failed was:
System.Data.SqlClient.SqlClientPermission
The Zone of the assembly that failed was:
Trusted
I looked into the .net config utility but it says unrestricted and I tried adding it to the trusted internet zones in ie options security
I think that a windows form connecting to a sql database running in a webpage should be simple
to configure what am I missing?
Hi
I installed Sql Server 2000 in my server with windows authentication.
IIS side under security tab checked Windows authentication option.
When i try to my asp.net web application everything is working fine.
But now as per user wish i dont want to use windows authentication.So sql side i create one user called 'global' and giving full permissions .In IIS side unchecked the windows option and checked
Anonymous access and given 'global' user id at anonymous user account place.
Now when i try to run my Web application i can connect to sql servel and fetch the data but no events are running in my .aspx page.means when i click any button or select list or combo box nothing is happening.All events are not firing and also not giving any error message.Its simple showing the page as it is.
When i un checked Anonymous access and checked windows authentication everyting working fine.
Really not getting why its doing like this .
Pl help me in this.
thanks
Hi all,I bet this doesn't exist, but does anyone know of an MS SQL EnterpriseManager-type application for Linux that would give me access to a DTSstored on the server? I'm a web programmer by profession, and most ofmy tools are Linux-based, but because I do so much indepth work in MSSQL and DTS's, I've been dual-booting between Windows and Linux mainlybecause there's no way I know of to access my MS SQL DTS's from Linux.Any Linux solutions out there that will read and maybe even edit SQLDTS's?Thanks,Alex.
View 1 Replies View Relatedwhat proactive steps can we take to make our app (ado, stored procs etc) cluster aware, in the event that we someday use clustering? For instance, I read things about retry strategies etc but dont even know if retry is on a different connection or what appears to be the same connection. We already make our trans as small as possible.
View 7 Replies View RelatedI have a question:
Is SQL Compact Edition safe to use in ASP.NET WebApps?
And second if so, should i use transation isolation level or row locking hints to assure data quality during iniserts?
E.g. i want to assure that there is only one record named user2@domain2 and thus i want to make sure that my code
will not fail in a mutli-theaded scenario and insert second one or get a key exception back: see sample
transaction or locking hit{
select from users ....
if no user found
insert into users
}
Thanks
Tim
Using Forms Authentication With Windows Apps--
I've used the code from UILogon.aspx (Forms Authentication Security Extension) to extend a proxy server in a windows application to manage the cookie when connecting to a Reporting Services web service.
When the proxy class is instantiated I get this error on the AuthCookie property:
'server.AuthCookie' threw an exception of type 'System.NullReferenceException'
The code executes properly in UILogon.aspx and AuthCookie is set to a null reference.
Please adviseif you can assist debugging this:
The code:
------------------------------------------------------
//using directives
-------------------------------------------------------
using System;
using System.Collections;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.IO;
using System.Text;
using System.Text.RegularExpressions;
using System.Web.Services.Protocols;
using System.Windows.Forms;
//using rs2005 = Microsoft.SqlServer.ReportingServices.ReportService2005;
using rs2005 = Microsoft.Samples.ReportingServices.RSExplorer.ws_reportservice2005;
using System.Runtime.InteropServices;
using Microsoft.SqlServer;
using Microsoft.SqlServer.MessageBox;
using System.Globalization;
using System.Net;
using System.Web;
-----------------------------------------------
// proxy class
--------------------------------------------
public class ReportServerProxy : rs2005.ReportingService2005
{
protected override WebRequest GetWebRequest(Uri uri)
{
HttpWebRequest request;
request = (HttpWebRequest)HttpWebRequest.Create(uri);
// Create a cookie jar to hold the request cookie
CookieContainer cookieJar = new CookieContainer();
request.CookieContainer = cookieJar;
Cookie authCookie = AuthCookie;
// if the client already has an auth cookie
// place it in the request's cookie container
if (authCookie != null)
request.CookieContainer.Add(authCookie);
request.Timeout = -1;
request.Headers.Add("Accept-Language",
HttpContext.Current.Request.Headers["Accept-Language"]);
return request;
}
[System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2201oNotRaiseReservedExceptionTypes")]
protected override WebResponse GetWebResponse(WebRequest request)
{
WebResponse response = base.GetWebResponse(request);
string cookieName = response.Headers["RSAuthenticationHeader"];
// If the response contains an auth header, store the cookie
if (cookieName != null)
{
Utilities.CustomAuthCookieName = cookieName;
HttpWebResponse webResponse = (HttpWebResponse)response;
Cookie authCookie = webResponse.Cookies[cookieName];
// If the auth cookie is null, throw an exception
if (authCookie == null)
{
throw new Exception(
"Authorization ticket not received by LogonUser");
}
// otherwise save it for this request
AuthCookie = authCookie;
// and send it to the client
Utilities.RelayCookieToClient(authCookie);
}
return response;
}
private Cookie AuthCookie
{
get
{
if (m_Authcookie == null)
m_Authcookie =
Utilities.TranslateCookie(
HttpContext.Current.Request.Cookies[Utilities.CustomAuthCookieName]);
return m_Authcookie;
}
set
{
m_Authcookie = value;
}
}
private Cookie m_Authcookie = null;
}
In VS 2005, using the ReportViewer control on a form in a Windows app, I've created an Object Data Source for the report by following the walkthrough in the documentation, it works.
View 4 Replies View RelatedI have both used the Data Connection Wizard and tried programatically to
View 29 Replies View Relatedif an app sits in an environment where both clustering and mirroring are available for HA, are there some simplified best practices, perhaps patterns or .net classes suggested by MS for making the app aware of both clustering and mirroring?
If the mirror db is also contained in the original connection string as a retry partner and SQL failed over automatically, the app wouldnt have a say in first retrying against the cluster. It might prefer cluster first because the mirroring is asynchronous and therefore a bit less up to date than the cluster. This of course assumes the app is ok with the longer failover time. If the partner isnt included, the app needs to be aware of two connection strings.
Is there some feature in SQL for having the best of all worlds, ie one connection string but having a "say" or "rule" in exactly what sql does and doesnt do for you and in what order?