R: Another newbie!
Nino
You've given me a lot of valuable information!
Bye,
Nino
=================================
on...@vessella.it (onin=>nino)
on...@vessella.net
http://www.vessella.it (italiano, esperanto, kiswahili, english)
http://www.vessella.net
-----Messaggio Originale-----
Da: "Edward Apostol (@Home)" <e...@edapostol.com>
A: "'Nino'" <ni...@vessella.it>; <wi...@lists.mysql.com>
Data invio: domenica 8 aprile 2001 17.16
Oggetto: RE: Another newbie!
> Hi -
>
> In terms of connecting to a mySQL database using ASP, you could use a DSN
> connection through the control panel. In other words, you need the mySQL
> driver and configure the driver to point to your database with the
> approrpriate security permissions.
>
> I downloaded the driver at
> http://www.iserver.com/support/virtual/mysql/odbc/
>
> follow the instructions for installation and configuration
> You can connect to the mySQL server from another machine by filling in the
> appropriate machine details for the particular mySQL DSN setup you create
in
> the control panel. You should be able to setup by IP address or machine
DNS.
> Internet service providers such as PSInet.com in North America have this
> setup, with ASP as the server side language running on Windows Servers or
> *nix(via the Chili!Soft ASP Interpreter).
>
> You can then connect to the mySQL database usi
> ng ASP, just as you do now
> with Access.
>
> I also sometimes use utilities to bring mySQL data into access, edit it
with
> the access interface, then export it as mySQL type databases again. In the
> downloads area in www.mysql.com take a look at the following -
>
> exportsql.txt A script that is similar to access_to_mysql.txt, except that
> this one is fully configurable, has better type conversion (including
> detection of TIMESTAMP fields), provides warnings and suggestions while
> converting, quotes all special characters in text and binary data, and so
> on. It will also convert to mSQL v1 and v2, and is free of charge for
> anyone. See http://www.cynergi.net/prod/exportsql/ for the latest version.
> By Pedro Freire, sup...@cynergi.net. NOTE: Doesn't work with Access2!
>
> access_to_mysql.txt Paste this function into an Access module of a
database
> that has the tables you want to export. See also exportsql. By Brian
> Andrews. NOTE: Doesn't work with Access2!
>
> importsql.txt A script that does the exact reverse o
> f exportsql.txt. That
> is, it imports data from MySQL into an Access database via ODBC. This is
> very handy when combined with exportsql, because it lets you use Access
for
> all DB design and administration, and synchronize with your actual MySQL
> server either way. Free of charge
>
>
> hope that helps.
>
>
> Edward Apostol (@home)
> Instructor, Developer - E-Commerce
> Toronto, ON Canada
> --------------------------------------------------
> "I need a new quote for my e-signature."
> - Anonymous
>
>
> -----Original Message-----
> From: Nino [mailto:ni...@vessella.it]
> Sent: April 8, 2001 4:45 AM
> To: wi...@lists.mysql.com
> Subject: Another newbie!
>
>
> Hi,
> I've been using ASP and MS Access, now I have to move to MySQL + ASP.
> I've succeeded to install MySQL on my Win98, but what I don't understand
is:
> How do I connect to the database in ASP? Obviously, my site is housted
> somewhere else: How do I connect there? Do they have do set something
(DNS,
> or things like that - yes, I'm a beginner!)?
> In other words, how do
> I convert code like the following?
>
> <%
> connectString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" &
> server.MapPath("\fpdb\risposte.mdb")
>
> Set adoConnection = Server.CreateObject("ADODB.Connection")
> Set adoRecordset = Server.CreateObject("ADODB.Recordset")
>
> adoConnection.Open connectString
> ..
> %>
>
> Thanks a lot,
> Nino
>
> PS Can you suggest a book on SQL in ASP?
>
>
> =================================
> on...@vessella.it (onin=>nino)
> on...@vessella.net
>
> http://www.vessella.it (italiano, esperanto, kiswahili, english)
> http://www.vessella.net
>
>
>
> ---------------------------------------------------------------------
> Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
> posting. To request this thread, e-mail win32-th...@lists.mysql.com
>
> To unsubscribe, send a message to the address shown in the
> List-Unsubscribe header of this message. If you cannot see it,
> e-mail win32-un...@lists.mysql.com instead.
>
>
>
> ---------------------------------------------------
> ------------------
> Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
> posting. To request this thread, e-mail win32-th...@lists.mysql.com
>
> To unsubscribe, send a message to the address shown in the
> List-Unsubscribe header of this message. If you cannot see it,
> e-mail win32-un...@lists.mysql.com instead.
>
---------------------------------------------------------------------
Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
posting. To request this thread, e-mail win32-th...@lists.mysql.com
To unsubscribe, send a message to the address shown in the
List-Unsubscribe header of this message. If you cannot see it,
e-mail win32-un...@lists.mysql.com instead.