Re: Converting meteor phone number to name using DB

["Ian J" <ha@xxxxxxxxxxxxxxxxx>]

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