in create a new software application using C# as front end and database with sql. how to connect SQL server with my front end application.dot net training in chennai <a href="http://www.fita.in/dot-net-training-in-chennai/">Dot Net Training in Chennai</a>
View 2 Replies4 Layered Web Application for Inserting data into a database using sql server as the back end and a web form as the front end using C# .
Can someone provide with code as I am new to this architecture and framework.
Better send email.
Thanks In Advance,
A New Bie
Hi,
I'd like to get some help on this. I'm new to SQL Server but am keen to learn it. I have SQL Server 2000 SP4 running and wonder what kind of front end application is best suited for SQL Server 2000.
Thank you in advance
Hi All,
From front end application, I execute a SQL
`exec sp_password oldpassword,newpassword
and I got error message :
"Error code# 15002 :[Visigenics] [ODBC MS
SQL Server 6 Driver] [MS SQL Server]
The procedure `sp_password` cannot be
executed from within a transaction.".
If I logged in directly to SQL 6.5 without going
thru the front-end application then I could
change password successfully.
Has anyone tried to change password FROM
a front-end application? Our shop uses
Omnis 7.3.6 as front end and SQL 6.5 as back
end. TIA.
David Nguyen
there is a Crystal Report run from the Front end Application. The DB used here is SQL Server 2008. I need to know the Stored Procedure used by the report that is been run from the front end. . How shall I do it?
View 6 Replies View RelatedI have an application that uses Acces as a backend and VBA as front end. Application is secured and is supplied on a CD with setup.exe.
Can I use VB 2005 and MS SQL to achieve the same?
Would I be able to package my application with all the neccessery files (assuming that client does not have any e.g. SQL server) so that multiple front ends can access data from common source?
Would I be able to secure such an application using only VS 2005?
What would I need to quickly learn how to achieve the above ( any books you can suggest maybe)?
Hi there,I sincerely hope that someone out there can help. I have twoinstances of the SQL 2000 Desktop Engine running. One is on my localmachine for development and the other is on another machine on ournetwork which is the production environment. I have built an Access2003 front end application which connects to this database. Thisworks fine locally, as you would expect. I successfully installed thedatabase on the production machine and am able to connect to it viaAccess 2003 (using the Data Link Properties window) and from thirdparty database manager software (similar to Enterprise Manager). I amnot able to to connect to the database via my application.I am using the "sa" account with a strong password. This is myconnection string:strConnection = "Provider=sqloledb;DataSource=server02;UserId=sa;Password=strong;Initial Catalog=Test"The error I'm getting is:"Connection cannot be used to perform this operation. It is eitherclosed or invalid in this context."The connection string is the only thing that changes in my code when Iswitch from my local to my production database. Is there some reasonthat I can't use the "sa" account in this fashion that I'm not awareof? I'd rather not use integrated security for simplicity's sake asthis is a small, internal application. Also, I would have thoughtthat if that was the issue, I couldn't use "sa" at all, even locally.I'm going to post to the Access group as well but thought someone heremight have some advice to offer as well.Thanks,Barb
View 2 Replies View RelatedHi
I developped an ASP.Net application (with Web Dev Express ) wich attempt to connect to SQL Server Express (installed in the local machine) using Windows authentication.When i launch my application within Web Dev or from IE navigator i receive the following error message : Cannot open the database 'MyDB' login failed for user ServerNameASPNet.I use SQL Server Management Studio Express to give the user ServerNameAspNet permission to connet to the database but i still receive the same error message.I created a user with strong password within Management Studio with connect permission and attempt to connect from my application using SQL Server authentication i receive the error message : The user 'UserName' is not associated with a trusted connection for SQL Server.Note that when i use the Connect to Database tool in Visual web dev the connection success when i use Windows authentication but fails when i use SQL Server authentication with the same error message above.My OS is WXP Pro SP2
Thanks for any help
I am having a strange problem. I have an application that to connects to SQL Database in SQL Server 2005.
When I run the application with Visual Studio everything works fine but when I deploy the application on my web server and then to access the site .
I get an error : Login failed for user ''. The user is not associated with a trusted SQL Server connection.
For some reason the application is not passing the user name . I have checked the IIS and authentication is set to Integrated Windows Authentication .
My connection string is correct as well
<add name="xxxxx" connectionString="Data Source=xxxxxx;Initial Catalog=xxxx;Integrated Security=SSPI" providerName="System.Data.SqlClient"/>
I will appreciate any kind of assistance in this matter. Thanks
Hi!I am going to connect to "SQL Server 2000" through an "ASP.NET Web Application". My development environment is "Visual Studio .NET 2003". In my "Toolbox" -> "Data", I drag a "SqlConnection" and drop on the page. It would automatically be named "SqlConnection1". In its "Properties" -> "ConnectionString" -> "<New Connection...>", I would enter my Server Name (SAMIEI), select "Use Windows NT Integrated Security" and Select the Database on the Server (Northwind). Then such Connection String would automatically be generated:
"workstation id=SAMIEI;packet size=4096;integrated security=SSPI;data source=SAMIEI;persist security info=False;initial catalog=Northwind"
Now, I may see "SAMIEI.Northwind.dbo" in the "Data Connections" row of "Server Explorer" with its all "Database Diagrams", "Tables", "Views", "Stored Procedures" and "Functions".Please take a look at the following code:
Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Try SqlConnection1.Open() Catch ex As SqlException Response.Write(ex.Message) End Try
End Sub
It would unexceptedly encounter such error:
"Login failed for user 'NT AUTHORITYNETWORK SERVICE'"
Please tell me the reason. I am much obliged to you for your attention.
Regards!M.Sadegh Samiei
Hi
I can't connect to sql server 2005 from my asp.net web page. I seem to be able to connect to it when i run the application from within visual studio but i can't connect to it when i run the application from IIS.I am new to sql server 2005 express so please bear with me.The error message i get is: Cannot open database "Vets" requested by the login. The login failed.Login failed for user 'OSCAR2K4ASPNET'.I don't know where this user OSCAR2K4ASPNET came from but i looked in sql server 2005 and there he is. In the left hand pane I went to Security and then logins and found oscar2k4asp.net there. I went to the properties for this user and went to User Mappings. There was no tick next to my Vets database so I added one and ran the application from IIS. I also added the user to every single role in the vets database (including dbowner). I also went into the vets database itself and found the oscar/aspnet user and made sure he was added to every role.
I ran the application again. This time i got a lots of different errors. If the page was trying to run a select procedure I got the error user does not have select permission. If the page was running an SP i got the error or user does not execute permission
I have never had this problem before so I don't understand.Where did this user come from? Was he created automatically when i configured my database for membership and roles? How do i set up this user so he can access the databsae from IIS.
The only way I could get the application to run from IIS was to go to Security - Logins for sql server and add the oscar2k4asp.net user to the sysadmin role.
I find this very strange. Naturally i don't want to leave oscar2k4 in sysadmin.
Please help :) I can't upload my website until i fix this
Thanks, andrea
All,
I'm a newbie here so forgive me if I have missed something completely obvious.
I have bought a shopping cart script of a well known company (Evolve Merchant 5) and I wish to set it up locally on my development server, I created a virtual directory, set the web application up and get the asp pages to display perfectly. However, in the configuration file (global.asa & web.config) for the application it reguests information to be provided: <add key="DBName" value="Database name" />
<add key="DBServer" value="IP address of server" />
<add key="DBUserName" value="User name" />
<add key="DBPassword" value="password" />
<add key="AltPassword" value="password" />
What I can't determine is what the SQL Server 2005's IP address is? the pages of this application show when I type http://localhost/catalogue into IE, so I presumed the server address would be the IP of localhost, when typed ping localhost into command promt it gives me 127.0.0.1, but when I enter this into the config file and try to load the application it just hangs and then eventually says:
"Microsoft OLE DB Provider for ODBC Drivers (0x80004005)[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied./catalogue/global.asa, line 54"
I have created a new database in SQL Express called: merchant509 and restored the tables to it as the manufactures help files state, I created a new login called shop which uses SQl authentication, so as I can provide a password. So the settings should look like this:
<add key="DBName" value="Database name" />
<add key="DBServer" value="127.0.0.1" />
<add key="DBUserName" value="shop" />
<add key="DBPassword" value="1684" />
<add key="AltPassword" value="1684" />
But it doesn't work, does anyone know what i have done wrong?? the SQL server is runnign on the same computer as I am trying to access it from, it is set to accept all forms of comunication i.e. TCP/IP etc.. in the server configuration manager the IP address part of TCP/IP in protocols shows IP1 as 192.168.2.2 active yes enabled yes, and IP2 as 127.0.0.1 active yes and enables yes, I have tried the 192.168.2.2 and this gives the same errors, this is my registed IP on my home network.
I'm now stumped, I haven't a clue what else I can try, I would be very greatfull if anyone has any ideas.
Regards,
Daniel Coates
Hi,
We recently installed Sql 2005 server and it was working fine. But today one of our user reported that they could not able to connect the sql server 2005 from the application. When I checked the error log, I found the following error for every one minute. We restarted the sql service on this sql 2005 instance but still we are getting the same error.
SSPI handshake failed with error code 0x80090311 while establishing a connection with integrated security; the connection has been closed.
Could any one help us on that?
Regards,
Sankar
OK, I am not a programmer, but administrate the Report Server and its security. The .NET programmers want to connect direct to Report Server using WEB.CONFIG settings (see below).
<appSettings>
<add key="ConnectionString" value="Server=bpatlqddwatlqddw01;Database=MP2_NET_STAGE;Integrated Security=False;User ID=MP2_Net;Password=xxxxx;Persist Security Info=false"/>
<add key="LogPath" value="\bpga030wde01wwwroot$MP2_NetLogs"/>
<add key="Url" value="http://bpga030wde01/MP2_Net/" />
What do I need to do to ensure their dynamic reports can run against my Report Server? What kind of rights do I assign the "MP2_Net" (above) login? All of this is outside the IIS-Report Server security environment? Do I assign rights via SQL Mgr? I cannot find any doco on this process.
Hi,
I am having a problem connecting my .net applications from the application server to the database server. When I run the application from my windows xp (sp2) box it works fine. When I try to connect via SQL Management Studio to the database server from the application server I get the same error.
Here is the error:
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)
Here is the Environment:
App Server:
Windows Server 2003 Standard Edition
Inside Company's Firewall/ Network
Database Server:
Windows Server 2000 Advanced Edition
SQL Server 2000 SP4
Remote Connections to the Server is checked
Enable Protocols: Named Pipes & TCP/IP
TCP/IP Port: 1402 (I don't know why it isn't the default of 1433)
The db server is sitting out side the Company's firewall (don't ask me why). I can access it fine from inside the firewall on my XP box but not from windows server 2003. There is a web server outside the our network that also connects to the db server with no problem and that is running Windows Server 2003 Web Edition.
I can ping the db server from the app server using the IP address.
I tried using the IP address and the port 1402 in my connection string but that didn't work from any machine (XP and Server).
I imagine the issue is somehow related to the company's firewall but why would it only block Windows Server 2003 and not XP?
What do I tell the network admin to change?
Any help would be appreciated.
Thanks,
Oran
How to connect to SQL server database from Oracle 9ias Application Server (9.0.3) & Test & Verify the Connection. Is it posible.
View 1 Replies View RelatedHello, we have the hosting account with GoDaddy Server. We have using Visualstudio.net and MSSSQL Server 2005.
For hosting the files for the remote server ( Godaddy ) we are using FTP Cute client to upload the files. For Uploading a database they given a seperate login and we are hosted my data as a Transact SQL File. Up to this its going fine.
After that I want to retrieve my data from GoDaddy Database server. They are not allow the remote connections directly. But they told to use the File DSN to retrieve the data from thier server ( GoDaddy Server ). I don't Know how to use thier File DSN to connect My ASP.Net 2.0 Application to thier GoDaddy Database Server.
If I asked to GoDaddy Support team they are sending this file.
Connecting to a Microsoft SQL Server Database Using ASP/ADO
I have problem connecting to a SQL 2000 server that is hosted on a Windows 2003 server. My application uses classic ASP with VB6 components. VB6 components connect to SQL server and return data to ASP application. Everything was working fine when the application and SQL server was hosted on NT machine. Recently we have shifted to Windows 2003 server. Since then we could not establish connection to SQL2000.
I'm using UDL as connection string.
IIS and SQL2000 hosted on the same machine with Windows 2003 OS.
This seems to be a security issue. Earlier I faced this issue for a .net application which I resloved adding a domain account to both SQL server and IIS directory security.
Request your input to solve this problem.
Sunandajit Ray
Infrasoft Technologies Limited
Here is the situation:
I have SQL server express 2005 installed on my pc as instance SQLEXPRESS.
I have created a Visual Basic applicaion with the following as connection to the SQL server express 2005 running on the same PC:
****************************************************************************************************
Dim lconnectionString As String Dim builder As New SqlConnectionStringBuilder Dim cmd As New SqlCommand Dim reader As SqlDataReader Dim parameter As SqlParameter builder("Data Source") = ".SQLEXPRESS" builder("Initial Catalog") = "" builder("AttachDbFilename") = "C:My DocumentsVisual Studio 2005Projectsabcabcabc.mdf" builder("Integrated Security") = True builder("User Instance") = True lconnectionString = builder.ConnectionString Dim sqlConnection1 As New SqlConnection(lconnectionString) cmd.CommandText = "SP_add_collection" cmd.CommandType = CommandType.StoredProcedure cmd.Connection = sqlConnection1 sqlConnection1.Open()
*******************************************************************************************************************
It seems that i can not connect to the abc.mdf in SSMSE while the VB program is running. (ERROR:
Database 'C:My DocumentsVisual Studio 2005Projectsabcabcabc.mdf' cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server errorlog for details. (.Net SqlClient Data Provider) )
If i connect to the abc.mdf first in SSMSE, then run the VB program afterwards, it gives me the error on this line -- sqlConnection1.Open()
I want to be able to access the abc.mdf database with both SSMSE and VB at the same time. Could anyone help me on this ?
Thanks very much !
apple
Hello,
For my application, I need to consult a database located on a server on the local network. The application is located on my pc. I use the connection string
Code:
"Integrated Security = SSPI;database=dbName;data source=serverName"
(I program in C# and connect with ADO.NET)
When I compile my project as a windows application, this works fine. But when I compile as a web application in ASP.NET and try the same connection, it won't connect. How can this be solved?
Thanks
Hey everyone, I'm having trouble connecting to my sql express instance through my vb.net application. I can connect to it from Visual Studio and the management tools, but get an error when connection with a connection string. What should my connection string look like? I'm using the a default SQLEXPRESS instance.
View 3 Replies View RelatedHi guys.
We have an external webserver(server1 on domain1) is a DMZ, and sql server7(server2 on domain2) inside the firewall.
Domain1 trusts domain2 but domain2 does not trust domain1.
Our firewall hosting by outside vendor and they told me they already opened up the port 1433 for server2.
I put a small asp.net application on server1(this application works fine in intranet. 2000 server,iis5,virtue directory, and .net frameword were well installed and configured), and I got S'QL server does not exist or login fail error'.
Any idea about that? And how to test the port was opened?
Any input appreciated.....
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" />
I have to search the keyword from windows application using dtSearch. when user enter the list of keywords in UI, i have to connect to dtSearch tool and based on the output return, the matched keyword should be added to database table.
Now, i have problem in connecting this tool from my application.
Thanks in advance.
Hi,
Any one tell me the code to connect to .sdf file in c# windows application?And tell the requirments to conncet.My sdf file path is this
C:\Documents and Settings\koti\My Documents\Example.sdf
I write this code.It is not working
string str = "Provider=Microsoft.SQLSERVER.MOBILE.OLEDB.3.0;Data Source=C:\Documents and Settings\koti\My Documents\Example.sdf;SSCE:Encrypt Database=True";
SqlCeConnection cn = new SqlCeConnection(str);
cn.Open();
Ant one help me Plz...
Regards,
venkat.
After manual AG fail-over from primary to secondary the application is not able to connect the listener name for atleast for 5 - 10 mins
The telnet fails during this time from app server, the listener ip is on muti-subnet.
At the same when i try to connect it from SSMS from a remote machine it works fine.
Hi all,
I'm working on a project where I have to create a password protected form for teachers to submit reports about students.
Originally I was going to use asp.net to create the form, but unfortunately the server I'm working with will not be granted asp functionality in the allotted timeframe.
To solve this issue I have another idea. So I will ask a few questions to help with research before I begin coding.
Is it possible to create a windows application that can connect to an access database hosted online? The windows app will need to be be able to update, insert, and select information from the database.
There is only going to be about 30-40 people using this windows application once or twice a week.
Thus I envision taking a password protected access database and dropping it onto a server.
The windows application will have the online location of the database embeded into the code. (connection string)
From there on out coding for the windows application should be the exact same as if the database was hosted locally on the computer, correct?
Also,
1. What is a good way to check and make sure the computer is connected to the internet before my application tries to access the database?
2. Are there any drastic security issues with this process that I should think about. The database will only be password proected, and the windows application will take a username/password from the user and check it against a table before they are able to submit info to the database.
I just need to be pointed in the right direction for this project.
Thanks.
How to Connect sqlServer 2000 in Pocket PC 2003 Application.
In Packet PC 2003 Application I have to connect to sql server 2000 on
my machine. The application gives error if connected using sqlConnection. Is SQL server CE necessary to connect to sql server 2000 in .Net Compact Framework?
Below is a post by blindman from my other "mentoring" thread (http://www.dbforums.com/showthread.php?t=1608569). I wanted to respond to it but not in that thread:
Yeah, but if he's going to go unbound he might as well develop in .Net rather than Access. You lose half the convenience of MSAccess as a front end if you use unbound forms and controls.
Besides, he's trying to learn SQL Server, not front-end development. Learning both at the same time may be a bit much. I'd suggest he stick with his idea of converting the Access database to SQL Server back-end.
But, you should definitely convert the Access front-end to a Microsoft Access Data Project, rather than a classic mdb file.
Going unbound would increase your application performance, but probably not noticably unless you have scores of uses, and since you are currently using straight MS Access I'd guess you have no more than five or six simultaneous users, right?
blindman
To start I have decided that ADO is the way to go even though I don't necessarily need the performance boost for my current situation. Keep in mind I am planning for future and more demanding opportunities, hopefully :) And I'd like to learn the "right" way to do things.
I actually use ADO quite a bit in my current DB app and bound controls as well so it really wasn't a new concept. However using strictly ADO produces alot more work and code. And like blindman says it pretty much takes all the ease of Access away and VB.NET for that matter too. I mean all the wizards are useless. So I have two questions:
1. When going to all ADO you are pretty much recreating what Access already does for you right? Coding in ADO is more work right? I mean you have to setup connections and fill fields and listboxes manually in code right? I don't mind the extra work I just want to make sure if I'm going to be doing all this extra coding that it is the right thing to be doing.
2. MDB vs. ADP - From what little I've read Access Data Projects are made for use with SQL Server. It is even more useful if you don't/can't actually work in SQL Server. But again if I'm using ADO it strips all the usefulness of the ADP's doesn't? I don't need ADP's to create views or sprocs. I can do all of that through the management studio. So does it really matter if I use an ADP or MDB as my front end if that is all it is going to be is a front end?
Lastly I wanted to use VB 2005 as the front end but we utilize a ton of reports. As far as I know Crystal Reports or something like it has to be used with VB 2005. Or does VB 2005 have some built in reporting capabilities? I thought I saw some report designer for VB6. Anyway I decided to stick with Access because I am familiar with its reporting capabilities.
I should note that I have VB 2005 Express and SQL Server Express. Right now my company is not putting any money into a higher version.
Let me know what you all think.
Thanks,
GG
Hi
Can anybody tell us what frount end sould i learn for
better result from sql server.
Can also tell us what is price of sql server developer &
enterprise edition
Thanks
ASM
I am in the planning stages of a front-end to access sql server databases. The project involves analysis of stored data as well as storing results of the analysis. The classes for the analytical part is fairly complex so I would like to speed up the data manipulation part of the project. I am already familiar programming with ADO but I was hoping for a more complete solution. Is there a sdk or example code (third-party OK) that could facilitate this?
The client is not especially fond of .NET and would prefer to use VB6. However, with the right solution, C# or VB.NET would be acceptable languages.
I can't get my asp page creatd in Front Page 2000 to dump info into SQL database...am I missing something?
View 1 Replies View RelatedI have my error routines and raiserrors working fine. I can run my stored procs through query analyzer and I get the error messages I expect. WHen the stored proces are run through Access, VB, C++, what is required to return the
error messages I see in QA. Is it specific to the app front end. All my front ends will be using ODBC as their
connection