how do i connect visual web developer to sql server express 2008? in the Database Explorer, i right click on Data Connections, click Add Connection..., and in the Data source box i choose Microsoft SQL Server (sqlClient), which i'm guessing doesn't connect me to a database file, but to sql server express itself(?). in the server name box when i click the drop down box, there's nothing there and that's where i get stuck.
View 3 Repliesconnecting 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'.
View 1 RepliesAs a follow on from this question I'm building a custom server control to be placed on a Sharepoint 2010 master page. The idea behind this is that it will display a menu that is dynamically populated from the database. As this is a server control, I'm building it in a dll but I've run into a small snag. As it has to connect to the database, I need to store the connection string somewhere (and have it able to be configured based on target configuration (dev/test/prod). I was intending to the user the Entity Framework as my ORM but i'm confused as to where the connection string is to be stored. In a normal ASP.NET web app it goes in the web.config, but this is a server control in a external DLL.
Where do I store the connection string so that I can just build and deploy the assembly containing the server control.
EDIT:
Before I post a bounty, I have tried using an embedded resource XML file to hold the connection string and while this works, I'm curious as to if this is best practice/a better way?
I'm new to .NET and while starting to learn ASP .NET MVC2 framework I see that you can create a .mdf file inside the App_Data folder and connect to it or you can connect to a SQL Server.What is the difference between these to methods of interacting with a database? What are the advantages/disadvantages of one over the other?
View 1 RepliesI have a project that must illustrate that connection to the database is not locally, so I have install VirtualBox and I intend to install SQL Server on it. So any one have the idea of how can I connect from the Host Machine to the SQL Server located on the Virtual Machine
View 3 RepliesI am trying to conect to my SQL Server 2008 instance from application in Visual studio unsuccessfully.
This how my Instance appears in SSMS
DETERMIN (SQL Server 10.0.4000 - balloonshop )
Below is an example of a connection string from the book I am following which works if you have SQLExpress on your localhost domain.
I am using SQL Server Enterprise My Server name is DETERMIN (computer) . When I am in SSMS this is how my instance node appears
DETERMIN (SQL Server 10.0.4000 - balloonshop )
Determin is the name of my computer I think its the name of my instance as well not sure, balloonshop is my login. How can I substitute the names properly for the connection string below in order to connect to my instance
[Code]....
[Code]....
I have a issue where I am trying to pull some records from an Access 2007 DB that has linked tables from a SQL 2005 Server. When I go to do this the browser IE8 just sits there and does nothing. THe little progress bar at the bottom moves about half way then that is it. It will sit there and show no errors or do anything. I have experience with connecting and manipulating Access and SQL server DB's but not through Access with linked tables from SQL Server. Here is test code below:
[Code]....
This does not produce an error or anything. The browser just sits there and sits there. Is there something I am missing?
[Code]....
I'm getting the following error when attaching to my database on line. I'm not sure what the issue is as I've been able to connect in the past without any issues and there haven't been any changes to my connection string. Here is the error and my webconfig.
[Code]....
I come from a coldfusion background, where setting up a connection to a database (Oracle, MYSQL SQL Server etc) was was easy as filling in a few fields in the datasource screen in the Coldfusion Administrator web app.
Then in the web application to connect to the database I would use <CFQUERY datasource="oracledb" name="test"> and in the body of the application I would write my SQL query and display the results of this query in a <CFOUTPUT>#variablename#</cfoutput> block of code, or to insert data into a db table I would use the
<CFQUERY datasource="oracledb" name="insertdata">
INSERT INTO table (columnname, columnname2, columnname3)
VALUES (
<cfqueryparam cfsqltype="cf_sql_number" value="#columnname#">,
<cfqueryparam cfsqltype="cf_sql_varchar" value="#columnname2#">,
<cfif isdefined("file.serverFile")>'#file.serverFile#'<cfelse>NULL</cfif>,
</cfquery>
How does this process work in .NET? as I have to create a simple web application/form where on submission of the form the data would be stored in a MYSQL database.
what I have seen so far it seems a far more long winded and complicated process with .NET over Coldfusion with ultimately the same result, and I am desperately trying to understand how it works in .NET as surely it must be a similar process to that of Coldfusion?
I'm trying to learn how to do both of them at the same time on my own, while working on a project. All the examples in the MSDN are using databases that are a local SQL Server (Express) file. I am not going to be able to just upload the project (including the file) and have it work, am I? The thing is - I want to be able to write code vs. a database that is actually going to work online so I can start putting a project together and know that it is going to work online.
I don't want to get everything done, and then discover it breaks as soon as I upload everything. Assuming I can't just upload the database file and have it work - I have a hosting account that I am using for something else and I would like to set up a database to use (preferably MySQL because my SQL Server database quota is used up and I'd have to pay extra for another, but I will if I have to because it's not that much). I can do that, correct?
I have never used reporting services before. My boss just started teaching me how to use them. I was told something by my boss that I find hard to believe. In our environment we have 3 databases: Development Beta Production According to my boss, the connection string has to be hard coded in the reports. Therefore every time you move a report from one environment to another you have to manually change the connection string so that it points to the correct database.
View 9 RepliesI've installed the Components from the links below. But I still can't find any SQL references when I try to add them? I'm wondering if anyone would know the reason for this? I just started with asp.net. I've found several other questions regarding code for connecting but I can't find anyone who've had trouble with the Connector/components before?
MYSQL connector
[URL]
Microsoft Data Access Components (MDAC) 2.8
[URL]
I'm trying to write a method in VB.net so that when I click a button it queries the database and returns all the values which match a textbox which is located next to the button. I have no idea how to do this, I assume in the onclick method for the button I will need to pull in the value from the textbox, connect to the database and display the results to a gridview?
View 2 RepliesI m facing an error in connecting my Access Database using ASP.NET. I have placed the below code in Web.Config
Code:
<connectionStrings>
<add name="ConnString" connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|PerformanceDb.MDB"/>
</connectionStrings>
And used below code for connection
Code:
OleDbConnection myConn = new OleDbConnection(System.Configuration.ConfigurationManager.ConnectionStrings("ConnString"))
but it gives error
Non-invocable member 'System.Configuration.ConfigurationManager.ConnectionStrings' cannot be used like a method
While working with LINQ to ENTITIES I see that there is only a way to use stored procedure that is returning one entity only, or a view that is a join of two entities.
But what if I need in ASPX page to get two tables that there is NO connection between them, no join can be done between them at all.
I have one Stored Procedure that return the two tables, but entities don't support this right now.
I can split them to two Stored Procedure and call each of them separately.
Can I connect to a ubuntu server, that is running mysql using ado.net or do I need a special driver?
View 2 Repliesi'm using visual studio 2005. now i've to create a insert form which shud be connected to database(mssql). can any one tell me how to do dat. as i'm new to visual studio i dnt knw it.
View 8 RepliesCould 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.
[Code]....
I have all my tables and queries in online DB ie., i have created all my tables and queries in online using third party site [URL] Now i want to make connect my application (which is in my system) with that database
View 5 RepliesI upgraded a Website to use ASP.NET 4.0, from 3.5. This involved setting it up on a different server, with the same hosting company. I'm using a shared hosting plan on Windows Server 2008.
Since migrating, it gives an error message when I try to login to the site:
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: 26 - Error Locating Server/Instance Specified)
I'm using the same connection string as I did in the old version, which always worked. I also changed the permissions for the database to allow connections from the redeployed Website, via the host's control panel.
I have searched the web.config, and the source for the site, and I haven't been able to find a connection string that looks incorrect.
I've contacted the host about it, in case it is a configuration issue on their side.
We have a MOSS 2007 custom web part based on a user control that queries a database cluster. When the connection to the database is made, we regularly experience the error below and have had to create a work-around in the code to retry the connection. We have 3 environments - development, staging and production; the error only occurs in production. The difference in the production environment is it is a farm with 3 WFEs and a SQL cluster, where development and staging are single machine instances. All are MOSS 2007 & SQL Server 2008. We cannot find what is causing this issue and I'm hoping someone else has experienced a similar problem and knows the cause.
This is the error that occurs frequently when the query is executed:
System.Data.SqlClient.SqlException: A transport-level error has occurred when sending the request to the server. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.)
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParserStateObject.WriteSni()
at System.Data.SqlClient.TdsParserStateObject.ExecuteFlush()
at System.Data.SqlClient.TdsParser.TdsExecuteRPC(_SqlRPC[] rpcArray, Int32 timeout, Boolean inSchema, SqlNotificationRequest notificationRequest, TdsParserStateObject stateObj, Boolean isCommandProc)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteScalar()
at [Our Namespace.OurMethod](String someParam)
More than one method will generate this, but this is typical code, note the retry work-around:
public static DataTable OurMethod(string someParam) {
const string query = "sp_OurStoredProcedure";
var resultsTable = new DataTable();
var connection = new SqlConnection { ConnectionString = OurDatabaseConnection };
var command = new SqlCommand(query, connection) { CommandType = CommandType.StoredProcedure };
var dataAdapter = new SqlDataAdapter(command);
var retry = 5; SqlConnection.ClearPool(connection);
while (retry > 0) { try { command.Parameters.Clear();
command.Parameters.AddWithValue("@someParam", someParam);
connection.Open(); dataAdapter.Fill(resultsTable); retry = -1;
} catch (Exception ex) { retry--; if (retry <= 0) {
LogError("Exception: DataAccess:OurMethod: *RETRIES EXCEEDED* " + ex, "error");
} else { SqlConnection.ClearPool(connection);
LogError("Exception: DataAccess:OurMethod: ATTEMPTS REMAINING " + retry + ". " + ex, "warning");
} } finally { dataAdapter.Dispose(); command.Dispose(); connection.Dispose();
} } return resultsTable; }
Is there a way to connect the database PROGRAMMATICALLY without using SYSTEM.DATA.SQLCLIENT?
View 9 RepliesI 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.
Code:
[code]....
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.
My website is [URL] (access there to see error, please) When I was testing in VS2010, it was connecting to the DB because I set permissions READ/WRITE on my computer to ALL. If I put restrictions, VS2010 couldn't just connect to them. Well, I deployed my DB on the server of my website, and I'm not able to access it.
My connection string:
connection = New SqlConnection("Data Source=.SQLEXPRESS; Integrated Security=True;AttachDbFilename=|DataDirectory|Visitas.mdf")
I think I'm getting these errors because my server hasn't permission to access the database.
I have a custom SQL membership provider (NOT using aspdb files but our own 'People' table) that was working fine under development but doesn't even connect when it is deployed on web server. DB connection string has been changed to point to db server (checked against another web site & is fine there). The membership code (in VB) is in App_code directory so am I correct in thinking I don't need a separate DLL ? No error messages nothing just reports failed to login when I type some user credentials.
Web config file as follows
[Code]....