Real Software Forums

The forum for Real Studio and other Real Software products.
[ REAL Software Website | Board Index ]
It is currently Thu Aug 16, 2018 11:20 am
xojo

All times are UTC - 5 hours




Post new topic Reply to topic  [ 10 posts ] 
Author Message
 Post subject: Cannot Open PostgreSql in RS V 2.1
PostPosted: Tue Feb 19, 2013 7:59 pm 
Offline

Joined: Sat Dec 04, 2010 9:14 pm
Posts: 918
Hello All,

I had to do some work today in web edition application. It has always been fine, except for today, I cannot get PostgreSQL to open using V2.1. I launched V1.2 and with the same project, same code, same DB, it opened perfectly.

What is going on?

Tim


Top
 Profile  
Reply with quote  
 Post subject: Re: Cannot Open PostgreSql in RS V 2.1
PostPosted: Wed Feb 20, 2013 4:50 pm 
Offline

Joined: Sat Dec 04, 2010 9:14 pm
Posts: 918
Ideas anyone? Is the Postgre Plugin NG?

Tim


Top
 Profile  
Reply with quote  
 Post subject: Re: Cannot Open PostgreSql in RS V 2.1
PostPosted: Wed Feb 20, 2013 8:58 pm 
Offline

Joined: Wed Mar 22, 2006 11:15 am
Posts: 712
Location: Southern California
Tim - I just checked and I'm not having any problem connecting to Postgres using RS2012r2.1 for Mac. I should note that the Postgres database is running on the same machine ("localhost").

Are you using SSL? Does the database return an error when you try to connect?

_________________
Daniel L. Taylor
Custom Controls for Real Studio WE!
Visit: http://www.webcustomcontrols.com/


Top
 Profile  
Reply with quote  
 Post subject: Re: Cannot Open PostgreSql in RS V 2.1
PostPosted: Wed Feb 20, 2013 9:41 pm 
Offline

Joined: Sun Jan 28, 2007 2:38 pm
Posts: 231
tseyfarth wrote:
Ideas anyone? Is the Postgre Plugin NG?


Realsoftware has decided on Postgre for internal use so that particular plugin gets move love than the others.....


(For what its worth)


Top
 Profile  
Reply with quote  
 Post subject: Re: Cannot Open PostgreSql in RS V 2.1
PostPosted: Wed Feb 20, 2013 9:53 pm 
Offline

Joined: Sat Dec 04, 2010 9:14 pm
Posts: 918
Hi All,

I am running locally, (localhost). I copied the plugin from 2012R1.2 to 2.1 and the problem is gone. But I still and a little skittish.

No SSL, and no DB error. Code has not changed at all. I just swapped the plugin and it was fixed...
Tim


Top
 Profile  
Reply with quote  
 Post subject: Re: Cannot Open PostgreSql in RS V 2.1
PostPosted: Wed Feb 20, 2013 10:16 pm 
Offline

Joined: Wed Mar 22, 2006 11:15 am
Posts: 712
Location: Southern California
tseyfarth wrote:
Hi All,

I am running locally, (localhost). I copied the plugin from 2012R1.2 to 2.1 and the problem is gone. But I still and a little skittish.

No SSL, and no DB error. Code has not changed at all. I just swapped the plugin and it was fixed...
Tim


Hmmm...now I'm wondering if I accidentally copied over the v1.2 plugin. I don't recall ever having a problem, but for minor upgrades I just copy my MBS/Einhugur plugins. I could have grabbed everything by mistake.

_________________
Daniel L. Taylor
Custom Controls for Real Studio WE!
Visit: http://www.webcustomcontrols.com/


Top
 Profile  
Reply with quote  
 Post subject: Re: Cannot Open PostgreSql in RS V 2.1
PostPosted: Wed Feb 20, 2013 10:32 pm 
Offline

Joined: Sat Dec 04, 2010 9:14 pm
Posts: 918
That is exactly what I was thinking. I too have plugins - and just recently updated all of them. But since I normally use SQLite, it was not an issue. Only after having to do some work in Web Edition which uses PostgreSQL, that the problem surfaced. And after spending quite some time to find the problem (no SQL error) I finally tried the same code in R1.2 and saw that it was really not my code (not too crazy!).

This afternoon I copied/pasted the postgresql 2012R1.2 plugin over to the 2012r2.1 and the problem dissappeared.

I am on Windows7 Home Premium BTW. PostgreSQL 9.1

Tim


Top
 Profile  
Reply with quote  
 Post subject: Re: Cannot Open PostgreSql in RS V 2.1
PostPosted: Wed Feb 20, 2013 11:18 pm 
Offline
Real Software Engineer

Joined: Sat Dec 24, 2005 8:18 pm
Posts: 7858
Location: Canada, Alberta, Near Red Deer
JohnV wrote:
tseyfarth wrote:
Ideas anyone? Is the Postgre Plugin NG?


Realsoftware has decided on Postgre for internal use so that particular plugin gets move love than the others.....

(For what its worth)


We actually use several including PostgreSQL, mySQL & of course sqlite

_________________
Norman Palardy (Real Software)


Top
 Profile  
Reply with quote  
 Post subject: Re: Cannot Open PostgreSql in RS V 2.1
PostPosted: Wed Feb 20, 2013 11:32 pm 
Offline

Joined: Sat Dec 04, 2010 9:14 pm
Posts: 918
I have not had this problem before either! I did read, I think it was 2012R1 that there was an issue with this plugin, but to use the previous and I did = no problem. But I did not see anywhere, where this or another may be an issue with 2012R2.1 - other than the feedback app....

Also, not throwing rocks at RS. It is for all intents, purposes and my uses - perfect! Lots lots better than any of the other IDE's that I researched and tried for the 1-2 years before buying this one. BTW I just extended my subscription 2+ years into mid 2015. My money went where my mouth is....
Tim


Top
 Profile  
Reply with quote  
 Post subject: Re: Cannot Open PostgreSql in RS V 2.1
PostPosted: Fri Mar 29, 2013 2:48 pm 
Offline

Joined: Sat Dec 04, 2010 9:14 pm
Posts: 918
Has anyone else had this problem? I tried to use the latest PostgreSQL plugin again today, but it will not open the DB. No error either.
I am not using SSL either BTW.

Tim


Top
 Profile  
Reply with quote  
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 10 posts ] 

All times are UTC - 5 hours


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
Jump to:  
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group