Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
Database Servers
DB2InformixIngresMS SQLOraclePervasive.SQLPostgreSQLProgressSybase
Desktop Databases
FileMakerFoxProMS AccessParadox
General
General DB TopicsDatabase Theory
Related Topics
Java Development.NET DevelopmentVB DevelopmentMore Topics ...

Database Forum / DB2 Topics / December 2005

Tip: Looking for answers? Try searching our database.

SQL1031N connecting to remote database

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
terryintransit@yahoo.com - 25 Nov 2005 13:35 GMT
Im connecting to a database on a remote machine. The node and catalog
command were successfully run. I can connect to the database from the
db2 command line.

db2 => connect to dkt_old user xxx using yyy

  Database Connection Information

Database server        = DB2/LINUX 7.1.0
SQL authorization ID   = DOCKET
Local database alias   = DKT_OLD

I can view and select tables from the remote db.

When I try to connect via DBI it fails

$dbh = DBI->connect("DBI:DB2:dkt_old", <username>, <password>,
                                  { PrintError => 0,
                                    RaiseError => 1,
                                    AutoCommit => 0 } )};

DBI connect('dkt_old','docket',...) failed: [IBM][CLI Driver] SQL1031N
The database directory cannot be found on the indicated file system.
SQLSTATE=58031

I would greatly appreciate any suggestions to the cause of this
problem.

thanks
Knut Stolze - 25 Nov 2005 18:53 GMT
> Im connecting to a database on a remote machine. The node and catalog
> command were successfully run. I can connect to the database from the
[quoted text clipped - 23 lines]
> I would greatly appreciate any suggestions to the cause of this
> problem.

This looks as if you did not start your application, which uses DBI, in a
properly configured and initialized environment.

Signature

Knut Stolze
DB2 Information Integration Development
IBM Germany

juliane26 - 01 Dec 2005 11:29 GMT
Check out the Perl DBI documentation for DB2: there is a description on
how to use perl.

http://publib.boulder.ibm.com/infocenter/db2help/topic/com.ibm.db2.udb.doc/ad/c0
006690.htm

http://www-306.ibm.com/software/data/db2/perl/
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.