dbTalk Databases Forums  

DB2 Windows 7 64 ODBC connection problem

comp.databases.ibm-db2 comp.databases.ibm-db2


Discuss DB2 Windows 7 64 ODBC connection problem in the comp.databases.ibm-db2 forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Vyacheslav Pak
 
Posts: n/a

Default DB2 Windows 7 64 ODBC connection problem - 10-05-2011 , 06:19 AM






Hello, can somebody help me with my problem?

The subj. I've installed DB2 9.7 on Windows 7 64 and am trying to
connect to it using ODBC. I also created BSTOREDB.

When I'm trying to register it using DB2 Configuration Assistant as a
local user data source an error Occurs (CCA3000C, reason code 73)

If I add BSTOREDB as a user data source using ODBC Data Source
Administrator, in User DSN tab I'm able to create the one, but I can
not connect to it. I get SQL1013N The database alias name or database
name "SAMPLE" could not be found. SQLSTATE=42705 (An undefined server-
name was detected).

Thank you.

Reply With Quote
  #2  
Old   
MarkB
 
Posts: n/a

Default Re: DB2 Windows 7 64 ODBC connection problem - 10-06-2011 , 06:45 AM






On Oct 5, 3:19*pm, Vyacheslav Pak <v... (AT) griddynamics (DOT) com> wrote:
Quote:
Hello, can somebody help me with my problem?

The subj. I've installed DB2 9.7 on Windows 7 64 and am trying to
connect to it using ODBC. I also created BSTOREDB.

When I'm trying to register it using DB2 Configuration Assistant as a
local user data source an error Occurs (CCA3000C, reason code 73)

If I add BSTOREDB as a user data source using ODBC Data Source
Administrator, in User DSN tab I'm able to create the one, but I can
not connect to it. I get SQL1013N *The database alias name or database
name "SAMPLE" could not be found. SQLSTATE=42705 (An undefined server-
name was detected).

Thank you.
Hi Vyacheslav,

It's strange that you have BSTOREDB database and it complains on
SAMPLE database...
Anyway, to register your database BSTOREDB as an ODBC datasource use
the following command (from Start->Run->db2cw):

db2 catalog system odbc datasource BSTOREDB

Regards,
Mark B.

Reply With Quote
Reply




Thread Tools
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

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.