Could not establish a connection to the database. If you have not yet created the SQL Server database, exit the Web Site Administration tool, use the aspnet_regsql command-line utility to create and configure the database, and then return to this tool to set the provider. I have set up a db locally which mimics the production DB, THe production db and website has no has no issues.
THis used to work till i had hard disk failure and had to reinstall all software and do the db from scratch. Used the table scripts and ran the aspnet_regsql. I am using sql server express 2008 asp.net 3.5 I am using custom provider for Roles and custom membership provider for Memberships. Pretty sure the problem is in the db permissions, though I have set up Users in the Security of the DB.
Background: I use SQL server 2005 developer edition and visual studio 2008. Visual studio 2008 is running on a local machine with Vista business edition. SQL server is running on a remote server using Windows server 2003. Both computers are within the same domain.
Problem: First, I used the server explorer to connect to the SQL server. Everything works as desired. Then I write code to do the same thing. I keep getting the following error message:
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 25 - Connection string is not valid)
However, I used the exactly identical connection string as the one used in the server explorer. So connection string should not be the problem. In addition, I tried the test code in MSDN, which tells whether my domainusername can flow the network. It turns out the user name is fine. I also went to the SQL server management studio and found the login for my computer is NVCWeihao while my computer login name is NVCweihao. I am wondering if this uppercase letter really affects the connection.
connecting my database to the online server. My server is seekdotnet. But I had been receiving this error code Cannot open database "database.bak" requested by the login. The login failed. Login failed for user '219_nypmecom'.
I am using Visual Studio 2008 and asp.net technology with C# language. Whenever I try to choose any datasource for databound control like "gridView" of "ObjectDataSource". The connection can be tested as OK but when I click on OK the it gives following error and database could not be added: "Object Reference not set set to an instance of an object." it was working perfectly fine in Visual Studio 2005, so kindly help if there is some settings that are to be adjusted for 2008 version.
I was working on a asp.net project earlier but due to some OS problem I had to re-install the OS..so before re-installing the OS I detached my sql database and then attached it back after installation..but I am having a login problem now..the previous servername was XYZ-DB840C74SQLEXPRESS..so this user i.e. XYZ-DB840C74ASPNET is added to the database's permissions..now my new server name is XYZ-8D50FD73SQLEXPRESS..but I am unable to add this user through the permissions wizard..I am getting the following error: Cannot open database "finance" requested by the login. The login failed. Login failed for user 'XYZ-8D50FD73ASPNET'.
In my windows application, i am listing the System DSN's configured on the remote machine in a combobox. Once i select the DSN and click on Connect button, i should be able to connect to the remote database. I am trying to open the connection to the database using ODBC but am getting the below error.
ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified.
I have two PCs with Windows Server 2003 standard adition installed on them, each are in a saperte room, and having SQL Server 2005 Express. Now I want to let Myserver to connect to server1 with a readonly access to a database on it. I figured to create a user acount on server1, and make it as a login account in SQL Server and grant the appropreate privilage. Now I'm wandering are there any security risks regarding this approch.
I had another thread on this problem but I wanted to start this one so no one had to look at the code I posted in the other thread. I have a successful connection but want to display data from the SQL database on my website in my Windows form application. Here's the code I have so far. Used some of the ADONET Tutorial1 here. The table Ray Rover Activation has a number of different columns but to start out I just wanted to see if I could display data for the EmailAddress column.
If I comment out the Sub DoStuff I don't get any errors but neither is anything displayed other than the messagebox message. If I don't comment out DoStuff then I get an error, "Incorrect syntax near the keyword 'FROM'". Maybe someone could enlighten me some on what I need to do get the data in the column EmailAddress to display.
I am creating a ASP.Net application in MVC architecture. I have to connect to a database on MS Access and be able to enter data into it. All examples I see use SQL Server. When I try from prject explorer Add New Item -> Data -> I am unable to find Drivers for Access Database.
From the Data Connections in Server Explrere window I was able to make a successful connection to the database.
When i tried to attach 2008 database in sql server 2008 it is throwing the error-
"The database 'actitle' cannot be opened because it is version 655. This server supports version 611 and earlier. A downgrade path is not supported.Could not open new database 'actitle'. CREATE DATABASE is aborted. (Microsoft SQL Server, Error: 948)"
When i execute 'select @@version' it gives 'Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86) Oct 14 2005 00:33:37 Copyright (c) 1988-2005 Microsoft Corporation Workgroup Edition on Windows NT 5.1 (Build 2600: Service Pack 3) 'How the version still be 2005 when im in 2008 ..How can i attach my 2008 database back up.
Ive created a form on my website. what i want to do is when the user clicks finish at the end of the form, i want all that information to be sent to a table that is in sql server. does anyone know a) if thats possible? and b) what code i would need to put in vb?
I have a table in my aspnet database. I added a bottom row "Not Selected", if the user doesn't select from a databound drop down list. This row is at the bottom, because I just added it to the table data. Is there any way to move this one row to the top of the table manually? There is not "cut" and "paste" when I select the whole row.
I guess the code is totally right and doesn't require any change in it,, however am getting an error which says "Conversion failed when converting the varchar value '11/11/2010' to data type int."check the attached file ..
I'm creating a website and I'm testing resgistering and Log-in.
I followed a simple tutorial to create a Log-in in Visual Studio C# template which generated a SQL Server database.Locally the Log-in and registration page works perfectly. The problem is that when I upload my site to the hosting site the navigation works but the Log-in and Registration forms send an error when clicked "Register" or "Log-in". I contacted the site and they upload my database the way it should be because I was doing it wrong. I can see all my files including the data base.
They commented me that I had to do a connection string to the data base so the login and registration forms can work. I don't understand how to do that, I know the connection string has to be declared in the Web Config File, the thing is that I don't know how to write that code and link it to my data base in the hosting site, in fact I have sample code but I don't know just what do I need to put in it.
Well it's finally time to stop ignoring my unit's need for reports. I keep coming to dead ends. I gave up the crystal reports idea, and ssrs seems a little easier. Now the problem is that I'm creating a report locally on my laptop, then will change the connection string, upload it to my server and have it run against an identical database on the server.
I'm using SQL Server Express locally, and when I try to create a dataset (using the wizard), I can see the tables, but when I try to add one, I get an error message "Could not retrieve schema information for table or view". I looked up this error and there isn't much useful info on it. I guess it some bug when trying to use SS Express? Is there a work around for this? Can I create the report programmatically? Should I use a different kind of reporting service?
I have written a website in ASP.NET with a back-end database using SQL Express 2008. My database is created and put in the App_Data folder. It is ok when it runs on my local machine. However, when I upload to the web server, I got the error: An attempt to attach an auto-named database for file C:Documents and ettingsDesktopProject2_ISAM5337App_DataEvent.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share. By the way, I notice a same probelm : When I move my project to a location which is different from specific path for my database, I got the same error message .
I'm attempting to create a update form that will pull information from my database. I'm a little confused on how to get the information into the textboxes on my form. First I have my form:
This is where I'm getting stuck. I'm not certain what code I need or if what I have is correct. Is there an example what my next step(s) are? I would think that I need to set a variable to hold the data, maybe something like txtRace = Trim(GetString(0)???
i am currently working on a small project in which i have to build a web form and link that to a database...thing is, i don't even know where to begin!Once i build my database, how do i link that to my website? directing me to an appropriate tutorial on how i can do this?
one of the main things i'd like to do is to connect to a database, get info, and with that info, build a list for a drop down menu for the user to select. is that at all possible?
Using Visual Web Developer 2008 Express with what I'm assuming is Sql 2008 Express. Using SqlDataSource, when I try to configure a data source, I'm able to input a server name: (local)sqlexpress and the "Test Connection" button shows that it was successful. However, if I type in a new database table name and VWD 2008 asks if I would like to create it, I keep getting the message: "OBJECT REFERENCE NOT SET TO AN INSTANCE OF AN OBJECT." No idea what that means or how to fix it. I can't open theDatabase Explorer View.