Re: [U2] SQL server to Universe via ODBC problems

2010-06-15 Thread ptnaman
Craig: Thanks so much for the feedback.. We are in the process of working with Rocket to see if they can address any of this.. Will let all know what feedback we get.. regards, Jay Jones PTNA Allentown, PA Craig Purnell wrote: > > Hello > > Some thoughts and some code for you. > > 1. Ar

Re: [U2] SQL server to Universe via ODBC problems [AD]

2010-06-15 Thread Robert Houben
server.u2ug.org] On Behalf Of Craig Purnell Sent: Monday, June 14, 2010 5:31 PM To: U2 Users List Subject: Re: [U2] SQL server to Universe via ODBC problems Hello Some thoughts and some code for you. 1. Are you running SQL Server 64bit on 64bit Windows? With running SQL at -g2048 you would almost ha

Re: [U2] SQL server to Universe via ODBC problems

2010-06-14 Thread Craig Purnell
Hello Some thoughts and some code for you. 1. Are you running SQL Server 64bit on 64bit Windows? With running SQL at -g2048 you would almost have to be. 2048 is a very high value for the virtual address space, but I guess you had to do it to keep the application running. It's not a good long term

Re: [U2] SQL server to Universe via ODBC problems

2010-06-14 Thread ptnaman
ttachments > and non-textual entries). > > 2. You haven't said what version or edition of SQL Server you are running. > > 3. Whilst your query to analyze memory is interesting, it is of little use > without knowing the queries you are executing against the linked server > ... c

Re: [U2] SQL server to Universe via ODBC problems

2010-06-11 Thread Brian Leach
lf Of ptnaman Sent: 10 June 2010 3:34 PM To: u2-users@listserver.u2ug.org Subject: [U2] SQL server to Universe via ODBC problems This document describes a continuing problem we have been experiencing using a SQL Server linked server connection to an IBM UniVerse data source via ODBC. This issue mani

Re: [U2] SQL server to Universe via ODBC problems

2010-06-11 Thread ptnaman
We do have requests into Rocket and a followup conference call is being scheduler, but they have been of little assistance so far.. Thx for help, and I'll let all know what we find out.. regards, Jay Bill Brutzman wrote: > > I am in the process of upgrading our Windows SBS (Small Business Ser

Re: [U2] SQL server to Universe via ODBC problems

2010-06-11 Thread Bill Brutzman
I am in the process of upgrading our Windows SBS (Small Business Server) from 2003 to 2008. Dell indicated that I needed to upgrade the server RAM from 4-GB to at least 8-GB. I see that one of the machines there only has 2-GB and yet the same error comes back. I cannot tell how much RAM is on t

[U2] SQL server to Universe via ODBC problems

2010-06-10 Thread ptnaman
We have been experiencing both “Out of memory” and “fatal catastrophic failure” messages when querying a linked server setup to an IBM UniVerse ODBC connection. We have tested using both our production server as well as a virtual test environment and see the same results. >> Universe environment

[U2] SQL server to Universe via ODBC problems

2010-06-10 Thread ptnaman
http://old.nabble.com/file/p28844038/PASS_UV%2BODBC%2BMemory%2Berrors.doc PASS_UV+ODBC+Memory+errors.doc -- View this message in context: http://old.nabble.com/SQL-server-to-Universe-via-ODBC-problems-tp28844038p28844038.html Sent from the U2 - Users mailing list archive at Nabble.com.

[U2] SQL server to Universe via ODBC problems

2010-06-10 Thread ptnaman
This document describes a continuing problem we have been experiencing using a SQL Server linked server connection to an IBM UniVerse data source via ODBC. This issue manifests itself when querying the linked server, and appears to be related to an overall gradual loss of memory. We have tested u

[U2] SQL server to Universe via ODBC problems

2010-06-10 Thread ptnaman
This document describes a continuing problem we have been experiencing using a SQL Server linked server connection to an IBM UniVerse data source via ODBC. This issue manifests itself when querying the linked server, and appears to be related to an overall gradual loss of memory. We have tested u