SQL Server :: Project Executable Can't Connect With Database Unless Installing SQL Server
Nov 7, 2010
I 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'm getting "Cannot connect to ASP.NET development server" almost every time I stop the ASP.NET server before restarting the project in debug mode. It can take between 15 seconds and 2 minutes to get the error message, and Visual Studio is frozen.
Sometimes I get three in a row, and I have to wait 2 minutes each time, or go into Task Manager and kill to process. Then I have to start Visual Studio 2010 again, which is at least three times slower than Visual Studio 2008 to open.
It's *extremely* annoying. I know I don't have to close the server if the code has changed, but sometimes I simply want to restart my website in debug mode (there is a cache on most web service calls, so this clears the cache). A workaround is to add "foo" code to a class and restart the project.
I'm running Visual Studio 2010 Professional on Windows Server 2008. I'm running the Visual Studio Power Tools too, with the latest update.
I 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?
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.
Whenever i run the project this problem occur Can any one give me solution. should i have to delete webdev.webserver.exe and install another is this the right solution for my problem.
I installed SSRS on the same sever with database. now due to performace issue I wanted to install it on different server other than Database server. my question is what are the pros and cons? does anybody did that before?
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.
I am using VS 2008 that worked fine using the standard ASP.net security with the Web Administration Tool and SQL Server 2005.
I had to install SQL Server 2008 which also meant I had to uninstall SQL Server 2005. Now when I try to use ASP.net security by pulling the Login box from the toolbox to my form and then go to configure this I get an error.
"Unable to connect to SQL Server database."
How do I change this to work with SQL Server 2008?
I 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?
Previous developers have developed a .SSISDeploymentManifest file (SQL Server 2005) to install SSIS packages which prompts a Package Installation wizard. I tried to install it on SQL Sever 2008 (it works on SQL Server 2005), but it failed with the error: "Storing or modifying packages in SQL Server requires the SSIS runtime and database to be the same version. Storing packages in earlier versions is not supported".
How do I install 2005 SSIS packages on SQL Server 2008? I have all the .dtsx files, not sure how to install them?
I've installed visual studio 2010 full version and worked on couple of assignments. Right now, I'd want to connect to SQL server database to move ahead and store and retrieve data into the database. Can someone please point me in theright direction or walk me through the configuration. I see sql server 2008 has come with Visual Studio 2010. Not really sure if i need to install anything else. Also, post a sample application code to connect and fetch data using a select statement ??
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...)
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}
i am working on a project where i have to give call to an .exe file to access the scanner on client side. i am using System.Diagnostics.Process.Start(Server.MapPath("~/bin/Scan.exe").ToString()"); to call exe file in my bin folder on to the server, but it is not getting called.
I recently upgraded a WinXP machine that had been running VWD 2005 to a Win7 machine using VS 2010. The application targets .Net 2.0, but since the upgrade, I cannot get VS to connect to my database and this is the first time I've tried working on the site since upgrading, so no changes have been made to any code (with the exception of trying to change my connection string so I can connect). The specific error is:Cannot open database requested in login 'dbName'. Login fails. Login failed for user 'SqlLogin'The sql database is on another machine and I was assigned the login/password; I know the login works because I can connect to it with SQL Server Management Studio. Having read several posts and still having trouble, I tried to do a couple things. First I modified my web.config connection string, which looks like this:
[Code]....
When that did not work, I deleted the connection string from the web config and dragged a sqldatasource control onto a page and tried to use the connection string builder while in design mode. Then the error I got was:The database db1 does not exist or you do not have permission to see it. Would you like to attempt to create it?I'm not sure I understand that there is a problem at all, except that I upgraded the OS/IDE. I'm using IIS 7.5 on my local machine to serve the development site while connecting to the development sql server on the other machine. Since I can't use the IIS aspnet account on the remote sql server and my assigned login is verfied working through sql management studio, what else can I do to get my developement site working again?
I have a ASP.Net program written in C# that uses a database stored in the AppData directory, the program works perfectly on my development (Win7SQL 2008R2) when I deploy to a Win2008R2SQl 2008 R2 server the program is unable to connect to the database. I'm using the connection string below. Several sites suggest I set the Application Pool to use 'Network Service' as this has Modify permission to the AppData directory, I have done this but it still won't work, another site suggested I Application Pool to "Load User Profile = True" but still no joy.
[code].....
I get "Object reference not set to an instance of an object." in my app and "An attempt to attach an auto-named database for file C:inetpubwwwrootADPhonebookApp_DataDB.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share." in the Application Event Log
i have created several crystal report for my web application, i need to use my application to connect different database on the server which has no problem in the application but when i open the reports created using crystal report, it still connected to the database configured. how can i fix this, is there other way than to use another copy of the application and configure it manually at the each of the reports. i do have pass the logon information to the report using vb.net in which i get the info from the web.config
Dim A As ConnStr = New ConnStr With ConnInfo .ServerName = A.getServerName() .DatabaseName = A.getDBName() .UserID = A.getUser() .Password = A.getPwd() End With
my problem is how to make crystal report to uses all the logon info passed and not use the infor set in the report file
