db connection

2004-08-30 Thread Hershel Fisch
Hi all, put revOpenDatabase("PostgreSQL","127.0.0.1","test",postgres,) revdberr,invalid database type . Is this because its not the final release ? Hershel Fisch ___ use-revolution mailing list [EMAIL PROTECTED] http://lists.runrev.com/mailman/listin

Re: db connection

2004-08-30 Thread Pierre Sahores
Hello Hershel, Did you try this : put revOpenDatabase("PostgreSQL","localhost","projetsdac","postgres","postg res") into PGLinkOpen with the second "postgres" item as the default postgres user password (to be replaced by the right one if you changed it) ? Works there, at least under Panther.

Re: db connection

2004-08-30 Thread Hershel Fisch
On Monday, August 30, 2004, at 05:02 PM, Pierre Sahores wrote: Hello Hershel, Did you try this : put revOpenDatabase("PostgreSQL","localhost","projetsdac","postgres","post gres") into PGLinkOpen with the second "postgres" item as the default postgres user password (to be replaced by the right

Re: db connection

2004-08-31 Thread Pierre Sahores
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","pos tgres") into PGLinkOpen with the second "postgres" item as the default postgr

Re: db connection

2004-08-31 Thread Hershel Fisch
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

Re: db connection

2004-08-31 Thread Hershel Fisch
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

Oracle DB Connection

2005-10-05 Thread David Anderson
Hello All I have just purchased the Enterprise license so I can connect to an oracle database. Reading in the documentation, it says: Oracle: Oracle database drivers are not included as part of the Revolution installation on any platform. To obtain an Oracle database driver for your platfo

Oracle DB connection

2005-10-06 Thread David Anderson
Hello All I have just purchased the Enterprise license so I can connect to an oracle database. Reading in the documentation, it says: Oracle: Oracle database drivers are not included as part of the Revolution installation on any platform. To obtain an Oracle database driver for your platfo

Oracle DB Connection

2005-10-06 Thread David Anderson
Hello All I have just purchased the Enterprise license so I can connect to an oracle database. Reading in the documentation, it says: Oracle: Oracle database drivers are not included as part of the Revolution installation on any platform. To obtain an Oracle database driver for your platfo

Testing a DB connection

2010-05-26 Thread Alex Adams
Does anyone have a simple technique for testing to see if a DB connection is still functioning before trying to use it to execute some SQL? I have an app that accesses hosted databases directly (postgres). Users logon at app startup. If they let the app sit for long enough, the connection to

Re: Testing a DB connection

2010-05-26 Thread stephen barncard
he burst. On 26 May 2010 09:50, Alex Adams wrote: > Does anyone have a simple technique for testing to see if a DB connection > is > still functioning before trying to use it to execute some SQL? > > I have an app that accesses hosted databases directly (postgres). Users > log

Re: Testing a DB connection

2010-05-26 Thread Andre Garzia
Alex, I know sqlYoga does that and if the connection died, it tries to reopen it but I don't know the implementation details. Andre On Wed, May 26, 2010 at 1:50 PM, Alex Adams wrote: > Does anyone have a simple technique for testing to see if a DB connection > is > still func

Re: Testing a DB connection

2010-05-26 Thread stephen barncard
und there is > surprisingly little overhead in just opening and closing the database for > every query, unless one needs a rapid-fire sequence of queries. Then one > could program the open and close for the burst. > > > On 26 May 2010 09:50, Alex Adams wrote: > >> D

Re: Testing a DB connection

2010-05-26 Thread Trevor DeVore
On May 26, 2010, at 1:23 PM, Andre Garzia wrote: I know sqlYoga does that and if the connection died, it tries to reopen it but I don't know the implementation details. All SQL Yoga queries go through a central handler that checks for a particular error message from RevDB. If the error is

Re: Testing a DB connection

2010-05-26 Thread Bob Sneidar
y 26, 2010, at 9:50 AM, Alex Adams wrote: > Does anyone have a simple technique for testing to see if a DB connection is > still functioning before trying to use it to execute some SQL? > > I have an app that accesses hosted databases directly (postgres). Users > logon at app star