The UK Home Automation Archive

Archive Home
Group Home
Search Archive


Advanced Search

The UKHA-ARCHIVE IS CEASING OPERATIONS 31 DEC 2024


[Message Prev][Message Next][Thread Prev][Thread Next][Message Index][Thread Index]

Re: 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

xPL Main Index | xPL Thread Index | xPL Home | Archives Home

Comments to the Webmaster are always welcomed, please use this contact form . Note that as this site is a mailing list archive, the Webmaster has no control over the contents of the messages. Comments about message content should be directed to the relevant mailing list.