Re: New to the list so I'll apologize for the stupid question BUT - Christopher R. Jones - com.mysql.lists.win32

4 messages in com.mysql.lists.win32Re: New to the list so I'll apologize...

From	Sent On	Attachments
Robert Adams	02 Mar 2001 13:56
Cynic	02 Mar 2001 14:08
Guillaume	02 Mar 2001 14:28
Christopher R. Jones	02 Mar 2001 15:50

Subject:	Re: New to the list so I'll apologize for the stupid question BUT
From:	Christopher R. Jones (cj...@cr-jay.ca)
Date:	03/02/2001 03:50:07 PM
List:	com.mysql.lists.win32

You can implement a DSNless connection but MyODBC has to be installed on the WEB
server (not the database server if they are different) and you need access
privileges to the ODBC driver. The following is an example of a DSNless
connection on my NT WEB server connecting to the MySQL server on Solaris: <% ConnectionString1a =
"Driver=MySQL;Server=solaris1;UID=cjones;PWD=mypass;OPTION=16386;" conn1 = Server.CreateObject('ADODB.Connection'); conn1.Open( ConnectionString1a ); conn1.Execute( "USE Buildings" ); sql = "SELECT DISTINCT bldgtype, tpl, d2c001 FROM projects ORDER BY bldgtype"; rs1 = Server.CreateObject("ADODB.Recordset"); rs1.Open( sql, conn1); rs1.MoveFirst(); var i = 0; while( !rs1.EOF ) { bldg = rs1('bldgtype'); tpl = rs1('tpl'); d2c = rs1('d2c001'); Response.Write( "<h1>" + bldg + " " + tpl + " " + d2c +
"</h1>" ); rs1.MoveNext(); i++; }%>

Hi, try searching archives. I don't remember the exact syntax, but it was asked and answered several times.

At 22:56 2.3. 2001, Robert Adams wrote the following:

--------------------------------------------------------------

does anyone know how to setup an ADO connection W/OUT a dsn for mysql?

Trying to setup a connection from my Internet server to a db server, don't have odbc rights on the internet server :(

------end of quote------

____________________________________________________________ Cynic:

A member of a group of ancient Greek philosophers who taught that virtue constitutes happiness and that self control is the essential part of virtue.

To unsubscribe, send a message to the address shown in the List-Unsubscribe header of this message. If you cannot see it, e-mail win3...@lists.mysql.com instead.