VB.net (classic ASP Page) Connects To The MySQL Server

Apr 9, 2010

I have a classic ASP page that connects to the mySQL server with the following code:

Set oConnection = Server.CreateObject("ADODB.Connection")
Set oRecordset = Server.CreateObject("ADODB.Recordset")
oConnection.Open "DRIVER={MySQL ODBC 3.51 Driver}; SERVER=xxx.com; PORT=3306; DATABASE=xxx; USER=xxx; PASSWORD=xxx; OPTION=3;"
sqltemp = "select * from userinfo WHERE emailAddress = '" & theUN & "'"
oRecordset.Open sqltemp, oConnection,3,3
if oRecordset.EOF then
...

However, i am unable to find anything to connect to mySQL in ASP.NET (VB.NET). I have only found this peice of code that does not seem to work once it gets to the "Dim conn As New OdbcConnection(MyConString)" code:

Dim MyConString As String = "DRIVER={MySQL ODBC 3.51 Driver};" & _
"SERVER=xxx.com;" & _
"DATABASE=xxx;" & _
"UID=xxx;" & _
"PASSWORD=xxx;" & _
"OPTION=3;"
Dim conn As New OdbcConnection(MyConString)
conn.Open()
Dim MyCommand As New OdbcCommand
MyCommand.Connection = MyConnection
MyCommand.CommandText = "select * from userinfo WHERE emailAddress = '" & theUN & "'""
MyCommand.ExecuteNonQuery()
MyConnection.Close()
I have these import statements also:
<%@ Import Namespace=System %>
<%@ Import Namespace=System.IO %>
<%@ Import Namespace=System.Web %>
<%@ Import Namespace=System.ServiceProcess %>
<%@ Import Namespace=Microsoft.Data.Odbc %>
<%@ Import Namespace=MySql.Data.MySqlClient %>
<%@ Import Namespace=MySql.Data %>
<%@ Import Namespace=System.Data %>
The error is as follows:
Compiler Error Message: BC30002: Type 'OdbcConnection' is not defined.
Source Error:
Line 121: "OPTION=3;"
Line 122:
Line 123: Dim conn As New OdbcConnection(MyConString) '<--error line
Line 124: conn.Open()
Line 125:

EDIT: GOT IT WORKING USING THIS WAY

Dim MyConString As String = "DRIVER={MySQL ODBC 3.51 Driver};" & _
"SERVER=xxx.com;" & _
"DATABASE=xxx;" & _
"UID=xxx;" & _
"PASSWORD=xxx;" & _
"OPTION=3;"
Dim conn As OdbcConnection = New OdbcConnection(MyConString)
conn.Open()
Dim MyCommand As New OdbcCommand
MyCommand.Connection = conn
'MyCommand.CommandText = "INSERT INTO tablename VALUES("val1","val2","val3")"
'MyCommand.ExecuteNonQuery()
conn.Close()
AND WITH THE mysql.data.DLL IN PLAY
Dim MyConString As String = "DRIVER={MySQL ODBC 3.51 Driver};" & _
"SERVER=xxx.com;" & _
"DATABASE=xxx;" & _
"UID=xxx;" & _
"PASSWORD=xxx;" & _
"OPTION=3;"
Dim conn As New MySqlConnection(MyConString)
conn.Open()
Dim MyCommand As New MySqlCommand
MyCommand.Connection = conn
'MyCommand.CommandText = "INSERT INTO tablename VALUES("val1","val2","val3")"
'MyCommand.ExecuteNonQuery()
conn.Close()

View 3 Replies


Similar Messages:

Write A Application Which Connects To Remote Server(windows 2003 Server

Jan 17, 2011

I have to write a application which connects to remote server(windows 2003 server, open SQL Management studio in that server and enter a specific SQL Server address and access a stored procedure, change some values and execute the stored procedure.)

I have to write this application using C#.Net , Could anybody point me in right direction, Where do I start?

View 6 Replies

C# - Windows Service Connects To A Server To Download Some Files?

Jul 9, 2010

There are three serves on the same zone. 172..*.**

Suppose that their names are A,B and C

The server A has a windows service, and it downloads the files from the server of C, in the folder of images. It used to give errors about access-denied then we assign full control to everyone on the folder of images on the server C. Then it was ok.

Now the same windows service runs on the server B, and ,t gets the same things from images folder of the server C. But there is an error about access-denied.

What should I do for the required steps to make the server B be able to connect the server C and download the files?

**The error: Exception:Access to the path '172..*.images' is denied.

172...* aka the server C*

View 1 Replies

Configuration :: Visual Studio Development Server Connects But IIS Failed With Error

Jun 16, 2010

I wrote a web service to send emails and some win apps supossed to call the service for sending emails. When I test the service via Visual studio development server everything is ok and it sends emails. But with IIS the smtpclient.send throw an exception whit this message : No connection could be made because the target machine actively refused it [mailserver ip:port] The endpoint for VS development server is [URL] and for iis [URL] The smtp server is remote (gmail) and iis version is 6. I set the current local user as iis anonymous user. I am in LAN and my client firewall is off. There is an ISA server for the internet but I'm using a dialup connection for the internet. So why visual studio can send emails but iis can't?

View 5 Replies

Insert Html Pages To MySQL - Error "check Manual That Corresponds To MySQL Server Version For The Right Syntax"

Oct 7, 2010

I am trying to insert html pages to MySQL with my Asp.NET project but i am getting error; 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 'de Osman patlaması', '', '<div style="text-align: center"> <img src="/i' at line 1

How can i fix that problem my server side code is;

MySqlConnection myCon = new MySqlConnection();
myCon.ConnectionString = ConfigurationManager.ConnectionStrings["MySQLConnectionString"].ConnectionString;
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = CommandType.Text;
string query = @"INSERT INTO `test`.`posts` (`id`, `author`, `title`, `description`, `content`, `ispublished`, `iscommentsenabled`, `pubDate`, `lastModified`, `raters`, `rating`, `slug`, `tags`, `categories`) VALUES (NULL, '{0}', '{1}', '{2}', '{3}', '{4}', '{5}', '{6}', '{7}', '{8}', '{9}', '{10}', '{11}', '{12}')";
query = String.Format(query, p.author, p.title, p.description, p.content, p.ispublished, p.iscommentsenabled, p.pubDate, p.lastModified, p.raters, p.rating, p.slug, p.tags, p.categories);
cmd.CommandText = query;
cmd.Connection = myCon;
cmd.Connection.Open();
cmd.ExecuteNonQuery();
cmd.Connection.Close();..............

View 2 Replies

Web Forms :: Redirecting An ASPX Page To A Classic ASP Page Method?

May 21, 2010

I am trying to redirect an ASPX Page to a Classic ASP Page, This is Working Fine with my Local IIS (version 5.1). OS is XPesponse.Redirect("xyz.asp?id=1234");I tried to deploy it into Windows server 2003, IIS Version 6.0 and i am getting an error"Page Cannot be Displayed. here is a problem with the page you are trying to reach and it cannot be displayed."

View 2 Replies

Asp Classic - Mimic Server.URLEncode?

Jan 6, 2010

In ASP:
Server.URLEncode("+&(). -*<>/|")
' returns %2B%26%28%29%2E+%2D%2A%3C%3E%2F%5C%7C
In ASP.NET
Uri.EscapeDataString("+&(). -*<>/|")
// returns %2B%26().%20-*%3C%3E%2F%5C%7C
HttpUtility.UrlEncode("+&(). -*<>/|")
// returns %2b%26().+-*%3c%3e%2f%5c%7c

Is there any elegant way how to mimic old ASP behavior in ASP.NET?

View 2 Replies

Databases :: Using Mysql Installed Mysql And Mysql Net Connector?

Dec 26, 2010

i was just using mysql i installed mysql and mysql net connector. its installed successfully but unable tp add to references.

View 3 Replies

Calling .NET Page From A Classic ASP Page On The Same Machine?

Jun 3, 2010

I am attempting to call an ASP.NET page from a classic ASP page on the same machine. The ASP page is located in c:inetpubwwwroot. The ASP.NET page is located in C:InetpubwwwrootWebServiceWrapper

Here is the ASP code to call the page:

Dim objHttp, strQuery
set objHttp = Server.CreateObject("Msxml2.ServerXMLHTTP")[code]....

The ASP.NET code, which calls a web service and sets a cookie, works if I call it from the browser directly. However, using the Msxml2.ServerXMLHTTP object, it does not. The cookie is not generated and there is no error. There are no events in Event Viewer.The ASP.NET page was developed in Visual Studio 2005, .NET 2.0. Changing the POST to a GET has not helped.

View 3 Replies

Retrieve Data From Classic Asp From Page?

Jul 29, 2010

I have an asp page with an input/text field and an anchor/href that links to an aspx page. What I want is to populate the label control on my aspx page with the value entered in the input/text field. How would I do that?

View 1 Replies

How To Call A Classic Page From A MVC Action

Apr 21, 2010

I am using StructureMap with ASP.NET MVC. I have a requirement where I need to show a ReportViewer and for that I am using a classic ASP.NET page. The problem is when I am trying to redirect from the action I am getting following issue:

The IControllerFactory 'StructureMapControllerFactory' did not return a controller for the name 'Reports.aspx'.

View 2 Replies

Include Classic File In Asp Page?

Jan 31, 2011

I would like to include the asp clasic file in asp.net page. I am looking for something similar to :

<!-- #include file="inc.config.asp" -->

View 6 Replies

Classic ASP Error - The Page Cannot Be Found?

Jan 6, 2011

I know i'm not in the right spot to post this. I hope someone experienced this before and can help.I have an old classic asp website. I try to run it with localhost/foldname/default.asp but it gives me 404 error:

[Code]....

a) I'm running XP 64 bitsb) Classic ASP is checked in Add/Remove Windows Component
c) "Active Server Pages" is set to Allowed in IIS Web Service Extension
d) .asp is mapped in the Application ConfigurationNo luck so far!!! Accessing a HTML file within the same folder work, but not the ASP page.

View 1 Replies

C# - Can Post Values To Classic ASP Page When Debugging

Jun 21, 2010

I have a classic ASP page that requires two values from a form. These values are posted to the ASP page from another pages form. I would like to pass these values to the ASP page without the need for a form for testing. Is this possible?This is what the asp page looks like:

<%@LANGUAGE="JavaScript"%>
<%
var someID = new String( Request.Form("someID") );
var anotherID = new String( Request.Form("anotherID") );
%>

Ideally I would like to have VS pass values to 'someID' and 'anotherID' when debugging is started.

View 4 Replies

Web Forms :: Duplicating Behaviour From A Classic Asp Page

Jun 2, 2010

Many years ago I built a website for a customer in classic asp that uses RomanCart as the payment gateway. This has worked very well, but ive now been given the task of rebuilding the site under .net 3.5 the old site used a submit button that set the action to the romancart url and setup some hidden field values. I want to duplicate this behaviour in the .aspx page from the onclick event of a button. Heres the origianl code from the classic asp page.Can Anyone give some some pointers in converting this to c#?

View 13 Replies

Web Forms :: Ajax Enable The Classic ASP:Calendar Server Component?

Sep 19, 2010

Ajax enable the classic ASP:Calender server component?

View 1 Replies

AJAX :: Is It Possible To Use A Classic Asp Page To Return Parameters Back The Same As A .NET Web Service

Jun 2, 2010

I have site that I need to have a vendor send an Http Post to us, using querystring parameters, then I have to look up some data and return a few results and parameters back to them. Can this be done using CLASSIC ASP? I ask this because I am still in a learning phase with .NET and have limited resources available to set up a web service.

View 2 Replies

Security :: How To Have A Page Do Single Sign On To An Iframed Classic Login Form

Jan 15, 2010

I have this .net page that is iframing a page that requires username and password. Does any one know if a way i can provide this page the username and password behind the scenes and autologin the user (from thier eyes at least)?

The calling page is a ..NET page but the page that I am iframing in is a classic ASP page.

I was told that i may have to do something like create a security auth ticket and pass the token which I am not sure how to do or even start

View 1 Replies

Set Previously Selected Radio Button Checked In Classic After Page Is Postbacked?

Jun 9, 2010

I have never worked on classic ASP and unfortunately i am supposed to modify an old classisc ASP web site.

ASP.Net ViewState does take care of maintaining control's sate automatically. How do i do it in classic ASP ?

I have two radio buttons and a text box placed on my ASP page, when user types in something in the text box based on radio button selection we display different search results. Now what i need is to keep the previously selected radio button as checked after the page is postbacked. How do i do that ?

View 1 Replies

Mono + Mysql = Slow - Inserts 26,000 Records Into A Mysql Database

Dec 16, 2010

Why 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 Replies

Databases :: MYSQL Using VB With VWD2008 For MYSQL Data Transactions

Jan 11, 2010

I have used ASD.NET code using SQL Database for Transaction operation successfully. By changing the Database Code to interface with MYSQL an Error occurs. If I remove the Transaction Code from within the the application, it works OK by displaying the MYSQL data (Read Only) in the layout of the application. I am using Mysql Essential-4.1.22-win32 and MYSQL Connector ODBC-3.51.2. My objective is to EDIT the MYSQL Data.

View 8 Replies

ADO.NET :: How To Use MySQL As Database Server

Feb 10, 2011

I want to use MySQL as database server for my ASP.net website but don't know how can I write connection string for connecting database.

View 1 Replies

How To Connect Mysql Server With 2008

Feb 5, 2010

How to connect Mysql server (free one) with Asp.net 2008.

View 1 Replies

Linq - Database Is Not Only SQL Server..MYSQL

May 15, 2010

I watched many videos about using LINQ to SQL, I am happy I learned something,but is it the good way of using is: dragging and dropping and that's done???what are the best practices to use LINQ to access Database ( my database is not only SQL server..MYSQL..)

View 1 Replies

Databases :: Get MYSQL Server Error?

Apr 6, 2010

<add key="DatabaseString" value="DRIVER={MySQL ODBC 5.1 Driver};SERVER=PARAM;DATABASE=SiteForum;UID=root;PASSWORD=root;OPTION=3;" />
<add key="DatabaseType" value="MySQL" />System.Data.Odbc.OdbcException: ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified.
System.Data.Odbc.OdbcException: ERROR [IM002] [Microsoft][ODBC Driver Manager

View 1 Replies







Copyrights 2005-15 www.BigResource.com, All rights reserved