I'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 connect my app to my database hosted on my web space. I have a newbie query.Do I have to install Connector/Net 6.8.3 on my web space's server, or, can I install it locally and just change a config file of some sort on my server version? If the latter is possible, what is my best (and easiest) way of developing / testing in two DB environments? the testing server will be my online one so I don't mind having to manually edit something each time after I publish it.
View 2 RepliesWhy does a very simple script which inserts 26,000 records into a mysql database (myisam, no transactions) take 13 seconds in the php implementation, and then 35-50 seconds using mono+mysql connector? I thought asp.net was faster than php? Could the problem be the mono mysql connector is "platform independent", so the performance just stinks? or does asp.net suffer more overhead than php when it comes to executing each query? Aren't there any native linux binaries for mysql connector for mono that may be faster?
View 1 RepliesMy code is to update a record if it already exists in database else insert as a new record. My code is as follows:
protected void Button3_Click(object sender, EventArgs e)
{
OdbcConnection MyConnection = new OdbcConnection("Driver={MySQL ODBC 3.51 Driver};Server=localhost;Database=testcase;User=root;Password=root;Option=3;");
MyConnection.Open();
String MyString = "select fil_no,orderdate from temp_save where fil_no=? and orderdate=?";
OdbcCommand MyCmd = new OdbcCommand(MyString, MyConnection);
MyCmd.Parameters.AddWithValue("", HiddenField4.Value);
MyCmd.Parameters.AddWithValue("", TextBox3.Text);
using (OdbcDataReader MyReader4 = MyCmd.ExecuteReader())
{
//**
if (MyReader4.Read())
{
String MyString1 = "UPDATE temp_save SET order=? where fil_no=? AND orderdate=?";
OdbcCommand MyCmd1 = new OdbcCommand(MyString1, MyConnection);
MyCmd1.Parameters.AddWithValue("", Editor1.Content.ToString());
MyCmd1.Parameters.AddWithValue("", HiddenField1.Value);
MyCmd1.Parameters.AddWithValue("", TextBox3.Text);
MyCmd1.ExecuteNonQuery();
}
else
{
// set the SQL string
String strSQL = "INSERT INTO temp_save (fil_no,order,orderdate) " +
"VALUES (?,?,?)";
// Create the Command and set its properties
OdbcCommand objCmd = new OdbcCommand(strSQL, MyConnection);
objCmd.Parameters.AddWithValue("", HiddenField4.Value);
objCmd.Parameters.AddWithValue("", Editor1.Content.ToString());
objCmd.Parameters.AddWithValue("", TextBox3.Text);
// execute the command
objCmd.ExecuteNonQuery();
}
}
}
I am getting the error as: ERROR [42000] [MySQL][ODBC 3.51 Driver][mysqld-5.1.51-community]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'order,orderdate) VALUES ('04050040272009',' &' at line 1
The datatype for fields in table temp_save are:
fil_no-->INT(15)( to store a 15 digit number)
order-->LONGTEXT(to store contents from HTMLEditor(ajax control))
orderdate-->DATE(to store date)
[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 Replieshow 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 RepliesI'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.
I have some data which is in mySQL, i am not familier with mySQL, i would like to transfer all the data from MySQL to SQL Server database,
View 11 Repliesprotected void Button3_Click(object sender, EventArgs e)
{
//Create a connection to the database
MySqlConnection conn = new MySqlConnection("Database=kid07025;Data Source=195.178.228.254;User Id=kid07025;Password=********");
//open the connection
conn.Open();
//MySQL Query which updates the row where Anvandarnamn = Anvandarnamn (recieved from a cookie)
MySqlCommand cmd = new MySqlCommand("UPDATE personer SET Information=?Information,Fnamn=?Fnamn,Enamn=?Enamn,Personnr=?Personnr,Adress=?Adress,Postnr=?Postnr,Ort=?Ort WHERE Anvandarnamn=?Anvandarnamn", conn);
// Update with new text
cmd.Parameters.AddWithValue("?Anvandarnamn", Request.Cookies["Anvandarnamn"].Value);
cmd.Parameters.AddWithValue("?Information", TextBox1.Text);
cmd.Parameters.AddWithValue("?Fnamn", TextBox2.Text);
cmd.Parameters.AddWithValue("?Enamn", TextBox3.Text);
cmd.Parameters.AddWithValue("?Personnr",TextBox4.Text);
cmd.Parameters.AddWithValue("?Adress", TextBox5.Text);
cmd.Parameters.AddWithValue("?Postnr", TextBox6.Text);
cmd.Parameters.AddWithValue("?Ort", TextBox7.Text);
cmd.ExecuteReader();
conn.Close();
RefreshProfile();
}
I don't know what I am doing wrong here, but the database doesn't get updated when I press the button.
I use VS 2010, ASP.NET
i'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.
i was just using mysql i installed mysql and mysql net connector. its installed successfully but unable tp add to references.
View 3 RepliesIs 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]....
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'.
View 1 RepliesI 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.
View 9 Replies