How To Connect Database Create In Sql Server ,to Web Site Upload On Domain
Sep 6, 2010how to connect database create in sql server ,to my web site upload on domain.
View 1 Replieshow to connect database create in sql server ,to my web site upload on domain.
View 1 RepliesI'd like to connect to a database on a different domain. I've done some search and people say to add a connectin using an enterprise manager? Where can I find sql enterprise manager? On msn website, they only show things about sql enterprise manager for sql 2000. Is this a tool only included in sql 2000?
View 4 RepliesI have a domain with name of http://MainDomain.com I want to create a site in this site and this site contains 14 sub domains there. I need a structure of sitemap which contains all sub domains. The list of sub domains
is given below. Any suggestion is welcome...
http://MainDomain.com (Main Domain)
http://Sba.MainDomain.com
http://sbaloan.MainDomain.com
http://sbaloans.MainDomain.com/
http://sbalenders.MainDomain.com/
http://commercialrealestatefinance.MainDomain.com/
http://commercialrealestatelenders.MainDomain.com/
http://commercialmortgages.MainDomain.com/
http://commercialmortgagerefinance.MainDomain.com/
http://commercialloanlenders.MainDomain.com/
[code]...
In our database we have an SQL server account that has the correct roles to access some of the databases.All of our PC and Servers are in domain using Windows Account. Now there is ASP.NET web application, we want the users in the domain to browser some data in the sql server. But we do not want to grant direct permission to every person, so is it possible to connect to sql server and run some T-SQL without granting permission to users using one specify account?
View 3 RepliesI was just wondering what the best approach would be for uploading/downloading files. My users want to have the ability to upload and download emails to various Orders but i'm not sure of a few things.
Would I need a new table and reference it to my Orders table? Or would I need to create a new table and add columns such as file location, and upload the files to a particular server? Also since I am working on a Windows machine, i'm not really sure how to connect to my server to allow me to upload/download files (not sure if that makes sense).
a asp.net site located at a hosting center(UK)and i want users from our office to login to that site using their active directory account.is this possible to do over the network ? or i need the site on the same domain as the active directory server?
View 3 RepliesI am having some major headaches trying to get a Web Dev 2010 and SQL Server Express 2008 R2 to work together. At one point I hade Web Dev Express 2008 and SQL Express 2008 working together just fine, then I upgraded to 2008 Express R2 and have never been able to recover.
I have attempted to uninstall and reinstall several times, browsed the forums, watched videos, and while I have picked up a few things, I am still far from being able to get these two apps to work together for basic user authentication.
Here is where I am at. Web Dev Express 2010, .Net 4.0, and SQL Server Express 2008R2 installed. I have ran the .v4 aspnet_regsql.exe app against SQLEXPRESS, but when I bring up the Web Site Admin Tool, it cannot connect.
My machine.config connectin info is: [Code]....
Thinking that I may have some uninstalled connection info causing problems, I reviewed several of the security videos on this site, and decided to attempt to use my own database install rather then the default ASPNETDB.
So I now have 2 Database Engines (SQLEXPRESS and LOC). I created a new databases on LOC, named LOC and AspNetServicesDB. I then created users named LOCADMIN and AspNetServicesUser, made then the owners, and set the default database for eacg.Next I ran aspnet_regsql.exe from the v4.0.30319 folder, connected successfully, and installed the tables under AspNetServicesDB. The new tables (roles, membership, profiles) were installed. I then proceeded to copy the above machine.config connection info to the web.config file, and modified it as Joe Stagner did in this video. My edited web.config info:
[Code]....
Note that password is set to the real password in my config file.
Yet when I bring up the Web Site Administration Tool test the single provider, I get this error:
[Code]....
i want to conncet to rss orignal website if connect is successfully write the rss to xml file and read from orignal website ,else connect failed read xml file (last information in rss original website) and show it how can do it .
View 1 RepliesI have created a web application and an SQL database using Web Developer 2010 Express. I have SQL Server 2008 and SQL Server Management Studio Express. In order to deploy the database to my hosting space I need to create a .BAK file from my new database. I think I can do this from with the Management Studio, but can't figure out how to get it to connect to the database. I have used Management Studio before to retore another SQL database and the only connection I see when I open the Management Studio is the old connection to the old database. How do I connect to my new database?
View 6 RepliesI had this one working a while back i try to upload file to my root folder it works locally but when i try it from my website i get the following error: exception details: system.bet .webexception. unable to connect to the remote server
the code bomb at the following line
requestStream = uploadRequest.GetRequestStream() 'This is where the exception occurs
fileStream = File.Open(localFile, FileMode.Open)
[code]....
i'm trying to do something weird. I have two sites, one that allows me to handle some information and administrate it (site 1). I have another site that is for querying information only (site 2). I need to upload files in site 1, but i need to save it in site 2, to leave it available to download in site 2.
View 4 RepliesHow to create API in .aspx page(i.e my .aspx page should be act as API) with c# language. This API should access data from SQL server and other .aspx should be able to access it.
View 1 RepliesI have created web pages using VS Web Developer that use a local Developer Edition of SQL server database on my PC with LINQ to SQL. When I deploy my website to a remote web host SQL server, I need for my web pages to be able to use the remote database instead of the local database. So, how do I get the Server Explorer to connect with a remote SQL Server database?
View 6 RepliesI have upload my files in domain.after uploading,i run the site.i get the following error The EXECUTE permission was denied on the object 'xxxxxxx', database 'zzzzzzz', schema 'dbo'. what reason for this error raised and how to solve it?.
View 2 RepliesI am developing and app to find automatically characters stats with the 2nd edition dnd rules to be easy for my party to create characters when we play.
I am using Visual studio 2010 c sharp express and Sql 2008 express R2.I have added a database in the project to have all the data needed. When I use the release folder or the debug folder on other pcs the app doesn't run. Wherever I install SQL server (database and management) things are fine. I googled but I am not sure what to look exactly for and made a brief search here but with no results. I am trying to make sth that has almost no dependencies but well I can't avoid installing .net framework 4 everywhere...
Is there anyway to make database work without installing SQL? Is there any workaround like a dll or sth?
I am developing web application using asp.net. Here i need to access two databases in which one is present on other server. I am able to connect to database present in same server but not with database present in other server.
I am using MS-access. I dont know the changes to be done and syntax for database connection.
if (connection.State == ConnectionState.Closed)
connection.Open();
I Get the the folloeing exception ::
ERROR [08004] [Informix .NET provider][Informix]Cannot connect to database server ...
I don't know what is the problem.
I have a c# window form application (which is basically a game).And an ASP.NET Website. the window form application has a database with a table that contains the username and his cash. The asp.net database has a table that contains the username and his cash.Now I want to sync between to the two servers. Once I get point in my game, It'll also update the database of the asp.net site.
View 3 Repliesi have uploaded my site [URL] it it working properly on local machine but when i uploaded on server i am facing 1 error on button clik of any form. there are two ages career and contact whenever i submit this data by clicking button i get this error. Server Error in '/' Application. Runtime Error Description: An application error occurred on the server. The current custom error settings for this application prevent the details of the application error from being viewed remotely (for security reasons). It could, however, be viewed by browsers running on the local server machine.
Details: To enable the details of this specific error message to be viewable on remote machines, please create a <customErrors> tag within a "web.config" configuration file located in the root directory of the current web application. This <customErrors> tag should then have its "mode" attribute set to "Off".
[Code]....
Notes: The current error page you are seeing can be replaced by a custom error page by modifying the "defaultRedirect" attribute of the application's <customErrors> configuration tag to point to a custom error page URL.
[Code]....
Just beginning to set up and get into MVC and I have immediately run into a problem...
I opened a new MVC project in Visual Studio 2008 Pro, tried to run the basic template project, chose the logon/register page, enterered my details and got a runtime error message in AccountsModels.cs:
Unable to connect to SQL Server database Do I need to download a db from somewhere first, have I missed a step out the install ?
I need to connect to oracle database (10g) which is on differenet server.
Can i use the latest ODP.net provider or i need to use ODP.net provider related to oracle 10g only? After installing the ODP.Net what are the next steps to do in order to connect to database. This is totally new to me (connecting to oracle... i have worked with sql databases till now...)
how to connect to remote database(SQL server)using c#
View 2 Repliesi am writing a simple C# application with sql as my database however i am confused how to connect to my database the details are the following:
Server = "BFO-PC3\BFOPC3SQL2000";
Username = "aesadmin";
Password = "adminpw";
Database = "M4200";
I know its better to use stored procedures than the asp.net sqldatasource control. But on an app like say amazon and ebay what is the best way to connect to a database (best practices) that multiple users will use: sqldatasourcecontrol,disconnected classes,or connected classes?(Programmatically or not}
View 2 RepliesIs there a way to be able to create a new database when a company signs up to my site, and be able to use that database when he/she logs in, so for example if company A logs in he uses CompanyA database and if company B logs in he uses Company B database, now they all have the same table structure, just need to figure out a way to use a specific database depending on the user that logs in.
View 2 Replies