Re: Converting meteor phone number to name using DB

["Paul Robinson" <ukcueman@xxxxxxxxxxx>]

That was the code from John B. Mine had different SERVER, UID, PWD and
DATABASE values.
The actual line I'm using is:

Con.Open "DRIVER=mySQL ODBC 3.51
Driver;UID=paul;PWD=xxxx;SERVER=spot;DATABASE=fieldside;OPTION=2;"'

I am assuming that UID, PWD and SERVER are good because entering the wrong
password
produces an error of "([MySQL][ODBC 3.51 Driver]Access denied for
user:
'paul@xxxxxxx' (Using password: YES))"

whereas with the correct password I just get "(Catastrophic
failure)"

I'm running mysql 4.0.22 on a linux box and can access the DB from the
machine running
XPLHal using other tools.

I found some docs on the net suggesting that setting OPTION=4 (or 6,
combining the 2 & 4)
would produce a mysql error log in C:\ - but it didn't.

Any ideas?

----- Original Message -----
From: "Ian J" <ha@xxxxxxx>
To: <ukha_xpl@xxxxxxx>
Sent: Saturday, February 12, 2005 8:32 AM
Subject: Re: [ukha_xpl] Converting meteor phone number to name using DB


>
> Is the computer running your database called Jupiter? (I suspect this
one is
> probably the cause.)
> Is it running MySQL?
> Is your database called telephones?
>
> ----- Original Message -----
> From: "Paul Robinson" <ukcueman@xxxxxxx>
> To: <ukha_xpl@xxxxxxx>
> Sent: Saturday, February 12, 2005 2:24 AM
> Subject: [ukha_xpl] Converting meteor phone number to name using DB
>
>
> >
> > I'm struggling to use John B's sample code as below (but with
> > host/user/database changed
> > appropriately) for doing a DB lookup.
> >
> >> Function MakePhoneNumber(s)
> >>   dim Con, RS
> >>   dim Counter
> >>   dim PhoneNumber
> >>
> >>   Set Con = CreateObject("ADODB.Connection")
> >>   Set RS = CreateObject("ADODB.RecordSet")
> >>   Con.Open "DRIVER=MySQL ODBC 3.51
> >
Driver;UID=homecontrol;PWD=********;SERVER=jupiter;DATABASE=telephones;OPTION=2"
> >>
>
>
>
> xPL Links: http://www.xplproject.org.uk http://www.xplhal.com http://www.xpl.myby.co.uk
> To Post a Message: ukha_xpl@xxxxxxx
> To Subscribe:  ukha_xpl-subscribe@xxxxxxx
> To Unsubscribe:  ukha_xpl-unsubscribe@xxxxxxx
> Yahoo! Groups Links
>
>
>
>
>
>
>
>





xPL Links: http://www.xplproject.org.uk http://www.xplhal.com http://www.xpl.myby.co.uk
To Post a Message: ukha_xpl@xxxxxxx
To Subscribe:  ukha_xpl-subscribe@xxxxxxx
To Unsubscribe:  ukha_xpl-unsubscribe@xxxxxxx