Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
DB2 Windows 7 64 ODBC connection problem
288 views
Skip to first unread message
Vyacheslav Pak
Oct 5, 2011, 7:19:29 AM10/5/11
to
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.
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.
MarkB
Oct 6, 2011, 7:45:34 AM10/6/11
to
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.
0 new messages