473,608 Members | 2,412 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Catalog table used by Client when connecting via ODBC

Hello,

we get a message SQL0204N when trying to import tables from a DB2/VM
into an MS Access database.
The message text is: ... "DB2/VM SQL0204N 'SQLTables ' not defined
".

When importimg from an ODBC data source Access offers a list box
containing all the tables/views etc. The user can select one or more
tables to import.

In Version 7 the DB2 client uses SYSTEM.SYSCATAL OG to fill the list
box. In version 8 the client by default tries to read
SYSIBM.SQLTABLE S which does not exist in a DB2/VM Version 7 database
(and which cannot be created by the user). Therefore we get the -204
message - and an empty listbox.

Is it possible to tell the V8-client what catalog table to use? We
examined all the CLI cfg parms but none of them seems to do what we
want. Or are we overall wrong?

Thanks in advance for reading this and offering any idea! R.O.
Nov 12 '05 #1
1 3009
Ralf Obst wrote:
Hello,

we get a message SQL0204N when trying to import tables from a DB2/VM
into an MS Access database.
The message text is: ... "DB2/VM SQL0204N 'SQLTables ' not defined
".

When importimg from an ODBC data source Access offers a list box
containing all the tables/views etc. The user can select one or more
tables to import.

In Version 7 the DB2 client uses SYSTEM.SYSCATAL OG to fill the list
box. In version 8 the client by default tries to read
SYSIBM.SQLTABLE S which does not exist in a DB2/VM Version 7 database
(and which cannot be created by the user). Therefore we get the -204
message - and an empty listbox.

Is it possible to tell the V8-client what catalog table to use? We
examined all the CLI cfg parms but none of them seems to do what we
want. Or are we overall wrong?

Thanks in advance for reading this and offering any idea! R.O.

Check to see if there is support for an ODBC shadow catalog for your
platform. It is implemented as a set of tables and routines. On the
DB2 Client, use CLISCHEMA to specify the ODBC catalog schema you want to
use for the database alias.

Hope this helps.
Norm
Nov 12 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
6898
by: Roy Souther | last post by:
Trying to get the unixODBC to work connecting to an IBM DB2 UDB V8.1. The DB2 server is running on Red Hat 8 and is tested and confirmed to be serving connections to Windows 98 clients using the Accpac 5.1 client program (I would like to find an OpenSource generic ODBC program for Wiindows that can do simple SQL). An Accpac database was installed and the Win32 ODBC connection is working. Trying to connect a Linux client via unixODBC I...
3
23447
by: Jon Ole Hedne | last post by:
My Access 2002-application need to work with tables from both Oracle and Access. To solve this, I want to run some querys on three views in Oracle and import the results into temporary Access-tables. I have tried this: conn.Provider = "Microsoft.Jet.OLEDB.4.0" conn.ConnectionString = "data source=" & datafil & ";Jet OLEDB:Database Password=" conn.Open datafil
3
5577
by: Ian | last post by:
We are currently experiencing problems with our Access XP database. We are using access as the front-end and are connecting to Oracle 7.3 via ODBC. Our users are running Win 98 and Win Xp. We are currently using Oracle73 drivers ver:1.15.03.01 File: SQ032.73.dll Date:18/06/1996. The Problem, I can re-link the Oracle tables and open them within access, However the tables take around a minute to open. When I try to run a query I receive...
4
1902
by: datapro01 | last post by:
Running DB28.2 on AIX 5.2. I have two questions if its possible for anyone to assist. 1. Is it possible to make use of a 'Shadow Catalog' on DB2 UDB v8.2 on AIX? If so, how? Can anyone give me an example of the SQL to create the appropriate view and catalog table? 2. Is there anyway via the ODBC datasource parameters to influence the SQLTables and SQLColumns stored procedures to use a schema_name when
2
1750
by: Bob Stearns | last post by:
I am connecting to a linux based db2 v8.1.9. I want to use CLIENT USERID in my views to perform data restriction. Unfortunately it not set inside an ODBC session, a client CLI session or a server session. All three return blank as the result even though the userid is available for diagnostics. On the other hand it is set as I wish and can be SELECTed when I run my GUI client of choice, aquadata studio. Is there some odbc parameter or db2...
2
2713
by: Laurence | last post by:
Hi folks, I installed DB2 V9.1 FP2 on RHEL AS V4 (DB2 Server) and Win XP SP2 (DB2 Client). The strange thing, there were two database aliases TOOLS0 & TOOLS1 in the DB2 Client that were mapping to the same remote tools catalog database TOOLSDB in the DB2 Server after I created a new tools catalog database by Control Center.
5
2795
by: Neil | last post by:
I'm running Access 2000 with a SQL 7 back end, using ODBC linked tables in an MDB file. The db is used by about 30 users on a LAN, and an additional 10 or so on a WAN. Recently, one of the WAN users complained of intermittently not being able to find certain customers in the customers table (contains around 40,000 records). There are specific "problem records" of customers that can't be found, and they all start with the letter "F" (the...
2
1561
by: =?Utf-8?B?TXIgQg==?= | last post by:
I had originally posted this in another thread, but did not get and results. I appologize for cross posting but I really would like to get some assistance with this. I am new to developing in VB.net so my question may be very elementary with I need some assistance, so here goes: I am using vb.net 2003. I have a form with four bound text boxes. I am using an ODBC data adapter
9
15135
by: fniles | last post by:
I would like to copy a table(s) from SQL Server 2005 to a CVS file and vice versa. I was thinking to use the BCP command line utility, but I have a few questions: 1. The machine where I am going to run BCP utility does not have SQL Server installed, so BCP.exe and its underlying DLLs are not there. I copied BCP.EXE, then it tells me that it expects sqlncli.dll. After I copied that DLL, it now says "Unable to load BCP resource DLL. BCP...
0
8067
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
8501
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
8483
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
8349
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
1
6015
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
3967
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
4030
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
1607
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
1336
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.