db connection

Hershel Fisch hershrev at realtorsgroup.us
Tue Aug 31 13:31:37 CDT 2004


On Tuesday, August 31, 2004, at 05:37 AM, Pierre Sahores wrote:

>
> Le 31 août 04, à 00:25, Hershel Fisch a écrit :
>
>>
>> On Monday, August 30, 2004, at 05:02 PM, Pierre Sahores wrote:
>>
>>> Hello Hershel,
>>>
>>> Did you try this :
>>>
>>>> put  
>>>> revOpenDatabase("PostgreSQL","localhost","projetsdac","postgres","po 
>>>> stgres") into PGLinkOpen
>>>
>>> with the second "postgres" item as the default postgres user  
>>> password (to be replaced by the right one if you changed it) ?
>> Ok ,
>> 1) I don't have a password on my Db.
>
> If Postgres is rightly installed, the default system postgres (with  
> default "postgres" password") has been created during the installation  
> process : so it exists. Else the installation process didn't complete.
Got that , doesn't help. And also with RR 2.2.1 works without problems.
>
>> 2) If this is the case then why is the err , invalid database type.
>
> To see if postgres is running normally lauch the activity monitor app  
> and search the postgres thread. To see if the "postgres" user is  
> rightly set, test "su - postgres" at the shell prompt and, then if you  
> are prompted for the password, type "postgres". If something goes  
> wrong, postgres need to be reinstalled (prefer the Marc Liyanage's  
> installer -- <http://www.entropy.ch/software/macosx/postgresql/>).
Sorry , don't know what and where the activity monitor is.
The su - postgres is ok.
And I did use entropy's installation.
>
>
>> 4) "put  revOpenDatabase("MySQL","127.0.0.1","test",postgres,)" when  
>> I don't have mySql running, into the message box crashes or Freezes  
>> RR.
>
> Don't tell RR to connect MySQL if you want to access a PostgreSQL  
> server...
>
>> Thanks in advanced. Hershel
>
> Hope this can help,
>
> Best, Pierre
>
>
> Bien cordialement, Pierre Sahores
>
> 100, rue de Paris
> F - 77140 Nemours
>
> psahores+ at +easynet.fr
>
> GSM:   +33 6 03 95 77 70
> Pro:      +33 1 64 45 05 33
> Fax:      +33 1 64 45 05 33
>
> WEB/EAI services & ACID DB over IP
> "Mutualiser les deltas de productivité"
>
> _______________________________________________
> use-revolution mailing list
> use-revolution at lists.runrev.com
> http://lists.runrev.com/mailman/listinfo/use-revolution
>



More information about the use-livecode mailing list