If you post a question, make sure you include a CREATE TABLE... I never thought about that before. Re: Facing problem in ODBC datasource configuration for ingress… JR "Bob" Dobbs-qSBHQ2 Jan 4, 2010 7:30 AM (in response to Zaid Al-Hilali) Things to check/try.1. Subscribe Get updates on the latest Actian ESD downloads via RSS 2.0 or Atom feeds. © 2017 Actian Corporation. this page
You can download attachments. DTS (well actually SSIS's Import Wizard, which can be called straight from SSMS) has the ability to get the table definitions..ODBC drivers are all about a standard way to get data.you You can't edit other events. that'll be developer time for someone who knows SQL and also can follow the Ingress proc logic.
with your description of the problem, we can provide a tested, verifiable solution to your question! You can't delete your own posts. You can't delete your own topics. statement into that table to give the volunteers here representative data.
we wouldn't be having this problem (as that was still 32-bit). After creating a new 'vnode' entry in the Unix server using the "netu" utility, I created a new ODBC DSN again but still see the V-Node as "local" only. I'll keep that in mind - it would be handy though if Data Services would offer separate 32-bit and 64-bit Connection Servers just like BusinessObjects does._________________Erik Roelofs Soltius NZ - SAP have a peek here Cause INFA_CauseThe non-loading into the target table is due to Ingress ODBC drivers.
Ingress ODBC driver is a third-party ODBC driver for PowerCenter. Lowell--help us help you! Please enable scripts and reload this page. So a good time for my test extract is ~6s.
I have installed the Ingres ODBC (V2.80.00.72 software on the Windows 2000 server, but I am unable to select a V-Node other than "local". http://esd.actian.com/product/drivers/ODBC/Windows_32-Bit/ODBC_Driver_3.50 Back to top Display posts from previous: All Posts1 Day7 Days2 Weeks1 Month3 Months6 Months1 YearOldest FirstNewest First Register or Login to Post Forum Index -> Data Integrator -> DI: Installation, Ingres Jdbc Driver You can't delete other posts. I think Ingress odbc driver required in Ingress machine only.
statement and INSERT INTO... this website check if the DataDirect drivers that are shipped with DS have Ingress Driver if yes, use that DS Designer still comes with 32-bit version, it also has al_engine, you can use More discussions in ColdFusion All CommunitiesColdFusion 2 Replies Latest reply on Jan 5, 2010 3:07 AM by Zaid Al-Hilali Facing problem in ODBC datasource configuration for ingress… Zaid Al-Hilali Jan 4, Reply With Quote 11-04-03,11:11 #3 dbabren View Profile View Forum Posts Registered User Join Date Jul 2003 Location England Posts 152 You will need to create a new odbc connection in
So a local DS Designer installation comes with its own "job server"? You can't post events. Like Show 0 Likes(0) Actions Go to original post Actions More Like This Retrieving data ... Get More Info statement into that table to give the volunteers here representative data.
statement and INSERT INTO... This document resolved my issue This document did not resolve my issue This document helped but additional information was required to resolve my issue What can we do to improve this Has anyone had any luck connecting SAP Data Services 4.2 to an Ingres II database?
Hope this helps Regards Dbabren Reply With Quote 11-04-03,11:13 #4 dbabren View Profile View Forum Posts Registered User Join Date Jul 2003 Location England Posts 152 sorry, forgot to say - You can post emoticons. Select a forum SQL Server 2016 SQL Server 2016 - Administration SQL Server 2016 - Development and T-SQL SQL Server 2014 Administration - SQL Server 2014 Development - SQL Server 2014 SQL Server Advertisement dBforums Brief Subscribe to dBforums Brief to receive special offers from dBforums partners and sponsors Top Helpers healdem - 59 mark.b - 55 Pat Phelan - 54 mark.bb - 34
Has anyone else dealt with this issue before? Smaller tables are fine but extractions from larger Ingres tables are taking a long time (up to 6x longer for tables with 11,000,000 rows). You can't post IFCode. see here Compression disabled.
We've passed the issue back to the VM/Network/DBA teams but we haven't had much luck solving the issue yet. Last edited by vb6dv; 11-04-03 at 04:47.