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

Posted on 2003-04-01
Medium Priority
Last Modified: 2011-10-03
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 ?

Question by:ibnou
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions

Accepted Solution

shirras earned 150 total points
ID: 8248140
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.

Author Comment

ID: 8248528
;) Great Thanks for your help shirras!!!!

Featured Post

Veeam Task Manager for Hyper-V

Task Manager for Hyper-V provides critical information that allows you to monitor Hyper-V performance by displaying real-time views of CPU and memory at the individual VM-level, so you can quickly identify which VMs are using host resources.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

November 2009 Recently, a question came up in the DB2 forum regarding the date format in DB2 UDB for AS/400.  Apparently in UDB LUW (Linux/Unix/Windows), the date format is a system-wide setting, and is not controlled at the session level.  I'm n…
Recursive SQL in UDB/LUW (you can use 'recursive' and 'SQL' in the same sentence) A growing number of database queries lend themselves to recursive solutions.  It's not always easy to spot when recursion is called for, especially for people una…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
Suggested Courses

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question