IIS, ASP, MySQL (was: database pooling problem)
On Monday, Mar 7, 2005, at 16:04 US/Central, [EMAIL PROTECTED] wrote: It would be happy to try to help if I worked in or on either of those platforms (Apache + Java). I am Win32(IIS), ASP (VBScript/JavaScript) using MyODBC as my connection library. Is using MyODBC the accepted way to connect to a MySQL database from within an ASP/VBScript page? Or is there some other way? For example, PHP has a connector that can directly connect to a MySQL database. Regards, - Robert http://www.cwelug.org/downloads Help others get OpenSource software. Distribute FLOSS for Windows, Linux, *BSD, and MacOS X with BitTorrent -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: IIS, ASP, MySQL (was: database pooling problem)
Robert Citek [EMAIL PROTECTED] wrote on 04/06/2005 10:55:07 AM: On Monday, Mar 7, 2005, at 16:04 US/Central, [EMAIL PROTECTED] wrote: It would be happy to try to help if I worked in or on either of those platforms (Apache + Java). I am Win32(IIS), ASP (VBScript/JavaScript) using MyODBC as my connection library. Is using MyODBC the accepted way to connect to a MySQL database from within an ASP/VBScript page? Or is there some other way? For example, PHP has a connector that can directly connect to a MySQL database. Regards, - Robert http://www.cwelug.org/downloads Help others get OpenSource software. Distribute FLOSS for Windows, Linux, *BSD, and MacOS X with BitTorrent MyODBC is but one way to connect code to server. I am not running ASP.NET servers so I don't use the .NET Connector. There was another project or two (like the .Net Connector) that was written for VB. I found a copy of the source of one of them but all of the projects I have found seem to be abandoned (which means, you are responsible for your own support). The C++ API is packaged with the server) Since I don't have time to update these legacy connectors to keep up with the new server technology (Views, SPROCS, INFORMATION_SCHEMA, 4.1+ password hashing, etc) and I don't have enough time to debug it when I get it wrong (which everyone does), I decided to go with the tested and prepackaged MyODBC. Now, if anyone else has or knows of a product that will work from ASP (not ASP.Net) or VB (not VB.NET) and doesn't require the .NET runtime library to be installed I would love to hear from you. Please respond to the list so that everyone has a chance to get in on it, too. Thanks, Shawn Green Database Administrator Unimin Corporation - Spruce Pine PS. I am sure that if I tried really hard, I could call a compiled version of the C++ API from VB but I don't want to go through the motions of converting all of the APIs function calls into VB declare statements. I have thought about it, but decided against it. Once again, it's a matter of time and support. - S
Re: IIS, ASP, MySQL (was: database pooling problem)
On Wed, 2005-04-06 at 09:55 -0500, Robert Citek wrote: Is using MyODBC the accepted way to connect to a MySQL database from within an ASP/VBScript page? Or is there some other way? For example, PHP has a connector that can directly connect to a MySQL database. I believe it's the only one currently maintained. -- Florin Andrei http://florin.myip.org/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ASP/MYSQL
Hello members,
I'm new to mysql and need to conect to from ASP pages.
I have written the following code in ASP script
!- #include file=C:\PROGRAM FILES\COMMON FILES\SYSTEM\ADO\adovbs.inc -
%
dim email,objrs,strsql,strconn
email=Request.Form (email)
strconn = DSN=ebyte
strsql=select * from log where email=(' email ');
set objrs=server.CreateObject (adodb.recordset)
With objrs
.ActiveConnection = strconn
.Source = strsql
.Open
End With
Response.Write objrs(email)
Set objrs = Nothing
%
i get the following error msg on the browser
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Driver Manager] Data source name not found and no default
driver specified
i have checked the dsn and the adminstrator say its fine.
Background info
mysql installed on linux server and site hosted on iis server on windows
2000
- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, November 04, 2002 9:57 AM
Subject: getting around a subselect
As a novice in (My)sql I encounter this problem:
I would like to select from a table first the 39 records with the highest
variable1 and order them on variable2.
So I need something like a subselect and I can't figure out a way around
it.
Ideally something like:
select * from table1 order by var2 in (select * from table1 order by var1
limit
0,39);
Best regards
Hein
-
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
Re: Blobs+ASP+MySQL
Why store the pic in the DB? I know there is an ASP upload utility avaliable. Try www.asp101.com or www.hotscripts.com HTH Mark -Original Message- From: Zill-e-Hassan [EMAIL PROTECTED] To: [EMAIL PROTECTED] [EMAIL PROTECTED] Date: Thursday, April 25, 2002 1:48 PM Subject: Blobs+ASP+MySQL Dear All I have been trying to find out if there is a way of actually storing pictures as Blobs in MySql . Eventually i want to upload and download pictures to/from the database through the use of ASP. I would also welcome any suggestions that you guys may have regarding how to upload the image file from my ASP page. I do not want to store the reference. I want to store the whole picture. In addition to that , i would also like to find out if I can store blobs in the database through SQL command. Any Ideas ??? Insert .. - 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
Blobs+ASP+MySQL
Dear All I have been trying to find out if there is a way of actually storing pictures as Blobs in MySql . Eventually i want to upload and download pictures to/from the database through the use of ASP. I would also welcome any suggestions that you guys may have regarding how to upload the image file from my ASP page. I do not want to store the reference. I want to store the whole picture. In addition to that , i would also like to find out if I can store blobs in the database through SQL command. Any Ideas ??? Insert .. - 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
RE: Blobs+ASP+MySQL
I would be interested in this too. With a corollary: does anyone know of a small script other than java applets that would effectively place a freehand drawtool on the webpage, and capture the resulting image for insertion as a db blob? Andrew Hazen -Original Message- From: Zill-e-Hassan [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 25, 2002 4:02 PM To: [EMAIL PROTECTED] Subject: Blobs+ASP+MySQL Dear All I have been trying to find out if there is a way of actually storing pictures as Blobs in MySql . Eventually i want to upload and download pictures to/from the database through the use of ASP. I would also welcome any suggestions that you guys may have regarding how to upload the image file from my ASP page. I do not want to store the reference. I want to store the whole picture. In addition to that , i would also like to find out if I can store blobs in the database through SQL command. Any Ideas ??? Insert .. - 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
RE: Blobs+ASP+MySQL
This is quite easy. SciBit developed an ASP COM Object called MySQLX (http://www.scibit.com/MySQLX) which does exactly what you want, this component is almost two years old now and is very stable and used world-wide in many applications/webs including real-time apps. The help is a bit sparse, but ALL the samples including submitting and displaying BLOB images in ASP from MySQL is in ASP/VBScript and available in the install directory. This component also includes functions for: * Escaping and Hexing data ready for a sql statement * Utility functions like FormatDateTime, etc. * SMTP an email with or without attachments :) * Easily create and convert mysql tables to webtables with 1 ASP call. * Generate PDF,XLS,RTF reports designed with Mascon (http://www.scibit.com/Mascon) live to the browsing client and you can even attach this report as PDF to an email and sent it in the same move, without using any files (samples included, no batteries though;) * etc, etc, etc. really too many to mention To answer more questions: You should really use the hex method (see MySQL Docs) for submitting BLOB/TEXT data to MySQL in any client app this solves a lot of headaches for escaping and converting data. Your MySQL has a variable called max_packet_size which defaults to 1Mb (maximum size of a single sql statement) though and you should set this to its maximum of 16Mb. Because of the Hex data each byte becomes two characters in the sql statement so you would then effectively be limited to 8Mb images, which in most cases should be fine for most webbased JPG, etc. NOTE: If you don't set this variable you will be limited to only 500Kb images and you will get a MySQL client error MySQL server has gone away! (seriously;-) if you try to go larger. Live samples of MySQLX can also be interactively viewed and used at the website: http://www.scibit.com/MySQLX. BTW the report samples is REALLY live and generated to PDF from a live MySQL server when you click them and not links to PDF files. Although this is a commercial product it is rather cheap at $89 if you consider you get a direct mysql data accessing/editing component (no ODBC, just you MySQL and the open road), email component, live PDF report generating, mysql table to webtable converting, mysql table to formtable converting components all in one. To see a real world application look at a sample of what SciBit developed for an Anglo American company called Anglo Platinum: http://www.scibit.com/sepix everything you see in this webbased app sample is from a sample MySQL database and accessed only with MySQLX. From the tables, PDF reports to the images (in BLOBs and in files on the web server) Seeing that I wasted all this time and space and you are still reading, you are interested in what you're reading. So I can just as well mention that this email was sent with MyLook (http://www.scibit.com/MyLook) which is a groupware mysqlbased outlook type application written in Delphi/Kylix using our components (http://www.scibit.com/MySQLComponents). Kind Regards SciBit MySQL Team -Original Message- From: Zill-e-Hassan [EMAIL PROTECTED] To: [EMAIL PROTECTED] [EMAIL PROTECTED] CC: Subject: Blobs+ASP+MySQL Sent: Thu, 25 Apr 2002 20:02:19 GMT Received: Thu, 25 Apr 2002 19:56:05 GMT Dear All I have been trying to find out if there is a way of actually storing pictures as Blobs in MySql . Eventually i want to upload and download pictures to/from the database through the use of ASP. I would also welcome any suggestions that you guys may have regarding how to upload the image file from my ASP page. I do not want to store the reference. I want to store the whole picture. In addition to that , i would also like to find out if I can store blobs in the database through SQL command. Any Ideas ??? Insert .. - 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
help with asp/mysql
this is driving me mental, I'm using asp and mysql, I'm running a query and getting back these two records when running the query manually through mysqlfront , productid 5325301445 5325301446 when the page executes the query i get back a single result 1030334149 which doesnt actually exist in the database! anyone got any ideas? I know the query is being run , and its going to the right database , as I'm writing them to the page directly before the query is run and the results are written to the page. ___ Sean O'Donnell Sentia Technologies Ltd. Sentia House 104 Coolmine Business Park Dublin 15 Ireland e-mail [EMAIL PROTECTED] web http://www.sentia.ie phone + 353 1 821 9020 fax + 353 1 821 9025 mobile + 353 86 854 3389 - 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
RE: help with asp/mysql
whoops, the sql is select distinct product.productid from product,productdetails where product.productid=productdetails.productid and product.recordstatus='O' and product.recordstatus='O' and productdetails.price= 1234.673264 and productdetails.price= 0 and (product.instore = 0 or product.instore = 0) limit 0, 10 I know there are some redundant sections in the sql but the statement is being generated on the fly, and i dont think that they would account for this effect. -Original Message- From: Sean O'Donnell Sent: 08 April 2002 06:36 To: [EMAIL PROTECTED] Subject: help with asp/mysql this is driving me mental, I'm using asp and mysql, I'm running a query and getting back these two records when running the query manually through mysqlfront , productid 5325301445 5325301446 when the page executes the query i get back a single result 1030334149 which doesnt actually exist in the database! anyone got any ideas? I know the query is being run , and its going to the right database , as I'm writing them to the page directly before the query is run and the results are written to the page. ___ Sean O'Donnell Sentia Technologies Ltd. Sentia House 104 Coolmine Business Park Dublin 15 Ireland e-mail [EMAIL PROTECTED] web http://www.sentia.ie phone + 353 1 821 9020 fax + 353 1 821 9025 mobile + 353 86 854 3389 - 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
Problem with ASP + mySQL
Dear all, I am having the following problem with ASP + mySQL Actually, when executing the following Query: SELECT Min(Col1), Col2 FROM Table1 GROUP BY Col2 I get an empty recordSet, while executing the following query doesn't return an empty recordSet: SELECT Col1,Col FROM Table1 GROUP BY Col1 I am connection using: RS.Open SQLQuery, Connection Can someone help? Thanks, Jimmy __ Send a friend your Buddy Card and stay in contact always with Excite Messenger http://messenger.excite.com - 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
Re: Problem with ASP + mySQL
I think the query should be as below SELECT Min(Col1) as Col1, Col2 FROM Table1 GROUP BY Col2 then somewhere in your page, response.write(rs(Col1)) Thanks ST Ooi Malaysia - Original Message - From: Jimmy44 -- [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, December 05, 2001 5:39 AM Subject: Problem with ASP + mySQL Dear all, I am having the following problem with ASP + mySQL Actually, when executing the following Query: SELECT Min(Col1), Col2 FROM Table1 GROUP BY Col2 I get an empty recordSet, while executing the following query doesn't return an empty recordSet: SELECT Col1,Col FROM Table1 GROUP BY Col1 I am connection using: RS.Open SQLQuery, Connection Can someone help? Thanks, Jimmy __ Send a friend your Buddy Card and stay in contact always with Excite Messenger http://messenger.excite.com - 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
recordset - sequence error (asp-mysql)
Hi all, I created a table like this create table t_table ( id INTEGER PRIMARY KEY NOT NULL AUTO_INCREMENT , name TEXT NOT NULL, description TEXT ); the table contains some records but the description fields defaults to null for all the records allready entered In asp (iis5) I loop till EOF adodataconnection ... ... Set recordset = adodataconnection.Execute (select * from t_table) recordset.MoveFirst Do Until recordset.EOF ... recordset.MoveNext Loop recordset.MoveFirst' - sequence error recordset.Close I get a sequence error when I try to go back to the first record however if i enter ONE record with a description .. it works Is there anyone out there that can point out the logic behind this ? Thanks in advance Dirk Vermeer - 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
ASP MySQL
I'm developing an application and I have to choose a good database server. I'm considering MS SQL Server and MySQL. I haven't heard very much about MySQL, but from I've read on the web I think MySQL is Unix/Linux orientated and works well with PHP. I'm going to use a NT platform, with the IIS as web server, and I wanted to use ASP. Does MySQL fit good with IIS and ASP? Thaks. ___ Consigue tu e-mail gratuito TERRA.ES Haz clic en http://www.terra.es/correo/ - 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
Re: ASP MySQL
YES!!! I use ASP and MySQL... Works Great (Win2K, IIS5.0) John (www.smalltownworld.com) - Original Message - From: L_U_I_Z [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, September 10, 2001 2:08 PM Subject: ASP MySQL I'm developing an application and I have to choose a good database server. I'm considering MS SQL Server and MySQL. I haven't heard very much about MySQL, but from I've read on the web I think MySQL is Unix/Linux orientated and works well with PHP. I'm going to use a NT platform, with the IIS as web server, and I wanted to use ASP. Does MySQL fit good with IIS and ASP? Thaks. ___ Consigue tu e-mail gratuito TERRA.ES Haz clic en http://www.terra.es/correo/ - 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
RE: ASP MySQL
I usually use MySQL with MyODBC, then it is just like any other database, but faster :) Stefan -Original Message- From: L_U_I_Z [mailto:[EMAIL PROTECTED]] Sent: den 10 september 2001 22:08 To: [EMAIL PROTECTED] Subject: ASP MySQL I'm developing an application and I have to choose a good database server. I'm considering MS SQL Server and MySQL. I haven't heard very much about MySQL, but from I've read on the web I think MySQL is Unix/Linux orientated and works well with PHP. I'm going to use a NT platform, with the IIS as web server, and I wanted to use ASP. Does MySQL fit good with IIS and ASP? Thaks. ___ Consigue tu e-mail gratuito TERRA.ES Haz clic en http://www.terra.es/correo/ - 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
RE: ASP MySQL
I use ASP and mySQL. I love it! Dave Carter Chief Web Architect Accelerated Business Technologies, Inc. http://www.abti.net 717.464.2970 -Original Message- From: L_U_I_Z [mailto:[EMAIL PROTECTED]] Sent: Monday, September 10, 2001 4:08 PM To: [EMAIL PROTECTED] Subject: ASP MySQL I'm developing an application and I have to choose a good database server. I'm considering MS SQL Server and MySQL. I haven't heard very much about MySQL, but from I've read on the web I think MySQL is Unix/Linux orientated and works well with PHP. I'm going to use a NT platform, with the IIS as web server, and I wanted to use ASP. Does MySQL fit good with IIS and ASP? Thaks. ___ Consigue tu e-mail gratuito TERRA.ES Haz clic en http://www.terra.es/correo/ - 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
RE: ASP MySQL
-Original Message- From: L_U_I_Z [mailto:[EMAIL PROTECTED]] Sent: Monday, September 10, 2001 9:08 PM To: [EMAIL PROTECTED] I'm developing an application and I have to choose a good database server. I guess that's not the only choice... I'm considering MS SQL Server and MySQL. I haven't heard very much about MySQL, but from I've read on the web I think MySQL is Unix/Linux orientated and works well with PHP. True, but MySQL has an exellent ODBC module as well. It's called MyODBC. I'm going to use a NT platform, with the IIS as web server, and I wanted to use ASP. Does MySQL fit good with IIS and ASP? Now, with this env, you want to check out how big your application might become and shed light on aspects like scalability, ease of backup and restore, etc. Especially Microsoft made some very good progress in this area with MS SQL 2000... OTOH, MySQL is very simple to backup / restore. MySQL is also quite scalable when it comes to seperation of readers and writers (replication). Now, back to your question. As far as my experience is concerned, the Microsoft products work very well if left in a Microsoft-Products-Only-Environment. The big problem that remains is that you need to understand how to install the products in order to guarantee long life time. I don't know about performance of IIS/MySQL vs IIS/SQLServer2000, but I guess MS has the top hand here as well. OTOH, if your choice was somewhat free, I'ld rather use Apache/PHP/MySQL combination: 1st: Cheap Solution (OS + Web Server + DB all for free...) 2nd: Proven Record of Quality (PHP is the most widely used language in Server Side Scripting...; Apache has a proven record of being the most used web server...) 3rd: Yahoo uses MySQL for certain (if not all) areas, and they seem quite happy. 4th: (From my own experience) MySQL virtually never crashes... last but not least: Monty and Team, and this list are very actively participating in helping people out with their problems. Just my 0.02$, Guus - 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
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
RE: problem regarding ASP+MySQL in NT with IIS (web server)
Hi Ashutosh, You can try a tool like MySQLX which was specifically developed for MySQL and ASP, see: http://www.scibit.com/MySQLX or any of the other ASP API interfaces in the mysql Contrib section. Regards Jacques http://www.scibit.com/mysql -Original Message- From: ASHUTOSH SHARMA [mailto:[EMAIL PROTECTED]] Sent: 18 May 2001 13:51 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
RE: problem regarding ASP+MySQL in NT with IIS (web server)
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
ASP == MySQL
Hello, I wondered if MySQL is capable of being accesed by an ASP script? tnx!
