headers
Fernando Lusardo | 1 Apr 2007 18:19
Picon

problem with dsn firebird connection

I'm trying to make a firebird dsn connection like this:
 
<?php
 include('adodb/adodb.inc.php'); 
 $dsn = 'firebird://SYSDBA:masterkey <at> localhost/lusardo/lusardo.gdb?persist&dialect=3';
 $db->debug = true; 
 $db = NewADOConnection($dsn);  # no need for Connect/PConnect
 
but it give me an error:
 
Warning: ibase_pconnect() [function.ibase-pconnect]: I/O error for file "lusardo/lusardo.gdb" Error while trying to open file O sistema não pode encontrar o caminho especificado. in E:\Apache2\htdocs\testeadodb\adodb\drivers\adodb-ibase.inc.php on line 74
Connection failed

I need to make a dsn connection with firebird, pleast any help?
 
thanks
Fernando Lusardo
-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys-and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
ADodb-general mailing list
ADodb-general <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/adodb-general
Permalink | Reply | 1 comment |
headers
Lester Caine | 1 Apr 2007 19:19
Picon
Favicon
Gravatar

Re: problem with dsn firebird connection

Fernando Lusardo wrote:
> I'm trying to make a firebird dsn connection like this:
>  
> <?php
>  include('adodb/adodb.inc.php'); 
>  $dsn = 
> 'firebird://SYSDBA:masterkey <at> localhost/lusardo/lusardo.gdb?persist&dialect=3';
>  $db->debug = true; 
>  $db = NewADOConnection($dsn);  # no need for Connect/PConnect
>  
> but it give me an error:
>  
> *Warning*: ibase_pconnect() [function.ibase-pconnect]: I/O error for 
> file "lusardo/lusardo.gdb" Error while trying to open file O sistema não 
> pode encontrar o caminho especificado. in 
> *E:\Apache2\htdocs\testeadodb\adodb\drivers\adodb-ibase.inc.php* on line 
> *74*
> Connection failed

Since you are obviously using windows, the '/' should probably be a '\' but it 
would be more correct to use an alias than the direct path to the file.

I don't use this rather insecure method of passing the user name and password. 
I'm still using the separate parameters in NewADOConnection

--

-- 
Lester Caine - G8HFL
-----------------------------
Contact - http://home.lsces.co.uk/lsces/wiki/?page=contact
L.S.Caine Electronic Services - http://home.lsces.co.uk
MEDW - http://home.lsces.co.uk/ModelEngineersDigitalWorkshop/
Treasurer - Firebird Foundation Inc. - http://www.firebirdsql.org/index.php

-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys-and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
Permalink | Reply | 0 comments |
headers
Sallie Herrera | 6 Apr 2007 03:33
Picon

As till saguaro

Trading 0pportunity For You!

Lookup: CDYV, Current: $0.089 (5 Day Target price: $0.425!), Expected: Steadily climb for the top!

TRADE SMART AND WIN WITH US!

See bullish news online right now, adodb-general, call broker!

-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys-and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
Permalink | Reply | 1 comment |
headers
R. Vince | 6 Apr 2007 14:23
Picon
Favicon

Re: As till saguaro

Does anyone know if ADOdb can access a Linux Progress DB? Thanks.

-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys-and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
Permalink | Reply | 0 comments |
headers
Mário Gamito | 9 Apr 2007 15:29
Picon

How to "sense" the last record

Hi,

I'm doing this site that has three news in the homepage.
You can see the static version here:
http://www.telbit.pt
As you can see, the two first news have "blocoTexto" class and the 
third, "blocoTextoLast"

Now, i'm developing a dinamyc structure where the news are stored in a 
MySQL database and retrieved from there.

My problem is with the third news and it's different class.
I'm using AdoDB recordSet to get the news from the database.

But how can i "sense" that i've reached the last row and apply the 
"blocoTextoLast" class to it ?

My code follows my signature.

Any help would be appreciated.

Warm Regards
-- 
:wq! Mário Gamito
--
<div id="blocoNews">
  <?php
   include('config.php');
   include('adodb/adodb.inc.php');

   // connect to MySQL
   $conn->debug=1;
   $conn = &ADONewConnection('mysql');

$conn->PConnect($host,$user,$password,$database);

   // get news data
   $recordSet = &$conn->Execute("SELECT date, now, title, lead, body 
FROM    news ORDER BY date DESC LIMIT 3");

  if (!$recordSet)
   print $conn->ErrorMsg();
  else
   while (!$recordSet->EOF) {
    print '<div class="blocoTexto">' . ' <h3>' . $recordSet->fields[2] . 
    '</h3>' . '<p class="data">' . $recordSet->fields[0] . '</p>' .
'<p>' . $recordSet->fields[3] . '</p>' . '</div>';

  $recordSet->MoveNext();
}
  echo "<br class=\"clear\">";	

  $recordSet->Close();
  $conn->Close();
?>
		<!-- end #secContent --> 	
		</div>

-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys-and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
Permalink | Reply | 0 comments |
headers
Luis Gallegos | 18 Apr 2007 00:25
Picon

Hi, can i connect to ORACLE 10G with adodb

Hi, how can i connect to the ORACLE 10G. Thanks for your answers.
 
Luis G.

--
Luis Enrique Gallegos 
-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
_______________________________________________
ADodb-general mailing list
ADodb-general <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/adodb-general
Permalink | Reply | 0 comments |
headers
vibeesh p | 18 Apr 2007 15:29
Picon

need help

i am working with php-adodb and the dbms is postgres
to catch postgres exceptions i have included
adodb/adodb-exceptions.inc.php and try ..... catch

my code looks like

require("adodb/adodb.inc.php");
require("adodb/adodb-exceptions.inc.php");
$host="localhost";
$user="postgres";
$port=5432;
$dbname="test";
$db=ADONewConnection("postgres");
$db->PConnect("host=$host user=$user port=$port dbname=$dbname") or die("Unable to connect");
try
{
$rs=$db->execute("selct * from mytb");
}
catch(exception $e)
{
echo "Error";
print_r($e);
}

the sql is not right a lot of mistakes are there but the exception is not caught.

if it is wrong plz help to caught the exceptions in postgres

-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
_______________________________________________
ADodb-general mailing list
ADodb-general <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/adodb-general
Permalink | Reply | 0 comments |

Gmane