Our solution to this was installing myODBC on the NT Server and connecting
in this fashion:
Dim Conn_STRING
Conn_STRING =
"driver={mysql};database=dbname;uid=uname;pwd=password;option=16386;"
set rsRecordSet = Server.CreateObject("ADODB.Recordset")
rsRecordSet.ActiveConnection = Conn_STRING
This assumes VBScript
On an off note, I suggest you make the connection string an include file, so
that if the name changes or the pw changes or whatever, you will not have to
change every page in your site.
Hope this helps you,
Dave Carter
Chief Web Architect
Accelerated Business Technologies, Inc.
http://www.abti.cc
717.464.2970
-----Original Message-----
From: ASHUTOSH SHARMA [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 18, 2001 7:51 AM
To: [EMAIL PROTECTED]
Subject: problem regarding ASP+MySQL in NT with IIS (web server)
respected sir,
i have a problem regarding connectivity between ASP and mysql.....
will it possible to connect asp with mysql if yes then how we can do it
....
will it need any driver if yes then from where we get that driver ..
will i get some tutoril in this matter...
thanking you
ashutosh
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail
<[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php