Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 989
  • Last Modified:

Error SQL1001 when making an ODBC connection to UDB Server, please help

Hi all,
 I have an UDB Server installed on a Win 2000 server. Now I want to create an ODBC connexion on a client workstation using "IBM DB2 ODBC DRIVER", so I create an alias for the database "Pubs" (Pubs is a database on the UDB server) by putting these informations on the "TCP/IP" tab :
Database name : Pubs
Alias : Pubs
Host Name : ServDb2
Port : 50000

When I click the button "Connection", I got this error :
  SQL1001N"         " is not a valid database name. SQLSTATE=2E000

How can I configure the ODBC Connection ?

1 Solution
The easiest way to handle this is to install the runtime client (downloadable from IBM's website or you can do a selective install from the UDB cd) on the client workstation and catalog the database through the Client Configuration Assistant (can be started from the 'Run' option of the start menu by entering db2cca or from the 'Client Configuration Assistant' under 'IBM DB2' of the programs menu).  The IBM driver uses a two part catalog system that includes a node and database entry for each database.  Using the GUI for the 'Client Configuration Assistant' is fairly easy and self explanatory and will even make the odbc entry for you if so desired.
Hope this helps, if you need more info let me know.
ibnouAuthor Commented:
;) Great Thanks for your help shirras!!!!

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now