Ummm...you can't do that. The MyODBC driver is used by the script to connect via ODBC. It has to be in a place where ASP can find and use it. It does no good if it is on another machine. The driver does not need to reside on the server machine: it is a client-side piece of software.
j----- k----- On Thursday 29 April 2004 11:06 am, michael johnson said something like: > The connection I am trying to make is from a website where the hosting > machine will not have Myodbc installed and the database I am trying to > connect to is on another Internet visible server where MySQL is installed > and myodbc is installed. > > -----Original Message----- > From: Victor Pendleton [mailto:[EMAIL PROTECTED] > Sent: 29 April 2004 19:54 > To: 'Joy Johnson '; Victor Pendleton; ''michael johnson ' '; > ''[EMAIL PROTECTED] mysql. com ' ' > Subject: RE: Connect string for ASP > > > You will need to have MyODBC installed. You do not need to create a DSN. > > -----Original Message----- > From: Joy Johnson > To: 'Victor Pendleton'; 'michael johnson '; '[EMAIL PROTECTED] mysql. com ' > Sent: 4/29/04 1:50 PM > Subject: RE: Connect string for ASP > > I presume I do not need myodbc installed anywhere to do this. > > Thanks for the prompt response > > BPEnet Sales & Support Team > > BPEnet EMEA > Sun iForce Premier Solution, Sales, Change Management & Development > Partner > Part of the BPE Group Limited > 13 Austin Friars > London > EC2N 2JX > Tel: 0870 922 0247 / 0207 670 1690 > Fax: 0207 670 1717 > E-mail: [EMAIL PROTECTED] > Web: www.bpenet.net > BPEnet Offices in: Sussex, London & Dublin > > > -----Original Message----- > From: Victor Pendleton [mailto:[EMAIL PROTECTED] > Sent: 29 April 2004 19:46 > To: 'michael johnson '; '[EMAIL PROTECTED] mysql. com ' > Cc: 'Joy Johnson ' > Subject: RE: Connect string for ASP > > > ConnectStr = "Driver={MySQL ODBC 3.51 Driver};server=;DB=;UID=;PWD=" > > > -----Original Message----- > From: michael johnson > To: [EMAIL PROTECTED] mysql. com > Cc: Joy Johnson > Sent: 4/29/04 1:33 PM > Subject: Connect string for ASP > > Dear All > > I am using ASP. Can anyone give me the connection code to connect to a > MySQL database without using ODBC DSN? > > Thanks > > Michael Johnson > Director > > BPEnet EMEA > Sun iForce Premier Solution, Sales, Change Management & Development > Partner Part of the BPEnet Group Limited 13 Austin Friars London EC2N > 2JX Tel:. +44 (0)870 922 0247 / (0)207 670 1690 > Fax: +44 (0)207 670 1717 > E-mail: [EMAIL PROTECTED] > Web: www.bpenet.net > BPEnet Offices in ~ Sussex, London & Dublin -- Joshua J. Kugler -- Fairbanks, Alaska -- ICQ#:13706295 Every knee shall bow, and every tongue confess, in heaven, on earth, and under the earth, that Jesus Christ is LORD -- Count on it! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]