If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > DB2 > Connection Caché - DB2 problem

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 05-17-04, 14:50
sjsoliveira sjsoliveira is offline
Registered User
 
Join Date: May 2004
Posts: 3
Question Connection Caché - DB2 problem

Hi,
from win2k I am trying to call a remote procedure in a AS400 machine using
ODBC. But I always get this error: " SQLState: (01000) NativeError: [0]
Message: [IBM][Controlador de ODBC do Client Access Express (32 bits)]Suporte
Dinâmico de Extensão desactivado." This means something like "Extension dynamic
support disabled". And it doenst allow me to properlly execute the procedure.
Do you know what the problem is?
Thank you very much.
Reply With Quote
  #2 (permalink)  
Old 05-19-04, 04:54
blom0344 blom0344 is offline
Registered User
 
Join Date: Jan 2003
Location: Zutphen,Netherlands
Posts: 256
Did you enable 'Enable extended dynamic (package) support' in the DSN settings (see: configure option for Client Access ODBC DSN)
__________________
Ties Blom
Senior Application Developer BI
Getronics Healthcare
DB2,ORACLE,Powercenter,BusObj,Access,
SQL, SQL server
Reply With Quote
  #3 (permalink)  
Old 05-19-04, 05:29
sjsoliveira sjsoliveira is offline
Registered User
 
Join Date: May 2004
Posts: 3
I am trying to access "INTPCS" library, and by default under the tab "Package" I let the "QGPL" library with the option you refer activated, as you might see on the attached image. I also tryed to define there the "INTPCS" library but it didnt work either. Is there any kind of related option on the AS400 server side? Could you tell me if I should define anything different under this tab? Thank you a lot.
Attached Images
File Type: bmp Enable extended dynamic (package) support.bmp (706.5 KB, 100 views)
Reply With Quote
  #4 (permalink)  
Old 05-19-04, 06:07
blom0344 blom0344 is offline
Registered User
 
Join Date: Jan 2003
Location: Zutphen,Netherlands
Posts: 256
I am using a newer client access version than you (I am on V5R2) , but can you choose the application that addresses the AS400 and enable the package usage? (use / or use/add)
__________________
Ties Blom
Senior Application Developer BI
Getronics Healthcare
DB2,ORACLE,Powercenter,BusObj,Access,
SQL, SQL server
Reply With Quote
  #5 (permalink)  
Old 05-19-04, 09:08
sjsoliveira sjsoliveira is offline
Registered User
 
Join Date: May 2004
Posts: 3
Before trying your idea, I made a really dummy thing... Unticked that famous option, made a restart and tried it on... and it worked!!!

Now I put back the option enabled, just as it is in the image and it stills working!!!
I am very about this!! But if it is the solution...

I really appreciate your help. Thank you very very much. Sergio.
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
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

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On