From mboxrd@z Thu Jan  1 00:00:00 1970
X-Spam-Checker-Version: SpamAssassin 3.4.4 (2020-01-24) on polar.synack.me
X-Spam-Level: 
X-Spam-Status: No, score=-0.3 required=5.0 tests=BAYES_00,
	REPLYTO_WITHOUT_TO_CC autolearn=no autolearn_force=no version=3.4.4
X-Google-Thread: 103376,fc3719e6afe93cd7
X-Google-NewGroupId: yes
X-Google-Attributes: gida07f3367d7,domainid0,public,usenet
X-Google-Language: ENGLISH,ASCII-7-bit
Path: 
 g2news1.google.com!news3.google.com!feeder.news-service.com!news.netcologne.de!newsfeed-fusi2.netcologne.de!newsfeed.straub-nv.de!open-news-network.org!uucp.gnuu.de!newsfeed.arcor.de!newsspool3.arcor-online.net!news.arcor.de.POSTED!not-for-mail
From: "Dmitry A. Kazakov" <mailbox@dmitry-kazakov.de>
Subject: Re: mysql , gnade and function hanging
Newsgroups: comp.lang.ada
User-Agent: 40tude_Dialog/2.0.15.1
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Reply-To: mailbox@dmitry-kazakov.de
Organization: cbb software GmbH
References: 
 <1be70d43-a5f2-40cc-8859-f4e5d34bcd52@w12g2000yqj.googlegroups.com>
  <9e8008e5-129f-4b9b-b083-44b386a7ce4b@i28g2000yqa.googlegroups.com>
  <87bpasiue9.fsf@ludovic-brenta.org>
 <da31977b-8319-420c-a1e5-981dd52b2788@c33g2000yqm.googlegroups.com>
  <964f5797-eac0-4a2c-9930-fc6137efc8df@w12g2000yqj.googlegroups.com>
  <i0i5np$o0c$1@news.eternal-september.org>
 <4219d836-dddc-496d-8dda-6eecc1cb76bb@d8g2000yqf.googlegroups.com>
 <zOmdnev0COPcfLPRnZ2dnUVZ_hMAAAAA@earthlink.com>
Date: Sat, 3 Jul 2010 12:07:33 +0200
Message-ID: <1mc8qis3jkqsj$.ir3tojaff43m.dlg@40tude.net>
NNTP-Posting-Date: 03 Jul 2010 12:07:34 CEST
NNTP-Posting-Host: ce047337.newsspool3.arcor-online.net
X-Trace: 
 DXC=9=S0S[T^:IZcHPTNZh_e7QMcF=Q^Z^V3X4Fo<]lROoRQ8kF<OcfhCO[>1@A\TYiM3[[6LHn;2LCV^[<mhadbfdU[8KlC^Q]VOEP^JfTn`cjH:]
X-Complaints-To: usenet-abuse@arcor.de
Xref: g2news1.google.com comp.lang.ada:12162
Date: 2010-07-03T12:07:34+02:00
List-Id: <comp.lang.ada>

On Sat, 03 Jul 2010 00:05:40 -0700, Dennis Lee Bieber wrote:

> On Fri, 2 Jul 2010 01:45:09 -0700 (PDT), tonyg
> <tonythegair@googlemail.com> declaimed the following in comp.lang.ada:
> 
>> 
>> Thanks for your help Guys, now I know :), the mysql machine I am using
>> is remote, I assume I will have to install a mysql odbc connector on
>> it, is there any extra setup I will have to do for the local machine I
>> writing the code for ?
> 
> 	Hypothesizing, as I don't have experience with ODBC other than via
> Python... I /think/ the ODBC connector would go one the local machine --
> the connector "knows" how to talk to a MySQL engine, and that should
> include handling a connection string that specifies a remote engine. It
> is just the local application that needs access to the local ODBC layer
> for translation...

Yes. The thing is called "data source." Data sources are configured for a
specific ODBC driver, in this case MySQL ODBC driver. Under Windows it is
managed under Control Panel -> Administrative Tasks -> Data Sources. Under
Linux it is usually unixODBC configuration.

When you configure the data source, then depending on the driver you
specify the server's host, IP port, user name, password etc.

-- 
Regards,
Dmitry A. Kazakov
http://www.dmitry-kazakov.de