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 with MySQL ASP
Hi Craig,
You can give the following a try which does give you direct access to MySQL
from ASP skipping the slower ODBC and is almost code compatible with your
code:
http://www.scibit.com/MySQLX
or
MyVBQL on the mysql API/contrib pages
Regards
Jacques
http://www.scibit.com
http://www.scibit.com/MySQL
http://www.scibit.com/Mascon
-Original Message-
From: Craig Atkins [mailto:[EMAIL PROTECTED]]
Sent: 19 March 2001 15:39
To: '[EMAIL PROTECTED]'
Subject: Problem with MySQL ASP
Hi I am running the latest versions of MySQL and MyODBC on my windows
200 webserver.
I am trying to connect to my database and pull out some simple data with
asp.
The code i am using is:
%
dim db
dim strConn
dim rs
dim QueryStr
QueryStr = "SELECT * FROM imagedata"
strConn = "mediaSafe"
!--Open the database--
Set db = Server.CreateObject("ADODB.Connection")
db.open strConn, "web", "media1"
Set rs = Server.CreateObject("ADODB.Recordset")
set rs=db.execute(QueryStr)
if rs.eof then
response.write "RS EOF!"
else
response.write "NOT RS EOF!"
end if
%
which works on my Access database, but it returns an empty recordset on
MySQL.
I have tried many different things, but cannot get the data out, yet if
I use an ODBC query tool, i can!
I really want to get this working!
Thanks in advance,
Craig
*
This e-mail and its contents are confidential and are for the
use of the intended recipient only. If you are not the
intended recipient, please notify the sender immediately.
The opinions, statements and thoughts expressed in this
email are only those of the individual sender.
*
-
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: Can't connect in Windows 2000
Hi James, Yes this IS mysql related as MySQL does not support a Telnet connection to it :) You can either use the mysql.exe utility in the mysql\bin directory to use your mysql server or try one of the many MySQL GUI clients available in the Contrib section of www.mysql.com ,for ex. http://www.scibit.com/Mascon which will get you started fast. Regards -Original Message- From: James T Fielding [mailto:[EMAIL PROTECTED]] Sent: 15 February 2001 13:56 To: [EMAIL PROTECTED] Subject: Can't connect in Windows 2000 Importance: High I have installed Mysql on my Windows 2000 machine and everything seems to be working fine. However, when I try to telnet using the ip address on port 23 it won't connect. Sometimes it says something like 'NTLM authentication required'. I have IIS 5 installed. Does anyone know what I can do to connect? Many thanks James - 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 and MySQL
Hi Matt, Think you will find: http://www.scibit.com/MySQL useful -Original Message- From: Matt Davis [mailto:[EMAIL PROTECTED]] Sent: 13 February 2001 14:47 To: [EMAIL PROTECTED] Subject: ASP and MySQL I have MySQL running on a cobalt Raq 3 with linux operating system. I have set up MyODBC and I can connect through MS Access I can also connect through MS Frontpage and created a simple web interface to retrieve some results from my db however when uploaded I recieve no results when I definatly should get some. Should I not be using asp and if not what should I use, are there any applications for visual creation of these file types? Thanks Matt Davis. - 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: Excel-MySQL
Try Mascon's CopyPaste or Import Export: http://www.scibit.com/Mascon -Original Message- From: Ashley M. Kirchner [mailto:[EMAIL PROTECTED]] Sent: 31 January 2001 20:19 To: MySQL Mailing List Subject: Excel-MySQL Not sure if this was ever asked, but I'm fighting a dilemma over here and the answer to this greatly affects what I'll end up doing: I know I can PULL FROM an MySQL database (sitting on a Limix box) INTO MS Excel. And that works great. However, I'm looking for a way to go the other way around, FROM Excel TO MySQL. Upper Management has a lot of data (mainly price sheets) written in Excel right now. Files that are actively modified. And I'm looking for a solution to have them just be able to publish the new changes straight into the MySQL DB (and I don't want to have them export the excel sheets into delimited text files for me to re-import into the DB, but I'm looking more for an automated way, just like pulling data from the DB into Excel) AMK4 -- W | | I haven't lost my mind; it's backed up on tape somewhere. | ~ Ashley M. Kirchner mailto:[EMAIL PROTECTED] . 303.442.6410 x130 SysAdmin / Websmith . 800.441.3873 x130 Photo Craft Laboratories, Inc. .eFax 248.671.0909 http://www.pcraft.com . 3550 Arapahoe Ave #6 .. . . . . Boulder, CO 80303, USA - 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: MORE basics!!
Hi Mac, Please read up on the security setup Section 6 (c:\mysql\docs) before continuing. First understand before try. Regards Jacques -Original Message- From: Mac Martine [mailto:[EMAIL PROTECTED]] Sent: 24 January 2001 08:17 To: Jacques Venter Cc: [EMAIL PROTECTED] Subject: Re: MORE basics!! I'm getting closer Thanks again!!! I have my root account set up on my local machine. I guess I need to figure out how to set up an account for my remote server. Does that sound right? Sorry, I'm still trying to grasp how this all works. Thanks to your help, I have figured out how to see my databases and tables through the mysql.exe prompt box. I havent done anything in DOS...i dont think i need to at this point, but i could be wrong. So, I'm not sure how to set permissions on a remote file...I cant find a way to change my 'localhost' to 'mydomain.com'. Isnt that what I want to do somehow? Thanks! Mac - Original Message - From: Jacques Venter [EMAIL PROTECTED] To: Mac Martine [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, January 24, 2001 1:18 AM Subject: RE: basics!! Hi Mac, You should not be typing DOS commands within the mysql.exe utility, do the following exactly: Get yourself here: C:\ Type: cd mysql\bin ENTER Result: c:\mysql\bin Type: mysqld-nt --install ENTER Result: c:\mysql\bin Type: net start mysqlENTER Result: MySQL Service has started successfully Type: mysqlENTER Result: You are now within the mysql command line utility and are supposed to type sql, not DOS commands. Type: use mysql; select * from user;ENTER Result: See a list of your user security table Type: quitENTER Result: Back to DOS: c:\mysql\bin i also tried typing: mysqladmin -uroot -password **; Now that your mysql is running you can try this again. If you post to the mailing list again, please provide your operating system. No offense intended, but you should get yourself a GUI MySQL Client Regards - 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: basics!!
Hi Mac, This is actually quite easy (although you've not supplied your Operating System (OS)) win95,win98,winnt,win2000 is presumed: 1. Install MySQL 2. Go to the mysql\bin directory command line (DOS Box) 3. If you want to install on NT or 2000 do A) else do B) A) mysqld-nt --install ENTER net start mysql ENTER B) mysqld-nt --standalone ENTER 4. A) Will install mysql as a service (Control Panel-Services) and B) will have mysql run once will you are logged in. 5. Now mysql does have a command line interface called mysql.exe with which to run sql queries But if you don't like command lines you can pick any number of mysql windows client and admin programs, see Contributed on the mysql website. You can for example try Mascon: http://www.scibit.com/Mascon Regards -Original Message- From: Mac Martine [mailto:[EMAIL PROTECTED]] Sent: 24 January 2001 04:14 To: [EMAIL PROTECTED] Subject: basics!! allright, so i am a beginner with some very basic questions... I installed and set up mysql, but everything i read, talks about using ms-dos or something to use it. It looks the interface i have for mysql has all those options, or no??? Is whatever I will want to do not possible within that interface? I am confused on how to allow permissions to a file on my remote server. Is 'localhost' only for my local machine? How do I set permissions on a file on a remote server, or am i missing something? I have read everything i can find, and nothing seems to make this clear. These are very basic , I know, but whomever could take the time to explain how to get this all started, I would GREATLY appreciate it!!! I have scripts waiting to be played with! Thanks so much! Mac - 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: basics!!
Hi Mac, You should not be typing DOS commands within the mysql.exe utility, do the following exactly: Get yourself here: C:\ Type: cd mysql\bin ENTER Result: c:\mysql\bin Type: mysqld-nt --install ENTER Result: c:\mysql\bin Type: net start mysqlENTER Result: MySQL Service has started successfully Type: mysqlENTER Result: You are now within the mysql command line utility and are supposed to type sql, not DOS commands. Type: use mysql; select * from user;ENTER Result: See a list of your user security table Type: quitENTER Result: Back to DOS: c:\mysql\bin i also tried typing: mysqladmin -uroot -password **; Now that your mysql is running you can try this again. If you post to the mailing list again, please provide your operating system. No offense intended, but you should get yourself a GUI MySQL Client Regards - 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: Win NT/2000 mySQL question
Hi Marc, All your questions could be answered at: http://www.scibit.com/MySQLX try the Sample Website Hello, Hope this list is right for a newbie question. I would like using mySQL as an ODBC-database on a Win NT Server with MIS, ... That means, I am having a Website developed with ASP/SQL-Server, and I just would like changing the databaseserver (SQL-server out, mySQL in ) The ASP-clientside SQL-queries are just standard SQL - nothing SQL-server specific. Also there are a few Visual Basic-SQLclients accessing the database. All is working similar as an editorial system. Cause I didn't work with mySQL till now, I'm having a few questions: 1. Could it work ? Is it possible running mySQL as an ODBC-database ? Are there any tutorials out ? 2. If yes - could there be any incompatible probs with the ASP-SQLqueries ? 3. Any problems with ASP as a Scripting language ? Any probs with MIS (Information Server) ? 4. Is it possible processing queries multithreaded ? 5. Any experiences with Access as a mySQL-client via ODBC for databaseadministration ? thanks, Marc Hafner - 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: Win NT/2000 mySQL question
Hi Marc, Thanks Jacques Christopher, you are telling on your site (compliment, really nice work), that your MySQLX-component is quicker then ODBC. Any benchmarking about it ? Yes, although not prominent, we've had this on your site for a while: http://www.scibit.com/Products/Software/VCL/benchmark.gif This was done almost a year ago using a (winnt) MySQL table with 40 fields and 10 000 records, giving a comparison on the most used functions on a table, scrolling, posting, deleting, inserting, etc. You would be interested in the first (Blue) and last (Aqua) bars. * The Blue bar is our MySQLDataset Delphi component (http://www.scibit.com/MYSQLCOMPONENTS) using ONLY the (MySQL AB provided) libmysql.dll (straight to the server). * The Brown bar is our MySQLDataset component accessing the MySQL server in cached-updates mode. * The Yellow bar is accessing the same table created in MSAccess. * The Aqua bar is accessing the MySQL server using the standard MyODBC driver. The MySQLDataset component is used as the foundation for MySQLX (http://www.scibit.com/MySQLX) as well as Mascon (http://www.scibit.com/Mascon) Also - does your component support ADO-objects ? - specially Recordsets .. or do you have something similar ? Yes, the most important ADO calls are all available as seen in the OnLine Help File, ex. Connection, Recordset, Fields, etc. As you can see in the Help many more properties and methods are also available giving you full control and access to your MySQL server(s). It is multithreaded and able to access different databases on the server simultaneously. How can you access mySQL with Mascon ? Only via this ActiveX or also with ODBC ? Mascon is a standalone MySQL tool, to access any MySQL server (v3.21.x to v3.23.x). You ONLY need Mascon.exe and the accompanying libmysql.dll (MySQL AB developed). Mascon has no built-in support for either Active X or ODBC. Back to Win NT: On the WinNT-Server I only will run mySQL accessing via an ODBC networkconnection. Are there any disadvantages running mySQL on NT, not Linux - Linuxfans keep cool !;) .. I mean just for this kind of application We've not found any major advantages or disadvantages (we run both) that is NOT dependent on your scenario, Linux is by default more stable (nothing to do with MySQL) than NT and given the same hardware it is also faster (because of general less overhead), it is also much cheaper to maintain/upgrade (given a default installation and ignoring training and learning curves). Win2K has many more default features in the IIS and is easier/faster to manage/setup/config on a global (multiple server) scale. This is of course expected from an all in one package, while you will get many more features and functionality from your Linux box if tweaked, patched and installed with everything available (to manage this afterwards could be a challenge). Again everybody keep cool, this is just one guy's (my) opinion and is only valid for me at this point in time. Or - what is recommended ? Running IIS and mySQL on one Server ? Depends on the load the hardware is going to handle (number of hits, LAN/Internet speeds, etc). Difficult to answer; You can always start of with this config, then move the MySQL (which is probably going to do more work) to a Linux box later. Regards Jacques - 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: A report generator MySQL
Hi Laurie, You can also try: http://www.scibit.com/Mascon Full Reporting support, with images, graphs, pivottables, etc, etc. -Original Message- From: Laurie Savage [mailto:[EMAIL PROTECTED]] Sent: 20 January 2001 04:03 To: [EMAIL PROTECTED] Subject: A report generator MySQL I am writing a database to store student academic records at my local high school. I wish to generate attractively published reports home to parents. Does anybody know of a method or product that will produce elegantly formatted reports from MySQL? - 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
