UDADTS Problem

FAQ

Profile

UDADTS Problem

Database Help (Home) -> Ingres

Next: Dates for Reports

Author

Message

Michael Maliappis

External

Since: Oct 11, 2008
Posts: 1

(Msg. 1) Posted: Fri Oct 10, 2008 8:25 pm Post subject: UDADTS Problem Archived from groups: comp>databases>ingres (more info?)

Hi everyone, I'm trying to migrate from Ingres SPARC SOLARIS Version II 2.5/0011 to Ingres 2006 Release 2 SPARC SOLARIS Version II 9.1.1. In the current installation we use some udadts and they work very well. In the new installation we tried, as a first step to use the demo udadts. We compiled the .c files using gcc. The iilink completed without any error. Ingres is up and running. Everything seams to work well, but Ingres fails to recognize any demo udadts. Any suggestions? Thanks in advance. Michael Maliappis Ingres DBA administrator Agricultural University of Athens, Greece >> Stay informed about: UDADTS Problem

Denise Vancil

External

Since: Oct 10, 2008
Posts: 1

(Msg. 2) Posted: Fri Oct 10, 2008 9:07 pm Post subject: Re: [Info-Ingres] UDADTS Problem [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)

Hello Michael, The DBMS needs to be stopped and restarted. That is the way I have always linked the demo udadts into the Ingres DBMS. I have always followed this procedure: 1. ingstop 2. iilink 3. ingstart The Ingres Object Management Extension User Guide also suggests the above install steps. I have never seen the DBMS recognize the udadts unless the DBMS was bounced. - Denise _______________________________________________ Info-Ingres mailing list Info-Ingres RemoveThis @kettleriverconsulting.com http://www.kettleriverconsulting.com/mailman/listinfo/info-ingres -----Original Message----- From: info-ingres-bounces RemoveThis @kettleriverconsulting.com [mailto:info-ingres-bounces@kettleriverconsulting.com] On Behalf Of Michael Maliappis Sent: Friday, October 10, 2008 6:37 PM To: info-ingres RemoveThis @kettleriverconsulting.com Subject: [Info-Ingres] UDADTS Problem Hi everyone, I'm trying to migrate from Ingres SPARC SOLARIS Version II 2.5/0011 to Ingres 2006 Release 2 SPARC SOLARIS Version II 9.1.1. In the current installation we use some udadts and they work very well. In the new installation we tried, as a first step to use the demo udadts. We compiled the .c files using gcc. The iilink completed without any error. Ingres is up and running. Everything seams to work well, but Ingres fails to recognize any demo udadts. Any suggestions? Thanks in advance. Michael Maliappis Ingres DBA administrator Agricultural University of Athens, Greece _______________________________________________ Info-Ingres mailing list Info-Ingres RemoveThis @kettleriverconsulting.com http://www.kettleriverconsulting.com/mailman/listinfo/info-ingres >> Stay informed about: UDADTS Problem

Karl & Betty Schendel

External

Since: Jan 16, 2008
Posts: 29

(Msg. 3) Posted: Sat Oct 11, 2008 9:36 am Post subject: Re: [Info-Ingres] UDADTS Problem [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)

On Oct 10, 2008, at 7:36 PM, Michael Maliappis wrote: > > The iilink completed without any error. > > Ingres is up and running. Everything seams to work well, but Ingres > fails to > recognize any demo udadts. > > Any suggestions? > The problem is most likely in the link. As I recall, Solaris merges the udt's into the iimerge.o object, so there's no easy way to examine the output to make sure that your udt code actually made it into the result. I'd be tempted to find the link command in iilink and execute it by hand, just to verify that it's picking up your UDT code. Solaris is a hybrid installation, and the server will be running in 64-bit mode on any modern Sun. Make sure that you've compiled your UDT in 64-bit mode, and make sure that iilink is picking it up for the 64-bit server (the one in $II_SYSTEM/ingres/bin/lp64). Karl >> Stay informed about: UDADTS Problem

Display posts from previous:

Related Topics:

First Time install of ICE - problem - Getting the following error when httpd starts: Cannot load ....../ingres/ice/bin/apache/oiice.1.so into server: .....: undefined symbol: ap_table_get Can anyone point me in the direction of the solution? tia, --cnemelka

Optimization Problem on Ingres2006 database - We have some optimization statistics problem. First we run optimizedb -zk sales But then we get this messages on every table we try to use on our application. E_OP03A2_HISTINCREASING consistency check - histogram on taliprovta attribute idmes...

Anyone using Plone with Ingres? - I'm currently playing about with Plone and Ingres (i.e. I have created a ZODB that is stored in an Ingres database). I am curious to know who else is. Roy

Windows Server 2003 Ingres Net Problems - Gday, I am running Ingres Net (version 2.6 SP2) on a Windows Server 2003 box with ODBC Driver version 3.50.00.32 and am having some problems with stability. Essentially the problem is that I get a random Ingres ODBC error ERROR [HY000] [CA][Ingres ODBC...

ODBC error message: Unable to authenticate client's user ID - Hi list, we have two machines: 1. Suse Linux with Ingres 2.6 SP2 DBMS 2. Win 2000 Server with IngresNet (client-only) 2.5 The Win 2000 box starts a Borland-Delphi-app that connects via ODBC, unfortunately this fails. Errlog.log on the Windows machine....

	Database Help (Home) -> Ingres	All times are: Pacific Time (US & Canada) (change)
Page 1 of 1

You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum