i 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 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 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 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 RepliesJust 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 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 RepliesWe have a database on our server, here at the office. We now want to create a asp.net website that will be accessible to the public.
Say the domain of the website is [URL] and it's hosted on a webserver of HeartInternet.
When someone connects to that domain, that webpage must be able to pull data from our server that is located here in our office.
In other words the webpage cannot just load data out of the MySQL database loaded on its server, but it has to connect to our server and get data.
how i can connect sql database to table control?
View 1 RepliesI 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
how to connect an asp.net application running in local IIS to a database residing in a remote web server ?
View 2 Repliesi 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
my web cannot connect database SQL server 2000 after i deploy to IIS.
I can connect sql server to another computer from my query analyzer and Enterprise Manager.
but after i deploy to IIS 5.1. I cannot Login .
it always return message like this:
"A network-related or instance-specific error occured while establishing a connection to sql server. the server was not found or was not accessible. verify that instance name is correct and that sql server is configured to allow remote connections. (Provider :named pipes provider,error:40 - Could not open a connection to sql server)"
how to Deploy ? because my program work correctly in Visual Studio 2008.
but after i publish and move to wwwrooot in inetpub. my web cannot login.
i suspect my method deploy in IIS is not correct.
how to connect database create in sql server ,to my web site upload on domain.
View 1 Repliesi was trying to create new user for using login which i have created (user id and pswd) so i click asp.net configuration ,then after clicking security to add new user i got error as shown in bracket(There is a problem with your selected data store. This can be caused by an invalid server name or credentials, or by insufficient permission. It can also be caused by the role manager feature not being enabled. Click the button below to be redirected to a page where you can choose a new data store.
The following message may help in diagnosing the problem: Unable to connect to SQL Server database.) in asp.net website administrative tool .......
i have sql server 2008 and visual studia 2008 install in my system when i open a new website project and then use the asp.net administration tool in that when i go for security tab under that one.
i want to enable roles but it displaying error that unable to connect to sql server database.
I have one asp.net hosting account with some service provider.. They have given me some xxx.xxxxxx.com to access sql server from my desktop...
I enter xxx.xxxxx.com in server name and username and password but it will not connect..
what are the steps i have to do to access my hosting database...
they have given sql server 2008 im using in local sql server 2005 management studio so let me know how to connect
i am trying to setup SqlCacheDependency with MS SQL Server 2008, i am using
aspnet_regsql.exe cmd line tool. I am able to enable it for database but when try to do it for table i get the following error message.Enabling the table for SQL cache dependency.
.An error has happened. Details of the exception: Login failed for user 'myUserName'.
Unable to connect to the SQL database for cache dependency registration.
I have amazon cloud aws, i am developing a website in asp, i have remote RDP access to my server..
So i have not installed postgreSQL etc.. but i am unable to connect to that database.. and when i install and run on my local system, it connect.
I try to connect to database in Adaptive Server Enterprise using Sybase.Data.AseClient dll. Connection string that I am using is 'Data Source='host';Port='5000';UID='user';PWD='password';Database='database';'. When Application tries to connect to database exception is thrown. 'Client can not establish connection'.
I tried connecting to database by trying to create ODBC Data Source. When I try to create DSN using ASE driver. DSN creation also fails.
What should I check ? Do I need to do some settings in database server? I am using all developer editions and my database and application are on the same machine.
I can connect to database Using Sybase Central. I can run queries on same database using Interactive SQL tool.