List:MySQL on Win32« Previous MessageNext Message »
From:SGreen Date:August 6 2004 2:55pm
Subject:RE: Microsoft's ASP/SQL combo
View as plain text  
What I have here is a basic template of creating and using a DSN-less 
connection from an ASP page (using VBScript) through ADO through an ODBC 
driver into a MySQL database. I would refer you to the ADO documentation 
if you need more specifics about other options (like setting the cursor 
location (server, client), recordset types (static, dynamic, keyset, etc), 
recordset locking (read-only, batch-optimistic, etc.), retrieving the 
results, etc) This script, as written, should be executed on the server 
but could also run from a client running MSIE (assuming they also have the 
ODBC driver and the networking ability to reach the server) or from a 
system script (on either machine).  If you do run this as a system script 
you will need to change "Server.CreateObject" to "WScript.CreateObject" as 
it is executed by a different engine (not by ASP.DLL but WSCRIPT. EXE or 
CSCRIPT.EXE, depending on how it's called).

I am cross-posting this to the Win32 list in hopes that it may be helpful 
there, too.

Option Explicit

Dim oConn,sConn
Dim rsData, sSQL

set oConn = Server.CreateObject("ADODB.Connection")
set rsData = Server.CreateObject("ADODB.Recordset")

sConn = "Driver={MySQL ODBC 3.51 
Driver};SERVER=127.0.0.1;DATABASE=your_database_name;UID=a_valid_MySQL_account;PASSWORD=a_valid_password"
oConn.open sConn
sSQL = "SELECT list_of_some_fields FROM some_table(s) WHERE 
something_to_be_true"
rsData.open sSQL, oConn

You may need to adjust the DRIVER={} phrase to match what you have on your 
system. The SERVER= can take either an IP address (faster) or a DNS name 
(sometimes more flexible). (I always use IP addresses whenever I can.)

Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine




Scott Hamm <ScottHam@stripped> wrote on 08/06/2004 09:51:00 AM:

> Sorry, Connecting M$ ASP to MySQL is what I meant. (just noticed the
> misunderstanding statement in subject line. My apologies)
> -----Original Message-----
> From: SGreen@stripped [mailto:SGreen@stripped]
> Sent: Friday, August 06, 2004 9:46 AM
> To: Scott Hamm
> Cc: 'Mysql ' (E-mail)
> Subject: Re: Microsoft's ASP/SQL combo

> 
> Scott, 
> 
> I think you posted to the wrong group ;-). This is the group for 
> MySQL not MS SQL Server (two totally different products)! 
> 
> You can find MANY examples for making ASP connections from the MSDN 
> site (that's where I got all of mine the first few times I needed to
> make them work). 
> 
> http://msdn.microsoft.com/ 
> 
> Use the search features. It will probably take you two or three 
> tries to figure out exactly _how_ to ask for what you need. IMHO, MS
> has done a crappy job of keeping their information organized and 
> available. There are several different libraries you can use to 
> connect your ASP site (BTW, you never said if you were using 
> Jscript, VBScript, PERL, PHP, somekinda-dot-net-language...) to an 
> MS SQL Server database (or to several other database for that matter) 
> 
> IF you are trying to connect to a MySQL database... that's a 
> different story (but you still didn't say which language you were using) 

> 
> Shawn Green
> Database Administrator
> Unimin Corporation - Spruce Pine 
> 
> Scott Hamm <ScottHam@stripped> wrote on 08/06/2004 07:11:49 AM:
> 
> > Do anyone have an ASP website that acquires info from SQL Database? I 
would
> > like to see an sample file to see how it acquires info from SQL 
Database for
> > my future Database project that I'm currently researching on....
> > 
> > 
> > Thanks in advance,
> > 
> > 
> > Scott
> > 
> > -- 
> > MySQL General Mailing List
> > For list archives: http://lists.mysql.com/mysql
> > To unsubscribe: http://lists.mysql.com/mysql?unsub=1
> > 
Thread