If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > DB2 > Error: [IBM][CLI Driver] SQL1031N

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 02-15-11, 04:45
a_abels a_abels is offline
Registered User
 
Join Date: Aug 2010
Posts: 12
Error: [IBM][CLI Driver] SQL1031N

Helo,

i'm an perl programmer working with dbi and try to get an connection to db2 db server. I don't know nothing about db2, i only try to get a connection to a db2 server via dbi drivers in perl.

My test environment looks like this:

- one machine: db2 v9 database on Windows 2003 Enterprise Server
- another machine: db2 runtime client v9.7

In my perl i already do some connections to oracle, mysql and sybase. All connections are working (after installing the client software and the appropriate drivers in perl).

But i don't know how to connect to the db2 database or how to check if the connection is available (over db2 tools). I know there is db2 command but i don't know the syntax to get a connection.

Perl delivers this error messsage:
Code:
DBI connect('customer','administrator',...) failed: [IBM][CLI Driver] SQL1031N  The database directory cannot be found on the indicated file system.  SQLSTATE=58031
Do i have to set environment variables? Maybe there is someone who can tell me a command and the syntax to try to connect with db2 tools.

Thanks in advance

André
Reply With Quote
  #2 (permalink)  
Old 02-15-11, 06:54
dr_te_z dr_te_z is offline
Registered User
 
Join Date: Jan 2009
Location: Zoetermeer, Holland
Posts: 555
This is not a perl issue. You must establish a connection between your db2-server and db2-client first. Your name sounds dutch.. are you? I could call you and talk you thru.
mail you number to dr_te_z@linuxmail.org
Reply With Quote
  #3 (permalink)  
Old 02-15-11, 07:08
a_abels a_abels is offline
Registered User
 
Join Date: Aug 2010
Posts: 12
I'm not dutch, i'm german.

Thank you very much for your offer to help via phone.

I solved the problem in this minute.

I found this issue help: IBM - Configuring DB2 For Install Using a Remote DB2 Server Or WebSphere Network Deployment

Now i'll install a new client os and try it again. If there will be any problems after reinstalling and trying again i'll take your offer.

Thanks André
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On