Any Benefits To Using A Db That's Placed Under A Data Connection?
Jan 16, 2008
I find that in Database Exporer in Visual Web Developer, I can specify a DB in two ways, as exemplified here:
Data Connetctions
+ ke_test_db.mdf
+ ssftec023-lsqlexpress.master.dbo
+ ke_test_db2.mdf
Experimentation shows that mdf files that can be put under the "sqlexpress" item (ke_test_db2.mdf in the example) are those that SQL Server Configuration Manager Express knows about, whereas files that I create via adding an item in Solution Exporer appear at the top level (ke_test_db.mdf). My question is, is there any advantage or disadvantage to either architecture? I.e., Is there any advantage to being sure that one's DB files appear under the sqlexpress connection item?
I have a question relating to XML and SQL. My company currently runs a website which allows its clients to log in, view their accounts and transaction history online. The website is totally read only with the exception of changing passwords.
The data is taken from our back office system overnight which runs an oracle 8i database (we cannot like our website to the database due to the agreement we have in place with our software supplier). The data is written to a CSV file which is then converted into XML. The XML file is saved to the webserver and is referenced by the website.
The structure of the website has a relationship where the Client has a Manager who can see their clients accounts, a Branch level that can see all of their Managers and the underlying clients and then finally a company level that sees everything.
We are finding that using XML is causing a real issue in performance and I was wondering if migrating the website to SQL server would improve the performance of the queries etc .
I was just wondering what if someone can summurize the benefits between using Access and SQL for an ASP.NET 2.0 website? Can you use an Access database that doesn't have SQL installed on it with ASP.NET?
I'm designing a database and was researching common conventions and standards. I found that some people don't use the identity column for a primary key because they prefer to create their own unique id number for the column. Whats your opinion?
Hi, there is an existing application running on a SQL Server database.Now I have to built a different app, which will have two common tableswith the existing database (Customers, sales)Is there any benefit (performance mainly) creating the tables for thenew app in a new database? (On the same machine and the same instance)*** Sent via Devdex http://www.devdex.com ***Don't just participate in USENET...get rewarded for it!
Hi, I've never really used the SQLDatasource, I usually fill a dataset & use that. When would you use an SQLDatasource? I notice it doesn't return dataviews but I also noticed that you don't need to open the conenction. Any ideas on best practice? Many thanks
Very simple question from a real n00b: In many of my stored procedures I am repeating a CASE statement where I'm replacing null values with zero, like this:
(CASE WHEN @Field IS NULL THEN 0 ELSE @Field END)
I have many SPs where I have that code repeated literally dozens of times. Is there any performance benefit to creating a function to perform this task and using that instead of the repeated CASE statements? Or am I trying to be too clever?
I am using sqljdbc41.jar to connect with MSSQL database, it is working fine on my local machine.Where as on the remote server, same class giving me error
Login failed for user '<domain><windows loginID>' My connection string is URL...
I am using sqljdbc41.jar and on 64 bit processor , I am using following command which included path for sqljdbc_auth.dll java -Djava.library.path= C: sqljdbc_4.1enuauthx64 TestDao and error is Login failed for user '<domain><windows loginID>' why it is not picking up username passed in connection string. I have 2 machines, one is local and other is remote. on both machine I login using my domain, it is working absolutely fine on local then why the error is coming on remote machine.Both the machines are identical.
I've created a SSIS Solution and have created Data Sources. I have two packages. One was created before the Data Sources, and one was created after. The package that was created after is using connections from the Data Sources. I want to change the package before the Data Soruces were created to use them, but when I right click in the Connection Managers pane "New Connection From Data Source.." is not an option.
I have read over the feature set and I really don't see a huge reasons to jump on the bus. There are a few niceties like IP enhancements, cluster enhancements and maybe bitlocker for the backup drive. Am I missing something?
RE: XML Data source .. Expression? Variable? Connection? Error: unable to read the XML data.
I want my XML Data source to be an expression as i will be looping through a directory of xml files.
I don't see the expression property or the connection property??
I tried setting the XMLData property to @[User::filename], but that results in:
Information: 0x40043006 at Load XML Files, DTS.Pipeline: Prepare for Execute phase is beginning. Error: 0xC02090D0 at Load XML Files, XML Source [108]: The component "XML Source" (108) was unable to read the XML data. Error: 0xC0047019 at Load XML Files, DTS.Pipeline: component "XML Source" (108) failed the prepare phase and returned error code 0xC02090D0. Information: 0x4004300B at Load XML Files, DTS.Pipeline: "component "OLE DB Destination" (341)" wrote 0 rows. Task failed: Load XML Files Information: 0xC002F30E at Bad, File System Task: File or directory "d:jcpxmlLoadjcp2.xml.bad" was deleted. Warning: 0x80019002 at Package: The Execution method succeeded, but the number of errors raised (2) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors. SSIS package "Package.dtsx" finished: Failure. The program '[3312] Package.dtsx: DTS' has exited with code 0 (0x0).
Was 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...
I added a connection (ADO.NET) object by name testCon in the connection manager - I wanted to programmatically supply the connection string. So I used the "Expressions" property of the connection object and set the connectionstring to one DTS variable. The idea is to supply the connection string value to the variable - so that the connection object uses my connection string.
Then I added a "Backup Database Task" to my package with the name BkpTask. Now whenever I try to set the connection property of BkpTask to the testCon connection object, by typing testCon, it automatically gets cleared. I am not able to set the connection value.
Then after spending several hours I found that this is because I have customized the connection string in testCon. If I don't customize the connection string, I am able to enter the "testCon" value in the connection property of the BkpTask.
I'm trying to re-write my database to de-couple the interface (MS Access) from the SQL Backend. As a result, I'm going to write a number of Stored Procedures to replace the MS Access code. My first attempt worked on a small sample, however, trying to move this on to a real table hasn't worked (I've amended the SP and code to try and get it to work on 2 fields, rather than the full 20 plus).It works in SQL Management console (supply a Client ID, it returns all the client details), but does not return anything (recordset closed) when trying to access via VBA code.The Stored procedure is:-
USE [VMSProd] GO /****** Object: StoredProcedure [Clients].[vms_Get_Specified_Client] Script Date: 22/09/2015 16:29:59 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON
i am using VS05 and sql05express. After I created a new web application i want to add a database. But when I do so i got the following message: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) is anybody know what's wrong here? what should i do? thx
So after a few hours of banging my head against my computer, here I am. :) Backstory: A few weeks ago I installed web matrix and MSDE Rel A so I could create some .NET pages from my local machine, connect to a remote SQL Server 2000 database, and then post the .NET pages on the web server. All went well, I could connect to the datasource it brought up the table column names, everything was perfectly working (should've been my first hint to leave well enough alone). Well today, I think, "hey you know I want to give this new Visual Studio 2005 Express Edition a try". So I install it. I thought that if web matrix was that simple to connect, create and post "surely" VSE would be too, but with more features. I also read how I should go ahead and install SQL Server express and SQL Server Managment Studio Express, so I did. So I go to create a datasource in VSE, but VSE had other plans. An error message popped up. Something to the effect, "An error has occured while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be cuased by the fact that under the default settings SQL Server does not allow remote connections..." I noticed that it said something about SQL Server 2005 so I figured I'd need to change that so I used the Microsoft SQL Server (OLE DB). It returned the error "[DBNETLIB][ConnectionOpen(Connect()).]SQL Server does not exist or access denied". I flipped back over to web matrix and now it doesn't work either. I have tried referencing the server by servernamedb_name and ip address as well. All result in the same. Any thoughts on how to get me going?
How can I create a OLEDB connection parameter that would ask the user to enter the server name when the package is executed?
I have a ssis package that import/export data. I want this package to do that without hard coding the server name. Thus, the package will needs to ask the user to enter the server name for source and destination and then import/export data.
Hello, I am trying to connect a web app to a SQL 2005 that is behind a firewall. The challenge is this, the SQL is behind a firewall and the webserver is at a different location. From my desktop development environment, I connect through a VPN first and then can point to the internal IP of the DB server. This works fine as long as the VPN is connected. But how do I do this from a hosted web application that is not on my local machine or using my VPN? Is there some sort of tunneling Connection that I can use within code? thanks
Hi, I am new to the whole concept of ASP.NET and codebehind (i am using c# and i am also new to that) i currently trying to get my codebehind to connect to a SQL Server express 2005 database on page load however i am getting this error thrown back at me when i run the aspx page on my localhost, Cannot open database "db_revival" requested by the login. The login failed.Login failed for user '12042HOPEASPNET'. 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: Cannot open database "db_revival" requested by the login. The login failed.Login failed for user '12042HOPEASPNET'.Source Error:
Line 18: { Line 19: SqlConnection conn = new SqlConnection(@"Data Source=12042HOPESQLEXPRESS;Initial Catalog=db_revival;Integrated Security=True"); Line 20: conn.Open(); Line 21: Line 22: } Source File: g:Level HRevivalDefault.aspx.cs Line: 20 i believe it has something to do with the conn.Open() funtion or the connection string it's self the acutal full code is here, using System; 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.Data.SqlClient; using System.Data.Sql;public partial class _Default : System.Web.UI.Page {protected void Page_Load(object sender, EventArgs e) {SqlConnection conn = new SqlConnection(@"Data Source=12042HOPESQLEXPRESS;Initial Catalog=db_revival;Integrated Security=True"); conn.Open();
} secondly once i get the connection working i want t be able to check a user email and password against those in a table to allow the log in, through my experience with PHP i would of done this by putting what the user entered into a variable and then checking the variables against an sql query, how do i go about this with aspx and C# my textfield is called uname and my passsword is call pword. Any help of example code would be greatly appreciated.
Please I need some help here in sorting a problem with collection and VB code below. Basically, I would like to display reminders from the database to the screen via messageboxes when the user clicks Button1, as long as the time and date has been reached.
But when I click on Button1 (see code below), I am not getting any output whatsoever. Do anybody know how to help?
Code Snippet Public Class Form1
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
If con.State = ConnectionState.Open Then con.Close() con.Open() cmd = New SqlCommand("SELECT REM_NOTE, REM_DATE FROM dbo.MY_CONTACTS Where REM_STATUS = 'True'", con)
Dim sdr As SqlDataReader = cmd.ExecuteReader While sdr.HasRows = True
Dim newAlert As New Alert(Reminder_data_reader("REM_NOTE").ToString(), DateTime.Parse(Reminder_data_reader("REM_DATE").ToString())) Me.collectionOfAlerts.Add(newAlert)
I just installed the Microsoft SQL Server 2005 data mining add-ins and tried to configure it without succes. I wanted to connect to my server database so I entered the servers name. I was never asked for my username and password, Windows authentication was assumed and I was told I could not access the server. I tested it in Management Studio and was able to connect. I then tried localhost and was told I did not have adminstrative priveledges on localhost.
I need to connect Mysql database and get max(date) field from a table and store it in a variable OR if I can do it in Data flow then just to check the date with condition transform and move on...
I have installed mysql odbc. I have also made a odbc connection on conenction managers. looks ok...
I have tried Execute Task on Workflow but didnt work , Also tried datareader source connectiong mysql didnt work either
With Execute task I am getting ; [Execute SQL Task] Error: An error occurred while assigning a value to variable "Variable": "Value does not fall within the expected range.".
With Datareader source in data flow I am getting : Error at data flow task : Cannot acquire a managed connection from run time connection manager...
I have a package that uses a for loop to iterate through an unknown amount of excel files and pull their data into a table. However, there will be cases when the file is corrupted or has some sort of problem so that either the transformation will fail or the excel data source will fail with an oledb connection error. Could anyone suggest a clean way to trap these errors? Specifically, the "Cannot Aquire Connection from Connection Manager", which is the excel connection.
we have Sql Server 2000 and Sql Server 2005 IN A SINGLE MACHINE. when connecting with data base Sql Server 2000 with asp.net 2.0 application ,an error occur "Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding." can anyone suggest any idea to solve this problem... thanking u.
Using the DTS Wizard, on the Choose a Data Source screen, I pick the following:
Data Source: Microsoft ODBC Drive for Oracle Server: Username: Password:
I don't know what I should put into the other fields, given what I have above, i.e. what to put in for Server, Username, and Password! Or should I use a different procedure to import this Oracle data? I am almost positive I was not supplied the username/password. I was told I could connect given the above TNS information. What do you all recommned?
I'm coming from ASP and I used to have a global connection string accessible to all of my ASP pages that I'd use for all of my data access. This was really convenient because I could easily switch to a backup or local data source for testing/debug by changing the connection string in one place.
Now, I'm using ASP.NET with Web Matrix and I love the drag and drop functionality but its dropping my connection string all over the place. How can I do this and keep my connection string in one spot so I can have the same convenience of switching data sources.
I have asp code that uses C# to create a SQL connection and a command. Then I create a data set and fill the data set using my comand. Finally I bind my data set to a data grid named myDataGrid. I am not sure where myDataGrid comes from since it is never defined. Where does myDataGrid come from? Also, I believe that I do not need to call page_Load since auto wire is set to true by default so it is my understanding that this method page_Load will be called by default.void page_load(object sender, EventArgs e) { SqlConnection myConnection = new SqlConnection("server='(local)'; trusted_connection=true; database='mattsDEMO'"); SqlDataAdapter myCommand = new SqlDataAdapter("select * from people", myConnection); DataSet ds = new DataSet(); myCommand.Fill(ds, "people"); MyDataGrid.DataSource=ds.Tables["people"].DefaultView; MyDataGrid.DataBind(); }
When I place a data grid controll on my page named myDataGrid, I do not see a data grid and there is no data either. The code in the HTML looks like this:
<body> <form runat="server"> <p> <asp:DataGrid id="myDataGrid" runat="server" BorderColor="Maroon"></asp:DataGrid> </p> </form></body>I tried using debug that comes with the .Net framework (since I am using Web Matrix) but I get an error saying no symbols were found for this document when setting break points. What are symbols and why do I need them?So, I basically have four (4) important questions that I need help answering: 1) Why do I not have any data in my data grid? 2) Where did myDataGrid come from? 3) Is the page_Load method called by default if auto wire is set to true or not declared? 4) Why do I need symbols for debug?Below is all my code in one complete view:<%@ Page Language="C#" %><%@ Register TagPrefix="wmx" Namespace="Microsoft.Matrix.Framework.Web.UI" Assembly="Microsoft.Matrix.Framework, Version=0.6.0.0, Culture=neutral, PublicKeyToken=6f763c9966660626" %><%@ import Namespace="System.Data" %><%@ import Namespace="System.Data.SqlClient" %><script runat="server"> // Insert page code here // </script><html><head> <script language="C#">void page_load(object sender, EventArgs e){SqlConnection myConnection = new SqlConnection("server='(local)'; trusted_connection=true; database='mattsDEMO'");SqlDataAdapter myCommand = new SqlDataAdapter("select * from people", myConnection); DataSet ds = new DataSet();myCommand.Fill(ds, "people"); MyDataGrid.DataSource=ds.Tables["people"].DefaultView;MyDataGrid.DataBind();} </script></head><body> <form runat="server"> <p> </p> <p> <asp:Label id="Label1" runat="server">This is a test!</asp:Label> </p> <p> <asp:DataGrid id="myDataGrid" runat="server" BorderColor="Maroon"></asp:DataGrid> </p> </form></body></html>Thanks,Ryan
Yesterday, one of the computers on the network of our SQL server experienced a connection failure while using two specific jobs in a table containing assignments for jobs. The data interaction occurs from a Data Access Page, and from what I've learned, the nature of a DAP is such that the client not only connects to the web server but actually also establishes a direct connection to the SQL Server (we use a backend of MS SQL Server 2003). The data is still inside the tables, but on the Data Access Page, any data that was opened during the connection failure does not show up anymore from any computer.
My guess is that there was corruption of some sort on another layer beneath the actual data layer that cannot be accessed directly or viewed. To remedy this problem, I am going to try to recreate all affected records and rebuild all table ID ties manually with append and update queries. Does anyone know the actual problem or corruption that occurs during a connection failure? Is there a way to access the affected layer(s) and undo the corruption or remedy the affect so the records can be used? Is the problem with the SQL Data itself or on a layer with MS Access/MS DAP?
This data is very important and needs to be used today and was supposed to be used yesterday. If anyone could help me in this matter or provide a better way to undo the supposed corruption, it would be greatly appreciated :)!
thanks in advance, mellamokb
PS - I don't know if this makes a difference, but other data has been changed in the same database/tables since the connection failure, so a complete reversion back to the system at that point in time would mean loss of other updated data.
