freetds AT lists.ibiblio.org
Subject: FreeTDS Development Group
List archive
AW: [freetds] Connect to Sybase ASA 8 with pear:DB
- From: "Florian Kornhoffer" <f.kornhoffer AT laufwerk.de>
- To: "'FreeTDS Development Group'" <freetds AT lists.ibiblio.org>
- Subject: AW: [freetds] Connect to Sybase ASA 8 with pear:DB
- Date: Mon, 14 Jun 2004 08:57:33 +0200
Hi,
>>You have an ASA server. I don't use PHP, but it looks like you're using
the sybase extension. Your server needs an entry in freetds.conf, and the
name of that entry must be the ASA database you want to connect to
('testdb'). I guess your 'hostspec' entry, above, would be that name, not
the server's IP address. <<
thanks for your help - I got a bit further now - but still I'm not
successfull. Here's what happens now:
my testdb.php:
<?php
//DB-Modul laden
require_once "DB.php";
//setzen der variablen für connect
$dsn = array(
'phptype' => 'sybase',
'username' => 'dba',
'password' => 'xyz',
'hostspec' => 'DBX',
'database' => 'testdb',
);
//connect
$db =& DB::connect($dsn);
if (DB::isError($db)) {
die($db->getMessage());
}
freetds.conf:
[global]
tds version = 4.2
[DBX]
host = 62.153.x.x
port = 2638
tds version = 5.0
My result now:
Warning: sybase_connect(): Sybase: Server message: ASA Fehler -83:
Angegebene Datenbank nicht gefunden <<my translation: named database not
found>> (severity 16, procedure N/A) in /usr/local/lib/php/DB/sybase.php on
line 55
Warning: sybase_connect(): Sybase: Client message: Login incorrect.
(severity 78) in /usr/local/lib/php/DB/sybase.php on line 55
Warning: sybase_connect(): Sybase: Unable to connect in
/usr/local/lib/php/DB/sybase.php on line 55
DB Error: unknown error
If I understand that the right way, there now is a connection to the sybase
server itself, but the database 'testdb' itself is not found?
What are possible causes for that?
Thanks
Florian
-
[freetds] Connect to Sybase ASA 8 with pear:DB,
Florian Kornhoffer, 06/10/2004
-
Re: [freetds] Connect to Sybase ASA 8 with pear:DB,
James K. Lowden, 06/11/2004
-
AW: [freetds] Connect to Sybase ASA 8 with pear:DB,
Florian Kornhoffer, 06/14/2004
-
Re: AW: [freetds] Connect to Sybase ASA 8 with pear:DB,
James K. Lowden, 06/14/2004
- AW: AW: [freetds] Connect to Sybase ASA 8 with pear:DB, Florian Kornhoffer, 06/14/2004
-
Re: AW: [freetds] Connect to Sybase ASA 8 with pear:DB,
James K. Lowden, 06/14/2004
-
AW: [freetds] Connect to Sybase ASA 8 with pear:DB,
Florian Kornhoffer, 06/14/2004
-
Re: [freetds] Connect to Sybase ASA 8 with pear:DB,
James K. Lowden, 06/11/2004
Archive powered by MHonArc 2.6.24.