Currently have a site coded in PHP but the customer wants to go to .NET. Can I use the existing MySQL DB or am I required to use MSSQL?
Check out this forum which is specialized for this kind of questions: ASP.NET MySQL forumBart De Smet [MVP]
Visit www.msdn.be, www.bartdesmet.net...Differnet access time of MySQL Connector.Net in Desktop and IIS Application -- Need help
I am using MySQL Connector.Net in my web application (.Net 3.5). I found that each query takes ~250 ms in my application. When I tried to run the same query from a Desktop application I found that the time ~80ms. Is there any way for tuning the IIS or what I am missing here?
If I could get the same speed as desktop application in my web application, my app would be 2X faster than current.
Thanks in advance for your help....HELP! using mysql .net ODBC data provider as backend for excel 2000 automation..
Ok, here's the deal.
I am trying very hard to use MySQL as a backend for ASP.NET development (which works fine), and trying to create a reporting section that generates excel reports using Excel 2000. Has anyone tried this and is it feasible. Needless to say I am running into all sorts of problems. The MySQL odbc .net provider works fine and is able to connect to the database. for all other regular asp.net programming. eg. populating listboxes, databinding the datagrids, datasets etc. works perfectly.
Enter excel 2000 reports; I have tried automating this through ASP.NET but it gives m...System.Net.Sockets.SocketException with MySQL Connector.NET
Hi. I already tried many things and spent already 2 days without any success. Please help or I'll hang myself.I am using MySql.Data.dll ver. 184.108.40.206 (runtime v2.0.50727) from my project (library). It works great if i use it from WindowsApplication but once i use it same way in WebApplication, it keeps throwing: The attempted operation is not supported for the type of object referencedException Details: System.Net.Sockets.SocketException: The attempted operation is not supported for the type of object referenced .. AsyncResult ias = socket.BeginConnect(endPoint, null, null);.. (or w...mysql and .net
i am new to .net and i am trying to setup a simple form. I am an open source person and what i am asking can be done easily using php and mysql; but i need to know how to do this in .net project asap.
i have three forms;
form1 submit to the database and redirect to form2 and form2 submit to the database and redirect to form3.
i want to grab mysql last inserted id from form1 to form2 while redirecting and pass it via the url. i am able to select from the database, but i don't know how to assign it to a variable; here is what i have so far:
str2 = "select last_ins...Net::MySQL
Anyone run into this problem=20
INSERT INTO dbname (table_name) VALUES ( $var )
The problem is, when I assign a value to a $var that value is ignored in =
the SQL statement. Ive tried every operator I know to get it to look at =
it and accept the value as input into the DB. Ive tried=20
( '$var' )
Any ideas ?
Kind regards...ERROR [HY000] [MySQL][ODBC 3.51 Driver]Can't connect to MySQL server on 'IP Address of the server'(10048) ERROR [HY000] [MySQL][ODBC 3.51 Driver]Can't connect to MySQL server on 'IP of the server' (10
Hi, I am randomly getting the following error message in my application.
ERROR [HY000] [MySQL][ODBC 3.51 Driver]Can't connect to MySQL server on 'IP Address of the server'(10048) ERROR [HY000] [MySQL][ODBC 3.51 Driver]Can't connect to MySQL server on 'IP of the server' (10048)
I am using .Net 2.0 with VS2005 having ODBC 3.51.14 Driver.
Can any body point out the core reasons of the above error message?
I do have the same problem, help me out.
If the going seems easy, You are going DownHill...
When I was writing ...Problems connecting to MySQL through MyODBC using ODBC.NET
Help ! Another learner...
I am trying to connect to mySQL through MyODBC using ODBC.NET and have the following setup on a W2K machine....
1. mySQL 4.0.15 database up and running (visible in Services). The DB is definitely there (I can see its contents through MySQL CC)
2. I have installed MySQL ODBC 3.51 Driver and created a User DSN called myDSN. I can connect to the database via the 'Test Data Source' (at least its telling me that I've connected...)
3. Using WebMatrix, I have the following declarations in place :
<%@ Page Language="VB" Debug="true" Com...Type.GetType does not work in VB.NET but works in C#. VB.NET gurus Please help
Friends, I am an experienced C# programmer who is working on a VB.NET project now. I am writing different methods covering the following functionalities 1) Take a datareader as input and return an arraylist of class object2) Take an xmlnode (received from a webservice) as input and return an arraylist of class object. The methods are generic methods which take datareader/xmlnode as first parameter and classname (string) as the second parameter. This way it will work trivially. The schema of class object matches with the input (datareader or xmlnode)In C# I used to do th...mySQL connector/net will work in development but not on webserver...help
i got mySQL connector/net v6.0 to finally work on my development computer. I uploaded the asp/vb page to my webserver, along with an added assembly reference in my web.config and updated the bin folder on the webserver, however i am gettting the error 'MySqlCommand' is ambiguous in the namespace 'MySql.Data.MySqlClient'.
anyone know how i can fix this?
my web.config looks like this
<assemblies> <add assembly="System.Core, Version=220.127.116.11, Culture=neutral, PublicKeyToken=B77A5C561934E089"/>  ...Changing MySQL connection from .net component to ODBC
Hi there, we've completed our project and managed to run everything smoothly locally.
However, when we uploaded all of the files online on our domain, it turns out that the database connection we used from MySQL to ASP.net is NOT SUPPORTED by our host.
We are currently using the .net MySQL Component.
Our host only supports ODBC connection.
We could change all our files and change the lines that uses that .net MySQL component to ODBC, however, that would take so much time that we don't have.
Anyone has any suggestions?
If no one does then I think it's best to re...connection Mysql C#.net in web.config problem help
webconfig this code <connectionStrings>
<add name="planku" connectionString="Server=localhost;user id=root;password=;database=planku;" providerName="mysql.data.mysqlclient"/></connectionStrings>
<system.web><sessionState timeout="60" cookieless="AutoDetect" regenerateExpiredSessionId="true"/>
<compilation debug="true" strict="false" explicit="true"><assemblies>
<add assembly="System.Design, Version=18.104.22.168, Culture=neutral, Publ...Net:Net:Net::LDAP::FAQ
Is there a possible to LDAP bind with an encrypted (SHA, SSHA, CRYPT,
....) password? I don't like to write the secret password to the perl
Wilbert Barbara (CI/OSI) * wrote:
> Is there a possible to LDAP bind with an encrypted (SHA, SSHA, CRYPT,
> ......Possible to connect the SqlDatasource with MySQL Connector/NET or is a ODBC driver required?
Hi, I am using the MySQL Connector/NET 22.214.171.124 right now to use all the membersip stuff with my MySQL 5.0 database and it works great. Now I want to test this example http://www.asp.net/learn/videos/video-07.aspx (databinding a gridview to a datasource and enable editing) with my new MySQL-Connection. But when I want to choose a connection for my SqlDataSource there is no connection listed even though I have a connection in my web.config which already works with the membership stuff. This is my connection string: 1 <connectionStrings>2 <add na...