Hi,
I'm interested in how asp.net application communicates with MS SQL database. I mean, is communication encrypted or can it be? I have scenario where database and web application will communicate over Internet, they are not in the local network.
Please share your opinions.
Can any body please explain that "how does the Report Builder application communicates with the reporting server".
Does it use web service for that, or does it connect to it directly ?
If it use webservice then where is it situated and what is it's name.
Please explain a bit ?
Hai All ,
Iam having the one Application in DotNet2005.But iam using the two database(SqlServer2005).If user's login the application it will check credentials in first database, if he is not having the login credentials it will cheek the second Database. How can I handle in the configuration file?. How can I change the connection string depending upon the Database in my application for database operation (like insert and update).Any one kindly provide the solution.Thanks and regards,sureshK
Dear all
I am a pretty new in the development world fresh from uni. I am doing development on a system that has a security database. Access to the data in that database is pretty important. So in case the main server where the database is stored for soem reason fails or gets compromised i need to have a second copy with the most recent data in that database and keep the application up and running. The data i have is stored in a SQL 2005 database. What are the recomended aproaches for acheiving this needed reliability?
Would running the SQL Agent every 2 minutes do the trick? And replicate the database to another server and then have asecondary deployment on that server running as a backup? Or are there any other means?
Any advice is apreciated.
Sincerely
I was all set to build some triggers on some modified date tables when in the last minute I found out that the application (built in C#) was controlling the after update trigger.
Is there a tool you can use in SSMS to see if there is a connection set up like this?
I have a vb application that uses sql server database , I want to move from sql server to msde file , wanna be able to attach msde file with vb app ,and run setup program
It looks like there is not much good info how to start with it
can anyone guide me ?
Thanks
hi
i m making a win application
for which i have used sql server 2005 .i faced a very big problem that i have made the database but i cannot able to connect the database with winn application .for this purpose i ned coding.so please help me.i need your help urgent.
sheraz
How can distribute an SQL database with my application in VB, does clickOnce may me do that? Should the final consumer install SQL Express Before installing my application. Can I create a unique package which may me do that?...
View 1 Replies View RelatedHello,
We just converted one of our commercial applications over to using SQL Server. We have a database that is about 700megs in size, what I want to know is how is one suppose to actually deploy a database in an automated install? I have created T-SQL insert scripts, but it is 764M in size, and it takes forever to read the script in to send to the SQL Server. So I am looking for suggestions on how to actually do this.
Thanks
Bern
Hey guys,
I'm really new to this so this might look dumb, but I need to know what all has to be done to develop a standalone database application.....The frontend is going to be on VC++...which are the best tools I'll need to use. I need to know if the user has to install the database app to use the program to make this possible......Also will he have to keep it running everytime to use the program.
Thanks a lot for you time and patience,
Dhaval
I added a database named appdata to the app_data folder to hold temporary application data. I want to show this data in a report. I created a dataset and an object to select the data. I then created an report.fdlc and a report.aspx with a ReportViewer on it pointing to the dataset object. If I right click on the report.aspx and View in Browser, it work perfectly. But when I upload it to the server I get and browse to it I get (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified). The server does allow remote connections. So I am thinking it's my connection string of the fact that the server doesn't have Sql Server Express.?
Here's my connection string. What am I missing here?
<add name="appdataConnectionString"
connectionString="Data Source=.SQLEXPRESS;AttachDbFilename=|DataDirectory|appdata.mdf;Integrated Security=True;User Instance=True"
providerName="System.Data.SqlClient" />
Hi All, I will shortly (hopefully) begin devleoping an ASP.Net web application to let users manage a remote sql server 2005 database (kind of like the php myAdmin tool for MySQL databases). Were not talking a server managament tool for DBAs, more an end user tool for managing personal databases (it seems that web hosting companies provide tools for MySQL, but if you use SQL Server, you're stuck unless you have management tools on your PC - and what about mac users?).Given that premise, what features should i attempt to include? Creating and modifying tables structures and data is an obvious inclusion, but what else? I also haven't yet decided whether to go about this using scripts or using SMO. I've read that SMO is backwards compatible across versions of SQL Server...how true is this? are there issues or is it seamless? Please post any comments or thoughts you have, and thanks for taking the time.
View 4 Replies View RelatedI have tried to find all the threads related to this topic. At this point I would like to find out what the best practices are for doing this. I plan to use Membership, Roles, and the login controls to handle my authentication and permissions issues. I want to use the same database for my application data as for Application Services, using a standard SQL Server. So far, the easiest way to set this up that I can think of is to:1. Use aspnet_regsql.exe to create the Application Services Database schema2. Edit the "LocalSqlServer" entry in <connectionStrings> to point to the above database3. Add the tables, views, stored procedures, etc., that I need for my application into the database created in step 1Is there any more configuration I need to do to get Membership and Roles working? When I did the Walkthrough, step 2 seemed to be the only requirement for getting Membership and Roles to work.Will I run into any trouble using LocalSqlServer for my application data updates?I would be interested in any other approaches to setting up a combined database, including opinions why and why not to do it.
View 1 Replies View RelatedHi there,
Has anyone ever encountered problems making .Net applications connect to a SQL database on SQL 2000 with SP3a?
It's running on a virtual machine with a Windows Server 2000 Std with SP4, the .Net application is working with .Net Framework 1.1.4322.573. For some reason it can't connect to the SQL database using the specified username and password in the web.config file even though the user exists in the SQL database. I've tried using the SA password but this still doesn't work. I can logon to SQL Query Analyzer using the SA password but not using the other username.
The .Net application does work on other systems of mine all of which can run on Windows Server 2000 and 2003, I have compared them but can't find any differences.
Any ideas anybody?
Thanks,
Chris
I got problem connecting database to my asp application (in teh code of sign up button)
here's the code
SqlConnection con = new SqlConnection();con.ConnectionString = ConfigurationManager.ConnectionStrings["connectionString"].ConnectionString;
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
cmd.CommandText = "INSERT INTO Students (FirstName,LastName,Address,Birth_Day,Birth_month,Birth_year,Country,User_Name,Password,SecretQuestion,Answer,E_mail,Grade,Dep_Name) VALUES (@FirstName,@LastName,@Address,@Birth_Day,@Birth_month,@Birth_year,@Country,@User_Name,@Password,@SecretQuestion,@Answer,@E_mail,@Grade,@Dep_Name)";string firstname = this.FirstName.Text;
string lastname = this.LastName.Text;string address = this.Address.Text;
int bd = int.Parse(this.Birth_Day.Text);string bm = this.Birth_month.Text;
int by = int.Parse(this.Birth_year.Text);string cntry = this.Country.Text;
string UN = this.User_Name.Text;string pw = this.Password.Text;
string SQ = this.SecretQuestion.Text;string ans = this.Answer.Text;
string em = this.E_mail.Text;string grd = this.Grade.Text;
string dep = this.Dep_Name.Text;cmd.Parameters.AddWithValue("@FirstName", firstname);
cmd.Parameters.AddWithValue("@LastName", lastname);cmd.Parameters.AddWithValue("@Address", address);
cmd.Parameters.AddWithValue("@Birth_Day", bd);cmd.Parameters.AddWithValue("@Birth_month", bm);
cmd.Parameters.AddWithValue("@Birth_year", by);cmd.Parameters.AddWithValue("@Country", cntry);
cmd.Parameters.AddWithValue("@User_Name", UN);cmd.Parameters.AddWithValue("@Password", pw);
cmd.Parameters.AddWithValue("@SecretQuestion", SQ);cmd.Parameters.AddWithValue("@Answer", ans);
cmd.Parameters.AddWithValue("@E_mail", em);cmd.Parameters.AddWithValue("@Grade", grd);cmd.Parameters.AddWithValue("@Dep_Name", dep);
con.Open();
cmd.ExecuteNonQuery(); // the error appears here
con.Close();
could anyone Help me urgently???
Hello,
I was wondering if someone could help me answer this question.
If I had a site like Yahoo, that constantly had users accessing it. Would it be a good or bad idea to automatically open a database connection to SQL Server on Application Start? What would you recommend? Would opening and closing the DB connection on every page save alot of overhead and bottleneck? Thank You.
hi
i want to develop a web application that use SQL Server Database, i have installed SQL Server & VS.NET in my local computer and i'm ready to develop, but before getting started, i want to know how i will upload mydatabae in my host,
actually i want to know should i know the settings & properties of my host that support SQL Server, or without know them i can devekop my apploication and after developing localy with just a few tasks upload my ( Sql Server) database?????
i'm worry actually about this, plz say what you know about this.
thanks
Hi,
I have a problem connecting to database using windows authorization.
this is sample codeSqlConnection oSQLConn = new SqlConnection();oSQLConn.ConnectionString="integrated security=SSPI;Server=SHAREPOINT\EPM;Database=STS_sharepoint_1;Trusted_Connection=true;";oSQLConn.Open(); on Windows Aplication it work good but on ASP.NET Web application I got an Server Error - Login failed for user *****************is it problem with IIS configuration???
helloi have to make helpdesk application for teh IT Department of my company,so if anyone can help by supporting me by database schema for HelpDesk application.thank you for the help
View 1 Replies View RelatedI know how to create an Application role in SQL server 7. Now how do I connect to the database from VB using that Application Role? I can't find anything about this topic anywhere. Is this the purpose of an Application role or am I way off?
Thanks for the help
Steven Abt
StevenA@grsgroup.com
On the Enterprise Manager of the MS-SQL server, how do I find or see the database index in there? Both that was done by SQL query or Stored Procedure?
Thanks...
Looking for a consultant with solid experience in application anddatabase security for a project in the GTA.CONTACT---------------------------------------------------Please send your resume to:Join Bytes!
View 1 Replies View RelatedI inherited an existing database application about 6 months ago. I'vefinished converting it to use SQL Server 2000 as the backend (MS Access2002 frontend w/ Userforms+VBA code pointing to the backend).In its current state the application makes use of a ton of embedded SQLstatements and I'm thinking about the best way to clean this up. Itseems like the best way would probably to encapsulate each of the SQLstatements into its own stored proc and then have the MS Accessapplication call the sp. However, this would result in a very largenumber of stored procedures.Anyone have any links or suggestions regarding best practices onremoving embedded SQL scattered throughout a DB app? Thanks.
View 1 Replies View RelatedI have the need to restore a database to a user's laptop on a dailybasis. This has been no problem using Enterprise Manager. I found astored procedure to run the restore and tried to call it from a visualbasic program. While I can connect to the database, I get an errortelling me "exclusive access could not be obtained because thedatabase is in use".Does this mean the only way to run the restore is via EnterpriseManager?Thanks,Tom
View 1 Replies View RelatedI have been building ASP, ASP.NET and Crystal Reports on SQL serverfor a few years now.I have build them mostly on an Intranet or with companies that havetheir own web servers.I now need to build an application for a company that doesn't not havea web server. Just a small shop that wants an internet application.How do I build an database application when the site will be host byan ISP? The database will be SQL Server 2000, but located locally.The site will be maintained by the ISP? How does the an applicationhosted by an ISP interact with a database located locally (client'ssite)?If someone could point me toward some tutorial or tell me how to dothis, I would appreciate it.
View 1 Replies View RelatedI am thinking of using my web database as the database to use for my program, though not sure how feasible due to connection speeds and having to transfer that info.
what I am using as the connection string is
con.ConnectionString = "Data Source=databse ipadress inserted here; Initial Catalog=databasename here;Integrated Security=True"; with real data obviously inserted into the ip and tables, but when i try and send values there it just hangs and then crashes. I am thinking its not finding the database. Is there something else im to do?
I am using the exact same code as when i use my own machine as the server, and it works great that way, only thing different is the trying to send to the web server.
Hi,
I tried to create a simple application based on the Sql Server CE samples and, as is typical when I play with databases, the program failed. In this case it failed to even load. The program has a form and a data source that I dropped onto the form. When I run the program the program breaks at this line:
Code Snippetthis._connection = new global::System.Data.SqlServerCe.SqlCeConnection();
The error is:
An unhandled exception of type 'System.DllNotFoundException' occurred in System.Data.SqlServerCe.dll
Additional information: Unable to load DLL 'sqlceme35.dll': The specified module could not be found. (Exception from HRESULT: 0x8007007E)
My first attempt at 'fixing' this was simply to copy the requisite DLLs to my bindebug folder. I found the DLLs here:
C:Program Files (x86)Microsoft SQL Server Compact Editionv3.5 and copied these - sqlcecompact35.dll, sqlceca35.dll, sqlceme35.dll, sqlceoledb35.dll, sqlceqp35.dll and sqlcese35.dll, sqlceer35EN.dll - to my bindebug folder.
Now instead of the first error, I get this error:
An unhandled exception of type 'System.BadImageFormatException' occurred in System.Data.SqlServerCe.dll
Additional information: An attempt was made to load a program with an incorrect format. (Exception from HRESULT: 0x8007000B)
I am running Vista Business (x64) and using (the desktop version of) Sql Server Compact Edition 3.5 with Visual Studio 2008 Standard Edition. The test 'program' is written in C#. (Incidentally I can play with the database with no problems in Visual Studio 2008's server explorer. I can look at data, add data, etc.)
Can anyone please help?
Thanks.
Hello.
I have my database and client application. I want my application to know (and to do certain things) when something has happened to a database (for example a row has been inserted). By means of what can it be done??I hope this forum is right place to ask such questions. Thanks for replies!
Hi all...
I am writing a Windows Application which will be used by about 100 clients. (NT Authenticated)
The application is going to be used in a LAN enviroment. User who have access will download a VB.NET application from a web site.
Of course, I want to prevent any of the 100 users from using a tool such as Query Analysis or ODBC to connect directly to the database and modify data.
So, it appears the way to go is to the "Application Roles". For this to work, the application roll password has to be saved in the application to execute the sp_setapprole procedure.
Is there a way to secure this password? I am worried about a user somehow extracting the password from the application and connecting directly.
Am I on the right track here? Any ideas appreciated!
Thanks,
Forch
I'm trying to connect to a sql express database on my local machine, using the following connection string:
SqlConnection thisConnection = new SqlConnection(@"Data Source=C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDataTest.mdf");
However, I keep getting an error message saying "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."
Why would my application be trying to connect remotely when the database is on my local machine? And how can I fix this problem?
Thanks
I created a little test application with SQL server. After everything was tested successfully I builded a setup file with Installshield. I installed the setup file on a different mashine. Everything runs without problems, but when I make entries to the database and I reopen the application no entry is saved. I am new to SQL server.
thx for any help
Hi
I am nearing the end of creating my Windows App for work. So I tried to publish it, that was fine until I ran the app, from the same PC as I use to develop, with the same login etc. However when I use the published app I can't connect, to the database, return to VS2005 and run my app from within there and no problems. It is SQLEXPRESS (SQL Server 2005), but I have checked the settings there are correct (I assume VS wouldn't connect otherwise).
Help please.
Details...
Server = FRED database =Joe
Connection string (Data Source=FREDSQLEXPRESS;Initial Catalog=JOE;Integrated Security=True
Server (Win2003) and my PC (Win2K) are on the same domain
Using TCP/IP
I can't see how to enable JiT debugging despite the 'help' at the end of this error details...
See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.
************** Exception Text **************
System.Data.SqlClient.SqlException: 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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Connect(Boolean& useFailoverPartner, Boolean& failoverDemandDone, String host, String failoverPartner, String protocol, SqlInternalConnectionTds connHandler, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject, Boolean aliasLookup)
at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)
at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)
at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
at System.Data.SqlClient.SqlConnection.Open()
at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable)
at TrainTrack.frmAddCompetency.frmAddCompetency_Load(Object sender, EventArgs e)
at System.Windows.Forms.Form.OnLoad(EventArgs e)
at System.Windows.Forms.Form.OnCreateControl()
at System.Windows.Forms.Control.CreateControl(Boolean fIgnoreVisible)
at System.Windows.Forms.Control.CreateControl()
at System.Windows.Forms.Control.WmShowWindow(Message& m)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ScrollableControl.WndProc(Message& m)
at System.Windows.Forms.ContainerControl.WndProc(Message& m)
at System.Windows.Forms.Form.WmShowWindow(Message& m)
at System.Windows.Forms.Form.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
************** Loaded Assemblies **************
mscorlib
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINNT/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
----------------------------------------
TrainTrack
Assembly Version: 1.0.0.0
Win32 Version: 1.0.0.0
CodeBase: file:///C:/Documents%20and%20Settings/graham.yetton/Local%20Settings/Apps/2.0/4GZWZKGB.4O3/9XXGWKLB.MTQ/trai..tion_75116344273b6719_0001.0000_b44ce39f580948f8/TrainTrack.exe
----------------------------------------
System.Windows.Forms
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINNT/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
----------------------------------------
System
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINNT/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
System.Drawing
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINNT/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
----------------------------------------
System.Configuration
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINNT/assembly/GAC_MSIL/System.Configuration/2.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
----------------------------------------
System.Xml
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINNT/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll
----------------------------------------
System.Data
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINNT/assembly/GAC_32/System.Data/2.0.0.0__b77a5c561934e089/System.Data.dll
----------------------------------------
System.Transactions
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINNT/assembly/GAC_32/System.Transactions/2.0.0.0__b77a5c561934e089/System.Transactions.dll
----------------------------------------
System.EnterpriseServices
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINNT/assembly/GAC_32/System.EnterpriseServices/2.0.0.0__b03f5f7f11d50a3a/System.EnterpriseServices.dll
----------------------------------------
************** JIT Debugging **************
To enable just-in-time (JIT) debugging, the .config file for this
application or computer (machine.config) must have the
jitDebugging value set in the system.windows.forms section.
The application must also be compiled with debugging
enabled.
For example:
<configuration>
<system.windows.forms jitDebugging="true" />
</configuration>
When JIT debugging is enabled, any unhandled exception
will be sent to the JIT debugger registered on the computer
rather than be handled by this dialog box.
Dear All,
I am trying to build a simple mobile application. I am very new to this. Thus I am trying to access the build in database in the folder C:Program FilesMicrosoft SQL Server 2005 Mobile EditionDeviceMobilev3.0Northwind.sdf. I am following the steps in the wizard to help me. When I press test connection is say Test Connection Succeeded. But when I press the ok button I get this error as "Unable to find the requested .Net Framework Data Provider. It may not be installed". I am running VS 2005. Can anyone pls help ?