From owner-freebsd-questions@FreeBSD.ORG  Tue May  6 18:51:45 2003
Return-Path: <owner-freebsd-questions@FreeBSD.ORG>
Delivered-To: freebsd-questions@freebsd.org
Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125])
	by hub.freebsd.org (Postfix) with ESMTP id 4A01B37B401
	for <freebsd-questions@freebsd.org>;
	Tue,  6 May 2003 18:51:45 -0700 (PDT)
Received: from flamingo.mail.pas.earthlink.net
	(flamingo.mail.pas.earthlink.net [207.217.120.232])
	by mx1.FreeBSD.org (Postfix) with ESMTP id 9CAE443F85
	for <freebsd-questions@freebsd.org>;
	Tue,  6 May 2003 18:51:44 -0700 (PDT)
	(envelope-from mbaki@whywire.net)
Received: from user-119apb3.biz.mindspring.com ([66.149.101.99]
	helo=nebula.whywire.net)
	by flamingo.mail.pas.earthlink.net with esmtp (Exim 3.33 #1)
	id 19DE5u-0000sO-00
	for freebsd-questions@freebsd.org; Tue, 06 May 2003 18:51:43 -0700
Received: from whywire.net ([10.0.3.192])
	by nebula.whywire.net (8.12.2/8.12.2) with ESMTP id h471cEfu007292
	for <freebsd-questions@freebsd.org>;
	Tue, 6 May 2003 21:38:19 -0400 (EDT)
Date: Tue, 6 May 2003 21:51:20 -0400
Mime-Version: 1.0 (Apple Message framework v552)
Content-Type: text/plain; charset=US-ASCII; format=flowed
From: Monah Baki <mbaki@whywire.net>
To: freebsd-questions@freebsd.org
Content-Transfer-Encoding: 7bit
Message-Id: <66300786-802E-11D7-A7EC-00039313E976@whywire.net>
X-Mailer: Apple Mail (2.552)
Subject: Freebsd+Mysql+ASP
X-BeenThere: freebsd-questions@freebsd.org
X-Mailman-Version: 2.1.1
Precedence: list
List-Id: User questions <freebsd-questions.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>,
	<mailto:freebsd-questions-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-questions>
List-Post: <mailto:freebsd-questions@freebsd.org>
List-Help: <mailto:freebsd-questions-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>,
	<mailto:freebsd-questions-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Wed, 07 May 2003 01:51:45 -0000

Hi All,

This might be off topic, but is it possible to migrate ASP files to 
FreeBSD running iASP/MySQL/unixODBC and MyODBC. I installed all the 
above applications. The asp file are hosted on the FreeBSD machine.

Here's my problem now.
The client has the following file called nnoc.asp. The nnoc.asp file 
mentioned below is a include file that specifies the DSN and this is 
where we are having problems.


<%
dim conn
set conn = Server.CreateObject("ADODB.Connection")
connstr="DSN=matmysql;UID=root;PWD=welcome;"
conn.open connstr
conn.open "matrimonial","root","welcome"
conn.Open "Driver=MySQL; Server=localhost; Port=3306; Option=0;
Socket=; Stmt=; Database=matrimonial; Uid=root; Pwd=welcome;"

%>

Whenever I try to connect through a browser, I get this error:

Vbscript Runtime error 'ASP 0185 : 3219'
No suitable driver
nnoc.asp ,line 5

Is it possible for all of this to work together or should I find 
another alternative


Thank you