Re: [U2] UniOleDB / UniODBC / HS.ADMIN
On the same topic, we are trying to return 5 million rows, but the select fails at about 2 million rows. Is there a limitation on how many rows can be returned through UniOleDB or through the UniRPC service? Uniiverse 10.2.4 AIX Unix 5.3 We have been using UniODBC to run our DTS jobs (to our DataWarehouse) since before I began working here. I have been told by our VAR that our setup is not typical. We are now attempting to change from UniODBC to UniOleDB using SSIS. The problem that I am encountering is the SQL statement will not recognize the visible files in the same manner. We have a file MO-GL-DET and using ODBC, we have to refer to the file as MO_GL_DET in the SQL statement. But with the OleDB connection the file does not exist. I created a new voc (alias) without the hyphens (MOGLDET) and everything works (even without running HS.UPDATE.FILEINFO). I have been unable locate any documentation regarding UniOleDB and file name constraints. Has anybody else discovered similar discrepancies? Vance CONFIDENTIALITY. This electronic mail and any files transmitted with it may contain information proprietary to Deere & Company, or one of its subsidiaries or affiliates, and are intended solely for the use of the individual or entity to whom they are addressed, shall be maintained in confidence and not disclosed to third parties without the written consent of the sender. If you are not the intended recipient or the person responsible for delivering the electronic mail to the intended recipient, be advised that you have received this electronic mail in error and that any use, dissemination, forwarding, printing, or copying of this electronic mail is strictly prohibited. If you have received this electronic mail in error, please immediately notify the sender by return mail. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] UniOleDB / UniODBC / HS.ADMIN
Uniiverse 10.2.4 AIX Unix 5.3 We have been using UniODBC to run our DTS jobs (to our DataWarehouse) since before I began working here. I have been told by our VAR that our setup is not typical. We are now attempting to change from UniODBC to UniOleDB using SSIS. The problem that I am encountering is the SQL statement will not recognize the visible files in the same manner. We have a file MO-GL-DET and using ODBC, we have to refer to the file as MO_GL_DET in the SQL statement. But with the OleDB connection the file does not exist. I created a new voc (alias) without the hyphens (MOGLDET) and everything works (even without running HS.UPDATE.FILEINFO). I have been unable locate any documentation regarding UniOleDB and file name constraints. Has anybody else discovered similar discrepancies? Vance CONFIDENTIALITY. This electronic mail and any files transmitted with it may contain information proprietary to Deere & Company, or one of its subsidiaries or affiliates, and are intended solely for the use of the individual or entity to whom they are addressed, shall be maintained in confidence and not disclosed to third parties without the written consent of the sender. If you are not the intended recipient or the person responsible for delivering the electronic mail to the intended recipient, be advised that you have received this electronic mail in error and that any use, dissemination, forwarding, printing, or copying of this electronic mail is strictly prohibited. If you have received this electronic mail in error, please immediately notify the sender by return mail. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UniOLEDB and Windows 2008/SQL 2008
Yeah! Someone else with the same problem! If your SQL install is the 64bit version there are 3rd party bridge software pieces you can buy to bridge from the 64bit environment to the 32bit driver. I have no real suggestions on what works so I won't mention any names. I think all are going to be fairly expensive. Rocket is working on a 64bit driver but has no ETA yet. If you install the 32bit driver and install a 32bit version of SQL they should work even though you are running a 64bit OS. I say should because we have not yet confirmed it does. We should find out this week if we get time to test it. I suggest calling or emailing rocket software and get on their beta program so you get the 64bit driver as soon as they think they got it working. Jeffrey Lettau ERP Systems Manager polkaudio -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Louise Yang Sent: Tuesday, June 07, 2011 5:25 PM To: 'U2 Users List' Subject: [U2] UniOLEDB and Windows 2008/SQL 2008 I'm trying to migrate SSIS packages from Windows 2003/SQL 2005 to Windows 2008/SQL 2008 and all the packages use UniOLEDB provider which doesn't' work with 64-bit Windows 2008. Any suggestions? -Louise Yang ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users Disclaimer: This email may contain confidential and/or privileged information. It is intended only for the person or persons to whom it is addressed. Any unauthorized review, use, or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email or telephone and destroy all copies of the original message. Please consider the environment before printing this email. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] UniOLEDB and Windows 2008/SQL 2008
I'm trying to migrate SSIS packages from Windows 2003/SQL 2005 to Windows 2008/SQL 2008 and all the packages use UniOLEDB provider which doesn't' work with 64-bit Windows 2008. Any suggestions? -Louise Yang ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UniOLEDB Connection Issues
Sorry to bother everyone, it was a 32 vs 64 bit issue. If I run
>%windir%\SysWOW64\cscript.exe connect.vbs from the command line it runs
fine and gets my recordset with IBM.UniOLEDB.1 as the Provider.
I know how to switch between wscript and cscript but if anyone knows how to
default to the SysWOW64 version, could you share? I'm just glad I can
finally get back to it since at least I can run and schedule it now!
Thanks,
Andrew
-Original Message-
From: Andrew E. Tegenkamp [mailto:and...@g3.com]
Sent: Thursday, April 22, 2010 1:15 PM
To: 'u2-users@listserver.u2ug.org'
Subject: UniOLEDB Connection Issues
I'm trying to connect to UniOLEDB and having no luck. I've created a simple
connect.vbs file on the UniVerse server but I am getting the "Provider
cannot be found. It may not be properly installed." My code is here and I
have tried both IBM.UniOLEDB.1 and Ardent.UniOLEDB for Provider.
Dim dbConn
Dim userID, pass, conStr
userID = "andrew"
pass = "password"
msgBox("Trying")
conStr = "Provider=IBM.UniOLEDB.1;Data Source=localuv;Location=HS.SALES"
SET dbConn = CreateObject("ADODB.Connection")
dbConn.Open conStr, userID, pass
msgBox("Connected")
dbConn.Close
SET dbConn = Nothing
msgBox("DONE")
I have checked the UCI Config Editor and localuv is setup as UNIVERSE;
TCP/IP; uvserver; localhost. I also can created ODBC just fine with those
settings (localuv; HS.SALES; andrew; password) so I know it can connect but
just won't go. Here is the full error prompt:
Windows Script Host
Script: C:\connect.vbs
Line: 8
Char: 1
Error: Provider cannot be found. It may not be properly installed.
Code: 800A0E7A
Source: ADODB.Connection
The command line cscript output just says the same: C:\connect.vbs(8, 1)
ADODB.Connection: Provider cannot be found. It may not be properly
installed.
Thanks for any tips/ideas,
Andrew
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] UniOLEDB Connection Issues
I'm trying to connect to UniOLEDB and having no luck. I've created a simple
connect.vbs file on the UniVerse server but I am getting the "Provider
cannot be found. It may not be properly installed." My code is here and I
have tried both IBM.UniOLEDB.1 and Ardent.UniOLEDB for Provider.
Dim dbConn
Dim userID, pass, conStr
userID = "andrew"
pass = "password"
msgBox("Trying")
conStr = "Provider=IBM.UniOLEDB.1;Data Source=localuv;Location=HS.SALES"
SET dbConn = CreateObject("ADODB.Connection")
dbConn.Open conStr, userID, pass
msgBox("Connected")
dbConn.Close
SET dbConn = Nothing
msgBox("DONE")
I have checked the UCI Config Editor and localuv is setup as UNIVERSE;
TCP/IP; uvserver; localhost. I also can created ODBC just fine with those
settings (localuv; HS.SALES; andrew; password) so I know it can connect but
just won't go. Here is the full error prompt:
Windows Script Host
Script: C:\connect.vbs
Line: 8
Char: 1
Error: Provider cannot be found. It may not be properly installed.
Code: 800A0E7A
Source: ADODB.Connection
The command line cscript output just says the same: C:\connect.vbs(8, 1)
ADODB.Connection: Provider cannot be found. It may not be properly
installed.
Thanks for any tips/ideas,
Andrew
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
RE: [U2] UniOledb error "out of memory"
No, I've run the -g as high as 512 without any effect. Noah -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Lettau, Jeff Sent: Friday, July 27, 2007 8:41 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] UniOledb error "out of memory" No I haven't. But without the -g setting, it should reserve 256 megs and I can't imagine that the oledb driver needs more then this to run. If you happen to have a system that isn't in production to play with the settings, then this may be something to try. Jeffrey Lettau ERP Systems Manager polkaudio -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Noah Hart Sent: Friday, July 27, 2007 10:43 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] UniOledb error "out of memory" Have you had any success playing with the '-g' startup parameter? Regards, Noah -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Lettau, Jeff Sent: Friday, July 27, 2007 6:43 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] UniOledb error "out of memory" I've had this exact problem. The only solution is to stop and start SQL to clear the memory. It appears to be a problem with SQL2005 wanting to hold onto the memory on the server because it feels it needs it and then the unioledb simply doesn't have enough memory available to it to run because SQL refuses to let it go. I've talked with Microsoft about this and they claim that it's not their problem because SQL is doing what it was designed to do and IBM says it's not their fault that SQL won't play nice and share some memory. If I'm wrong about any of this please feel free to correct me. And if anyone knows the answer to this problem I would love to know it. As a side note on this. We usually have this problem when testing out a new query and it isn't running as efficiently as we would like. Once it runs fast enough and is in production we haven't had any problems. Limiting the memory to SQL just appears to cause the problem faster as in using the linked server I'm guessing it's trying to load the unioledb driver into the memory space available to SQL? Or SQL just runs out of memory faster? I'm not sure what is happening, but also increasing the memory to 3 gigs also doesn't solve the problem or give more time before the error occurs. Jeffrey Lettau ERP Systems Manager polkaudio -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Noah Hart Sent: Thursday, July 26, 2007 1:28 PM To: u2-users@listserver.u2ug.org Subject: [U2] UniOledb error "out of memory" I am using unioledb (dll version 1.4.7.7137) as a linked server from SQL Server 2005. Most of the time it works just time. From time to time when there is a long running query, the select errors out with the message OLE DB provider "IBM.UniOLEDB" for linked server "The provider ran out of memory" Has anyone ever seen this before? Are there any solutions? Thanks for your help in advance, Noah Hart Sr. IT Analyst Lipman Insurance Administrators, Inc. CONFIDENTIALITY NOTICE: This message may contain confidential and/or privileged information. If you are not the addressee or authorized to receive this for the addressee, you must not use, copy, disclose, or take any action based on this message or any information herein. If you have received this message in error, please advise the sender immediately by reply e-mail and delete this message. Thank you for your cooperation. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UniOledb error "out of memory"
No I haven't. But without the -g setting, it should reserve 256 megs and I can't imagine that the oledb driver needs more then this to run. If you happen to have a system that isn't in production to play with the settings, then this may be something to try. Jeffrey Lettau ERP Systems Manager polkaudio -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Noah Hart Sent: Friday, July 27, 2007 10:43 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] UniOledb error "out of memory" Have you had any success playing with the '-g' startup parameter? Regards, Noah -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Lettau, Jeff Sent: Friday, July 27, 2007 6:43 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] UniOledb error "out of memory" I've had this exact problem. The only solution is to stop and start SQL to clear the memory. It appears to be a problem with SQL2005 wanting to hold onto the memory on the server because it feels it needs it and then the unioledb simply doesn't have enough memory available to it to run because SQL refuses to let it go. I've talked with Microsoft about this and they claim that it's not their problem because SQL is doing what it was designed to do and IBM says it's not their fault that SQL won't play nice and share some memory. If I'm wrong about any of this please feel free to correct me. And if anyone knows the answer to this problem I would love to know it. As a side note on this. We usually have this problem when testing out a new query and it isn't running as efficiently as we would like. Once it runs fast enough and is in production we haven't had any problems. Limiting the memory to SQL just appears to cause the problem faster as in using the linked server I'm guessing it's trying to load the unioledb driver into the memory space available to SQL? Or SQL just runs out of memory faster? I'm not sure what is happening, but also increasing the memory to 3 gigs also doesn't solve the problem or give more time before the error occurs. Jeffrey Lettau ERP Systems Manager polkaudio -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Noah Hart Sent: Thursday, July 26, 2007 1:28 PM To: u2-users@listserver.u2ug.org Subject: [U2] UniOledb error "out of memory" I am using unioledb (dll version 1.4.7.7137) as a linked server from SQL Server 2005. Most of the time it works just time. From time to time when there is a long running query, the select errors out with the message OLE DB provider "IBM.UniOLEDB" for linked server "The provider ran out of memory" Has anyone ever seen this before? Are there any solutions? Thanks for your help in advance, Noah Hart Sr. IT Analyst Lipman Insurance Administrators, Inc. CONFIDENTIALITY NOTICE: This message may contain confidential and/or privileged information. If you are not the addressee or authorized to receive this for the addressee, you must not use, copy, disclose, or take any action based on this message or any information herein. If you have received this message in error, please advise the sender immediately by reply e-mail and delete this message. Thank you for your cooperation. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UniOledb error "out of memory"
Have you had any success playing with the '-g' startup parameter? Regards, Noah -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Lettau, Jeff Sent: Friday, July 27, 2007 6:43 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] UniOledb error "out of memory" I've had this exact problem. The only solution is to stop and start SQL to clear the memory. It appears to be a problem with SQL2005 wanting to hold onto the memory on the server because it feels it needs it and then the unioledb simply doesn't have enough memory available to it to run because SQL refuses to let it go. I've talked with Microsoft about this and they claim that it's not their problem because SQL is doing what it was designed to do and IBM says it's not their fault that SQL won't play nice and share some memory. If I'm wrong about any of this please feel free to correct me. And if anyone knows the answer to this problem I would love to know it. As a side note on this. We usually have this problem when testing out a new query and it isn't running as efficiently as we would like. Once it runs fast enough and is in production we haven't had any problems. Limiting the memory to SQL just appears to cause the problem faster as in using the linked server I'm guessing it's trying to load the unioledb driver into the memory space available to SQL? Or SQL just runs out of memory faster? I'm not sure what is happening, but also increasing the memory to 3 gigs also doesn't solve the problem or give more time before the error occurs. Jeffrey Lettau ERP Systems Manager polkaudio -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Noah Hart Sent: Thursday, July 26, 2007 1:28 PM To: u2-users@listserver.u2ug.org Subject: [U2] UniOledb error "out of memory" I am using unioledb (dll version 1.4.7.7137) as a linked server from SQL Server 2005. Most of the time it works just time. From time to time when there is a long running query, the select errors out with the message OLE DB provider "IBM.UniOLEDB" for linked server "The provider ran out of memory" Has anyone ever seen this before? Are there any solutions? Thanks for your help in advance, Noah Hart Sr. IT Analyst Lipman Insurance Administrators, Inc. CONFIDENTIALITY NOTICE: This message may contain confidential and/or privileged information. If you are not the addressee or authorized to receive this for the addressee, you must not use, copy, disclose, or take any action based on this message or any information herein. If you have received this message in error, please advise the sender immediately by reply e-mail and delete this message. Thank you for your cooperation. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UniOledb error "out of memory"
I've had this exact problem. The only solution is to stop and start SQL to clear the memory. It appears to be a problem with SQL2005 wanting to hold onto the memory on the server because it feels it needs it and then the unioledb simply doesn't have enough memory available to it to run because SQL refuses to let it go. I've talked with Microsoft about this and they claim that it's not their problem because SQL is doing what it was designed to do and IBM says it's not their fault that SQL won't play nice and share some memory. If I'm wrong about any of this please feel free to correct me. And if anyone knows the answer to this problem I would love to know it. As a side note on this. We usually have this problem when testing out a new query and it isn't running as efficiently as we would like. Once it runs fast enough and is in production we haven't had any problems. Limiting the memory to SQL just appears to cause the problem faster as in using the linked server I'm guessing it's trying to load the unioledb driver into the memory space available to SQL? Or SQL just runs out of memory faster? I'm not sure what is happening, but also increasing the memory to 3 gigs also doesn't solve the problem or give more time before the error occurs. Jeffrey Lettau ERP Systems Manager polkaudio -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Noah Hart Sent: Thursday, July 26, 2007 1:28 PM To: u2-users@listserver.u2ug.org Subject: [U2] UniOledb error "out of memory" I am using unioledb (dll version 1.4.7.7137) as a linked server from SQL Server 2005. Most of the time it works just time. From time to time when there is a long running query, the select errors out with the message OLE DB provider "IBM.UniOLEDB" for linked server "The provider ran out of memory" Has anyone ever seen this before? Are there any solutions? Thanks for your help in advance, Noah Hart Sr. IT Analyst Lipman Insurance Administrators, Inc. CONFIDENTIALITY NOTICE: This message may contain confidential and/or privileged information. If you are not the addressee or authorized to receive this for the addressee, you must not use, copy, disclose, or take any action based on this message or any information herein. If you have received this message in error, please advise the sender immediately by reply e-mail and delete this message. Thank you for your cooperation. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] UniOledb error "out of memory"
I am using unioledb (dll version 1.4.7.7137) as a linked server from SQL Server 2005. Most of the time it works just time. From time to time when there is a long running query, the select errors out with the message OLE DB provider "IBM.UniOLEDB" for linked server "The provider ran out of memory" Has anyone ever seen this before? Are there any solutions? Thanks for your help in advance, Noah Hart Sr. IT Analyst Lipman Insurance Administrators, Inc. CONFIDENTIALITY NOTICE: This message may contain confidential and/or privileged information. If you are not the addressee or authorized to receive this for the addressee, you must not use, copy, disclose, or take any action based on this message or any information herein. If you have received this message in error, please advise the sender immediately by reply e-mail and delete this message. Thank you for your cooperation. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UniOLEDB hangs
Hi Brain,
I have setup uci.config and ud_database in Unidata. VSG is working fine,
but when it goes to web asp page, it hangs. I am using the asp example
that provide in Using UNIOLEDB menu. I was able to connect a few time
but not all the time. Can you setup multiply db in ud_database? I am
thinking that I missed something for this ADODB connection test.
DATABASE=cconv
UDTHOME=/usr/ud51
UDTACCT=/datatel/live/collive
TRACE_LEVEL=3
DATABASE=cconvsql
UDTHOME=/usr/ud51
UDTACCT=/datatel/work/cconvsql
TRACE_LEVEL=3
I am testing this on IIS 5.1
Best regards,
Cody Wang
Datatel Programmer Analyst
Ohio Dominican University
1-614-251-4799
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Brian Leach
Sent: Tuesday, November 28, 2006 10:13 AM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] UniOLEDB hangs
Hi
You might want to look at an article entitled "How to Access U2 Data
using
ODBC and OleDB" in the U2UG Knowledge Base (www.mvopen.org/kb). It is a
primer and may help.
Regards,
Brian
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Wang, Cody
> Sent: 28 November 2006 12:40
> To: u2-users@listserver.u2ug.org
> Subject: RE: [U2] UniOLEDB hangs
>
> Hi Bill,
>
> I am little confused about how to create another data source.
> Can you give me more detail about it? Do we create another
> data source by using MS data source application or uni.config
> configure editor. Where do you choose shared data source?
>
> Subject: RE: [U2] OLEDB connection string
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
<%@ Language=VBScript %>
<% ' VI 6.0 Scripting Object Model Enabled %>
<% if StartPageProcessing() Then Response.End() %>
function do_test()
{
// read form fields
var location1 = Request.Form("location");
var datasource1 = Request.Form("datasource");
var username1 = Request.Form("username");
var password1 = Request.Form("password");
var sql1 = Request.Form("sql");
// write back form fields to response page.
Response.Write("INPUTS:<BR><BR>");
Response.Write("Location:" + location1 + "<BR>");
Response.Write("Data source:" + datasource1 + "<BR>");
Response.Write("Username:" + username1 + "<BR>");
Response.Write("Attempting connection...<BR>");
// create a connection using UniOLEDB Provider
var Conn = Server.CreateObject("ADODB.Connection");
Conn.Provider = "IBM.UniOLEDB.1";
var ConStr = "DATA SOURCE="+datasource1+";LOCATION="+location1+";USER
ID="+username1+";PASSWORD="+password1+";";
//var ConStr = "DATA SOURCE="+datasource1+"LOCATION="+location1+"USER
ID="+username1+"PASSWORD="+password1+";";
Conn.Open(ConStr);
Response.Write("Connect OK<BR>");
Response.Write("Executing SQL...<BR>");
// execute SQL Statement
var RecordsAffected = 0;
var Rs = Conn.Execute(sql1);
// write field names to response page
for(i = 0; i < Rs.Fields.Count; ++i)
{
Response.Write(Rs.Fields(i).Name);
Response.Write(" ");
}
Response.Write("<BR>");
// write data to response page
while(!Rs.eof)
{
for(i = 0; i < Rs.Fields.Count; ++i)
{
Response.Write(Rs.Fields(i).Value);
Response.Write(" ");
}
Response.Write("<BR>");
Rs.MoveNext();
}
// Close record set
Rs.Close();
// Close connection
Conn.Close();
Response.Write("DisConnect OK<BR>");
}
do_test();
<% ' VI 6.0 Scripting Object Model Enabled %>
<% EndPageProcessing() %>
/*
HTML code below displays a form that collects connection data
from user. When user hits the button, the asp page
"test1_do.asp" is executed to generate a results page from
the query.
*/
// FILE: test1.asp
<%@ Language=VBScript %>
SQL Execute
Location:
Data Source:
User Name:
Password:
SQL:
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UniOLEDB hangs
Hi You might want to look at an article entitled "How to Access U2 Data using ODBC and OleDB" in the U2UG Knowledge Base (www.mvopen.org/kb). It is a primer and may help. Regards, Brian > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Wang, Cody > Sent: 28 November 2006 12:40 > To: u2-users@listserver.u2ug.org > Subject: RE: [U2] UniOLEDB hangs > > Hi Bill, > > I am little confused about how to create another data source. > Can you give me more detail about it? Do we create another > data source by using MS data source application or uni.config > configure editor. Where do you choose shared data source? > > Subject: RE: [U2] OLEDB connection string --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UniOLEDB hangs
Hi Bill, I am little confused about how to create another data source. Can you give me more detail about it? Do we create another data source by using MS data source application or uni.config configure editor. Where do you choose shared data source? Subject: RE: [U2] OLEDB connection string Nick: I created a new datasource as follows: Shared Data Source: Name--: UDOleDBReports Type--: OLE DB Connection string: Provider=IBM.UniOLEDB.1;Data Source=asidevud Connection Properties (via the [Edit] button in above dialog): Data Source: OLE DB (OLE DB) OLE DB Provider: UniOLEDB Provider Enter a server or file name: Server of file name: asidevud (in the uci.config item) Location---: leave blank (this messed me up for awhile) Log on to the server: Use a specific user name and password User name: valid Windows/UniData user (also in UniAdmin > Network Service > UDTelnet Server > Users) Password-: valid Windows password for above user Allow saving password The connection string looks like: Provider=IBM.UniOLEDB.1;Data Source=asidevud;Persist Security Info=True;User ID=DataTrustNET I used the UCI Configurator to create the OleDB section. Although the tool seems to indicate this is only an ODBC tool the OleDB documentation, without mentioning it, assumed ODBC and OleDB sections are exactly the same. Hope this helps. :-) Best regards, Cody Wang Datatel Programmer Analyst Ohio Dominican University 1-614-251-4799 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bill Haskett Sent: Monday, November 27, 2006 3:13 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] UniOLEDB hangs Cody: See if the following thread helps. http://www.nabble.com/OLEDB-connection-string-tf1838501.html#a5019034 Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Wang, Cody Sent: Monday, November 27, 2006 10:43 AM To: u2-users@listserver.u2ug.org Subject: [U2] UniOLEDB hangs Hi, I wonder anyone uses UniOLEDB and experience hangs on connection string part. Best regards, Cody Wang Datatel Programmer Analyst Ohio Dominican University 1-614-251-4799 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UniOLEDB hangs
Cody: See if the following thread helps. http://www.nabble.com/OLEDB-connection-string-tf1838501.html#a5019034 Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Wang, Cody Sent: Monday, November 27, 2006 10:43 AM To: u2-users@listserver.u2ug.org Subject: [U2] UniOLEDB hangs Hi, I wonder anyone uses UniOLEDB and experience hangs on connection string part. Best regards, Cody Wang Datatel Programmer Analyst Ohio Dominican University 1-614-251-4799 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] UniOLEDB hangs
Hi, I wonder anyone uses UniOLEDB and experience hangs on connection string part. Best regards, Cody Wang Datatel Programmer Analyst Ohio Dominican University 1-614-251-4799 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Stu Glancy Sent: Monday, November 27, 2006 10:54 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UV] Phantom Limits I was under the impression that the number of phantoms is limited to the licensed number of users less the number of users on the system. In other words, each phantom used a license. Am I out incorrect? Tom Dodds <[EMAIL PROTECTED]> wrote: In my experience, which is at UV 10.0.x some years back, the limit is not system wide, but was imposed at the host process level. The limit I found was 50 phantoms per host process so if you needed to have more than 50 phantoms running you needed to start multiple host process to spawn a set number of processes. I was never able to find a tunable parameter to modify the limit. Tom Dodds [EMAIL PROTECTED] 708-234-9608 Office 630-235-2975 Cell -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Peter Veenhof Sent: Thursday, November 23, 2006 1:56 PM To: u2-users@listserver.u2ug.org Subject: [U2] [UV] Phantom Limits Hi, I'm just reading up on phantoms, and saw this little note in the HELP... There is a system-wide limit on the number of processes that you can initiate. If you can start no more processes when you issue a PHANTOM command, the following message appears: NO FREE PHANTOMS You cannot run a phantom process now. Wait a while, then try again. I was wondering if anyone knows off the top of their head, what determines this limit? Is it a static number, if so what, or is it user definable? Thanks Peter --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ - Everyone is raving about the all-new Yahoo! Mail beta. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] UniOLEDB hangs
Hi all, We are trying test connection between PC/server and Unidata that we did not get too much luck for our CAS deployment. I have been used the asp page that provided in UNIOLEDB menu. Sometimes works on my PC but not all the time but not on others, if it is failed, the connection hangs there forever. I use IIS test. I just wonder that does anyone use UNIOLEDB before. The oledb provider testing program shows test successfully every time. Thanks Cody Wang Ohio Dominican University 614-251-4799 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] UNIOLEDB sample code error
Hi all, I wonder can anyone share a ASP sample code for connnecting to database. I tried to use teh sample code in Unioledb but got some error message. The first is pm.asp and the 2nd one is <<% ' VI 6.0 Scripting Object Model Enabled %> that I tool out. Now I have /var ConStr = "DATA SOURCE="+datasource1+"; issue taht I could not figure out. I believe I use the right database source name which I define in uci.config Thanks --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UNiOLEDB [ad+info]
See this posting I recently made to CDP on the topic. Then look down two posts to where I provide more detail about the issues and solution. http://tinyurl.com/av4jj When OLEDB does work, I can't tell you how it works with ADO.NET - I'm curious to hear more about this as well. mv.NET uses a fetch mode so that data is passed from server to client only as needed, effectively providing the data pooling that you ask about. This is different from connection pooling which is very helpful in maximizing use of DBMS licenses - mv.NET supports connection pooling where UO and ODBC/OLEDB do not. mv.NET also fully supports the standard ADO.NET Command functions Select, Insert, Update, and Delete. It can stack multiple commands for any operation. It can use BASIC programs as StoredProcedures to perform Command functions. And it can perform dynamic normalization using extended Dict definitions. But one doesn't need to use the Adapter library to populate ADO.NET DataSets - this can also be done using the BASIC-like syntax of the Core Objects library. For those who want to use ADO.NET to bind data to form controls, mv.NET includes a separate Binding Objects library, which provides a properly formatted DataSource for controls without ADO.NET and without manual coding. When developers are considering the tools they want to use, product support is very important. The support for mv.NET is phenomenal. Responses are quick and some fixes are made and delivered immediately. This is far better than some other products which are fairly static or take months between patches. We were unable to get a fix for ODBC/OLEDB issues from IBM, but we do get fast fixes and enhancements for mv.NET when required. I don't like mv.NET because I sell it. Of all of the products available in our market, I sell it because I like it. In brief response to Glenn Batson: It's my understanding that UO.NET is a managed wrapper around UO, but UO itself is of course unmanaged by the CLR. Errors returned from UO.NET clearly show calls to P/Invoke and UO under the covers. That's not a problem, and mv.NET can use UO as the data conduit as well, but it's important to note that just because there is UO and UO.NET doesn't mean the .NET version is fully managed code. HTH Tony TG@ removethisNebula-RnD.com Nebula R&D is an authorized Distributor for mv.NET http:// removethisNebula-RnD.com/products/mvdotnet/mvdotnet.htm Stuart.Boydell wrote: > I'm wondering what peoples experience of using UniOLEDB is. > General impressions, is it reliable? Does it run in > unmanaged code? How about the CALL interface, does it > work okay from the .NET framework? Does the standard > ADO.NET pooling work okay with it? Are there any gotchas > that have come up? --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UNiOLEDB
Stuart Boydell wrote, " I'm wondering what peoples experience of using UniOLEDB is.". Here is our experience. Our environment experience has been on version 6 of UniData on Windows 2003. 1) Our engineer's had a heck of a time getting the right connection string to work. It has been such a long time back that I don't remember what the problems seemed to revolve around. Once it started we moved on. 2) We used it for an ASP.NET application. I'm not a .NET engineer but since it is a COM DLL I'm certain there was COMInterop involved. Since it was COM then yes it ran in unmanaged code. We were able to implement C# code that called interfaced with the DLL and ran as a Windows service, getting its request from a MSMQ queue. We did not use ADO.NET pooling. I would have to query and engineer on why, but my guess is it does not fit. 3) The real issue is it uses the UniData SQL engine, which did not perform to our expectations. Additionally we implemented our own connection pooling by using window services and MSMQ queues, but we were told this is not how it is intended to be used. It is intended more for a client server implementation. Either as a result of our implementation or the UniOLEDB implementation, we seemed to have issues with timeouts that fully could not be explained. The overhead of using VSG to define the SQL Schema and setting up uci.config and ud_database was not appealing. 4) Note we only used it for querying data and not updates. We have a lot of business logic tied up in UniBasic and SB+ therefore we have to use UniObjects (and RedBack in the past) to call subroutines. So you end up having more database connections than you would like. 5) Our impression has always been that having UniData on Unix on the backend will perform better and be more stable. Our problem is the majority of our market will not support Unix deployments whether on principal or practice. We are running this environment in production though and it is workable just too many issues. Therefore we are moving away from it and using UniObjects.NET and UniData 7.1. We are switching all our SQL statements over to UniQuery statements that generate data to XML. So for most of the simply queries with string data have worked within the MS dataset. We are using XSLT to for the others. One reason is to get in an environment IBM supports and that is not a COM implementation. Additionally IBM says that native access is always faster (native being subroutines and uniquery). If you have questions you can contact me directly. Also though I have not had any experience with it you may want to look at MV.net. Glenn Batson 360.256.4400 www.jenkon.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] UNiOLEDB
I'm wondering what peoples experience of using UniOLEDB is. General impressions, is it reliable? Does it run in unmanaged code? How about the CALL interface, does it work okay from the .NET framework? Does the standard ADO.NET pooling work okay with it? Are there any gotchas that have come up? Thanks, -- Stuart Boydell [EMAIL PROTECTED] ** This email message and any files transmitted with it are confidential and intended solely for the use of addressed recipient(s). If you have received this email in error please notify the Spotless IS Support Centre (+61 3 9269 7555) immediately, who will advise further action. This footnote also confirms that this email message has been scanned for the presence of computer related viruses. ** --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UniOleDB - Delphi
Claus,
If you have set up your config file correctly (looks ok, did you use the
horrible UCI Config editor to make sure it is saved in the right place ?)
your connection string should just read:
"Provider=IBM.UniOLEDB.1;Persist Security Info=False;Data
Source=TESTFAMIS;Password={your_password_here}"
To test this outside of Delphi, try the following bit of VBScript
(open notepad, paste in and save as test.vbs. That extension should be
associated with WSCRIPT.EXE ...)
Dim dbConn
Dim dbCmd
Dim dbRS
Set dbConn = CreateObject("ADODB.Connection")
dbConn.ConnectionString="Provider=IBM.UniOLEDB.1;Persist Security
Info=False;Data Source=TESTFAMIS;Password={your_password_here}"
dbConn.Open
Set dbCmd = CreateObject("ADODB.Command")
Set dbCmd.ActiveConnection = dbConn
dbCmd.CommandText = "SELECT * FROM {your_test_table_here}"
Set dbRS = dbCmd.Execute
dbRS.MoveFirst
Msgbox dbRS.Fields(1)
Not the best VBScript in the world but it should fall over quickly if there
are errors
Brian
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
[U2] UniOleDB - Delphi
Hi, I'm trying to make a connection from Delphi with UniOleDB to our UniVerse database, but i am stucked with not being able to connect.. Here is what i have done : 1) Via HS.ADMIN as root made the account visible to UniOleDB, also ran HS.SCRUB on a few files so i had something to work with, no problems 2) UniDK kit was already installed, so i edited the uci.config file so now it looks like this : [ODBC DATA SOURCES] DBMSTYPE = UNIVERSE account = /data1/FAMIS host = 10.9.200.20 network = TCP/IP service = uvserver username = CD I have removed the section with UniData as we only run UniVerse the above section 'TESTFAMIS' is build by following the 'Using UniOLEDB' manual 3. Next i made a DELPHI6 project with an empty form and dropped an ADO connection component using the connection string builder i made this conn. string : Provider=IBM.UniOLEDB.1;Persist Security Info=False;User ID=CD; Data Source=TESTFAMIS;Location=FAMIS;Mode=ReadWrite No matter what i have tried i get the same error string in return when trying to connect : Died UCI::SQLConnect() with SQLSTATE IM976, Native error:0 [IBM][SQL CLient]UCI connections to non UniVerse databases is not allowed.. I guess there is a bond between the uci.config file and the connection string, but i havent figured it out yet. Can anyone show me the right path ? best regards from Denmark Claus Derlien Frie Funktionfrer - faglig organisation og tvfrfaglig a-kasse - www.f-f.dk *** Denne email og alle filer vedlagt som bilag kan indeholde fortroligt materiale, der kun er beregnet for adressaten, og maa ikke udleveres eller kopieres til uvedkommende. Har De ved en fejltagelse modtaget denne email, bedes De venligst omgaaende meddele os dette pr. telefon : 6313 8550. Paa forhaand tak. *** This email and any files transmitted with it may contain confidential information intended for the addressee(s) only. The information is not to be surrendered or copied to unauthorised persons. If you have received this communication in error, please notify us immediately by telephone: +45 6313 8550. Thank you. *** --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] unioledb connection from SQL2000
First off. Thanks for the response. Next. We figured it out. We used an updated driver from our version 6.03??? Unidata disk instead of the 5.2??? Version that was on the old server. I think the numbers of the actual driver are not that different. But to make a long post shorter I'll just say the answer to the question is formatting. The date needs to be "2005-06-27" not "06-27-05" Why? I don't know. And do I care? Not all that much now that it works. So the secret word of the day is International date format. So It's 3 words. So sue me. I'll return to lurking again. Thanks. Jeffrey Lettau ERP Systems Manager polkaudio -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Noah Hart Sent: Thursday, August 25, 2005 2:21 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] unioledb connection from SQL2000 What version Unidata and Client tools (especially ODBC driver) are you using? Noah -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Lettau, Jeff Sent: Thursday, August 25, 2005 8:25 AM To: u2-users@listserver.u2ug.org Subject: [U2] unioledb connection from SQL2000 We moved our SQL2000 database to a windows2003 server. Now when I try to do a query against my Unidata database it fails to return any rows. But only on this query. Select ID,Inv_So_Date,Sales,Record_Type,Ord_Class,Order_Type_Desc from DailySales WHERE Inv_So_Date >= "06-27-05" AND Inv_So_Date <= "09-25-05"; If I take the date selection out of my query, it runs fine. I get about 2 million rows and it takes 20 minutes but it runs. I won't say all the queries work, but I can say that most do work without issues. Including the Linked server to Unidata works. But just not this oledb connection with parameters in a DTS package. Is there some trick to get this to work. Jeffrey Lettau ERP Systems Manager polkaudio --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] unioledb connection from SQL2000
Up here, in the Great White North, we have to watch the regional settings. Sometimes using a different date format causes problems - whether it's the order or the delimiter. It seems to be a problem with your dates - so this is where I would start... Colin Alfke Calgary, AB >-Original Message- >From: Lettau, Jeff > >We moved our SQL2000 database to a windows2003 server. Now >when I try to do a query against my Unidata database it fails >to return any rows. >But only on this query. >Select >ID,Inv_So_Date,Sales,Record_Type,Ord_Class,Order_Type_Desc >from DailySales WHERE Inv_So_Date >= "06-27-05" AND >Inv_So_Date <= "09-25-05"; If I take the date selection out of >my query, it runs fine. I get about >2 million rows and it takes 20 minutes but it runs. >I won't say all the queries work, but I can say that most do >work without issues. Including the Linked server to Unidata >works. But just not this oledb connection with parameters in >a DTS package. Is there some trick to get this to work. > > >Jeffrey Lettau --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] unioledb connection from SQL2000
What version Unidata and Client tools (especially ODBC driver) are you using? Noah -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Lettau, Jeff Sent: Thursday, August 25, 2005 8:25 AM To: u2-users@listserver.u2ug.org Subject: [U2] unioledb connection from SQL2000 We moved our SQL2000 database to a windows2003 server. Now when I try to do a query against my Unidata database it fails to return any rows. But only on this query. Select ID,Inv_So_Date,Sales,Record_Type,Ord_Class,Order_Type_Desc from DailySales WHERE Inv_So_Date >= "06-27-05" AND Inv_So_Date <= "09-25-05"; If I take the date selection out of my query, it runs fine. I get about 2 million rows and it takes 20 minutes but it runs. I won't say all the queries work, but I can say that most do work without issues. Including the Linked server to Unidata works. But just not this oledb connection with parameters in a DTS package. Is there some trick to get this to work. Jeffrey Lettau ERP Systems Manager polkaudio --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] unioledb connection from SQL2000
We moved our SQL2000 database to a windows2003 server. Now when I try to do a query against my Unidata database it fails to return any rows. But only on this query. Select ID,Inv_So_Date,Sales,Record_Type,Ord_Class,Order_Type_Desc from DailySales WHERE Inv_So_Date >= "06-27-05" AND Inv_So_Date <= "09-25-05"; If I take the date selection out of my query, it runs fine. I get about 2 million rows and it takes 20 minutes but it runs. I won't say all the queries work, but I can say that most do work without issues. Including the Linked server to Unidata works. But just not this oledb connection with parameters in a DTS package. Is there some trick to get this to work. Jeffrey Lettau ERP Systems Manager polkaudio --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] UniOLEDB version issue?
Hello everyone, We are running an old version of Universe. We have an issue with an oledb driver on our windows 2000 IIS web server. We use this same driver on our test nt4 IIS server without any problem, but when we use the asp code and driver on the w2k box the call never returns. When we check the event log on the w2k box we see an error: Out of process application '/LM/W3SVC/3/Root' terminated unexpectedly. Sometimes we get an error that says: The server failed to load application '/LM/W3SVC/3/Root'. The error was '8007053d'. Our version of Universe is 9.5.2.1 Our UniOLEDB is 1.0. Has anyone come across this before, or heard of an issue with older versions of UniOLEDB and W2K? If so, can I just get an updated copy of the UniOLEDB driver somewhere? Thanks for your time. rwier --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UniOleDB Configuration
I use the tools from http://gpoulose.home.att.net/ to test the ODBC and OLEDB connections. I've had problems in the past with access and excel. One would work when the other wouldn't. It seemed to be something specific on my PC Cisar, are you sure you have the OLEDB drivers installed? I've found that once I get ODBC working the OLEDB follows along. hth -- Colin Alfke Calgary, Alberta Canada "Just because something isn't broken doesn't mean that you can't fix it" Stu Pickles >-Original Message- >From: Bryan Haglund [mailto:[EMAIL PROTECTED] >Sent: Friday, May 21, 2004 7:44 AM >To: [EMAIL PROTECTED] >Subject: Re: [U2] UniOleDB Configuration > > >Cisar, > >Can you test your OLE DB connection using Excel, Access or >Crystal Reports? >You should not have a problem with the default configuration. >It sounds >like something else is going on here. If it still doesn't work after >building the connection string, inserting user/pw, etc. as >required, then >there's a problem here that's a little deeper than the >specific connection >string being used. > >Bryan Haglund >Haglund Consulting Inc. --- u2-users mailing list [EMAIL PROTECTED] http://www.u2ug.org/listinfo/u2-users
Re: [U2] UniOleDB Configuration
Cisar, Can you test your OLE DB connection using Excel, Access or Crystal Reports? You should not have a problem with the default configuration. It sounds like something else is going on here. If it still doesn't work after building the connection string, inserting user/pw, etc. as required, then there's a problem here that's a little deeper than the specific connection string being used. Bryan Haglund Haglund Consulting Inc. - Original Message - From: "Cesar Riba" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, May 20, 2004 11:44 PM Subject: RE: [U2] UniOleDB Configuration > Bryan, > > Than you for your help, but the problem is the same, the error ODB930077 is > always then same. Can are that in the account need another special > configuration. My account is a valid schema, with ODBC I don't have > problems. > > > Tanks. > > Cisar. > > > -Mensaje original- > De: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] nombre de Bryan Haglund > Enviado el: viernes, 21 de mayo de 2004 5:30 > Para: [EMAIL PROTECTED] > Asunto: Re: [U2] UniOleDB Configuration > > > Cesar, > > Ok, let's try this from another angle. Go back to the original OLE DB > configuration under localuv: > > DBMSTYPEUNIVERSE > networkTCP/IP > serviceuvserver > hostlocalhost > > Start with that, and change the host to the actual host, and test with that. > That connection should work without a problem, just needing to be tuned to > your specific needs. Then add one single configuration option at a time, > and test until you identify the failure. > > You guys at IBM that read these posts can feel free to step in at anytime to > provide some sort of reasonable documentation/insight on UniOLEDB > configuration(s). > > Bryan > > - Original Message - > From: "Cesar Riba" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Tuesday, May 18, 2004 9:25 AM > Subject: RE: [U2] UniOleDB Configuration > > > > Hello Bryan > > > > I changed de name of Account in the uci.file of "E:\CUENTAS\COMERCIAL" to > > "COMERCIAL" and the error is the same. > > > > Tanks. > > > > Cisar. > > > > -Mensaje original- > > De: [EMAIL PROTECTED] > > [mailto:[EMAIL PROTECTED] nombre de Bryan Haglund > > Enviado el: martes, 18 de mayo de 2004 16:36 > > Para: [EMAIL PROTECTED] > > Asunto: Re: [U2] UniOleDB Configuration > > > > > > Cesar, > > > > Is the account name 'COMERCIAL' ? If so, that's what it needs to be in > the > > UCI Config Editor, and not the explicit pathname for the account. > > > > Bryan > > > > - Original Message - > > From: "Cesar Riba" <[EMAIL PROTECTED]> > > To: <[EMAIL PROTECTED]> > > Sent: Sunday, May 16, 2004 11:26 PM > > Subject: RE: [U2] UniOleDB Configuration > > > > > > > Bryan > > > > > > In the file UV.ACCOUNTS the format of account is "E:\CUENTAS\COMERCIAL", > > > but I change the parameter of account in the uci.config file in my > > computer > > > and the problem is the same. > > > > > > Tanks. > > > > > > -Mensaje original- > > > De: [EMAIL PROTECTED] > > > [mailto:[EMAIL PROTECTED] nombre de Bryan Haglund > > > Enviado el: viernes, 14 de mayo de 2004 19:05 > > > Para: [EMAIL PROTECTED] > > > Asunto: Re: [U2] UniOleDB Configuration > > > > > > > > > Cesar, > > > > > > The account name format is incorrect. It needs to be the actual > UniVerse > > > account name as defined in UV.ACCOUNTS. > > > > > > Bryan Haglund > > > Haglund Consulting Inc. > > > > > > - Original Message - > > > From: "Cesar Riba" <[EMAIL PROTECTED]> > > > To: <[EMAIL PROTECTED]> > > > Sent: Friday, May 14, 2004 9:39 AM > > > Subject: RE: [U2] UniOleDB Configuration > > > > > > > > > > Hello > > > > Tanks for your respons. > > > > > > > > After of have the changes the error is another, this is the change > that > > I > > > > have been in uci.config of my computer. > > > > > > > > > > > > DBMSTYPE = UNIVERSE > > > > HOST = 10.0.0.3 > > > > ACCOUNT = \\DELL\CUENTAS\COMERCIAL > > > > USERNAME = CESAR > > > > MAXFETCHBUFF = 2 > > > > MAXFETCHCOLS = 800 > >
RE: [U2] UniOleDB Configuration
Bryan, Than you for your help, but the problem is the same, the error ODB930077 is always then same. Can are that in the account need another special configuration. My account is a valid schema, with ODBC I don't have problems. Tanks. Cisar. -Mensaje original- De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] nombre de Bryan Haglund Enviado el: viernes, 21 de mayo de 2004 5:30 Para: [EMAIL PROTECTED] Asunto: Re: [U2] UniOleDB Configuration Cesar, Ok, let's try this from another angle. Go back to the original OLE DB configuration under localuv: DBMSTYPEUNIVERSE networkTCP/IP serviceuvserver hostlocalhost Start with that, and change the host to the actual host, and test with that. That connection should work without a problem, just needing to be tuned to your specific needs. Then add one single configuration option at a time, and test until you identify the failure. You guys at IBM that read these posts can feel free to step in at anytime to provide some sort of reasonable documentation/insight on UniOLEDB configuration(s). Bryan - Original Message - From: "Cesar Riba" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, May 18, 2004 9:25 AM Subject: RE: [U2] UniOleDB Configuration > Hello Bryan > > I changed de name of Account in the uci.file of "E:\CUENTAS\COMERCIAL" to > "COMERCIAL" and the error is the same. > > Tanks. > > Cisar. > > -Mensaje original- > De: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] nombre de Bryan Haglund > Enviado el: martes, 18 de mayo de 2004 16:36 > Para: [EMAIL PROTECTED] > Asunto: Re: [U2] UniOleDB Configuration > > > Cesar, > > Is the account name 'COMERCIAL' ? If so, that's what it needs to be in the > UCI Config Editor, and not the explicit pathname for the account. > > Bryan > > - Original Message - > From: "Cesar Riba" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Sunday, May 16, 2004 11:26 PM > Subject: RE: [U2] UniOleDB Configuration > > > > Bryan > > > > In the file UV.ACCOUNTS the format of account is "E:\CUENTAS\COMERCIAL", > > but I change the parameter of account in the uci.config file in my > computer > > and the problem is the same. > > > > Tanks. > > > > -Mensaje original- > > De: [EMAIL PROTECTED] > > [mailto:[EMAIL PROTECTED] nombre de Bryan Haglund > > Enviado el: viernes, 14 de mayo de 2004 19:05 > > Para: [EMAIL PROTECTED] > > Asunto: Re: [U2] UniOleDB Configuration > > > > > > Cesar, > > > > The account name format is incorrect. It needs to be the actual UniVerse > > account name as defined in UV.ACCOUNTS. > > > > Bryan Haglund > > Haglund Consulting Inc. > > > > - Original Message - > > From: "Cesar Riba" <[EMAIL PROTECTED]> > > To: <[EMAIL PROTECTED]> > > Sent: Friday, May 14, 2004 9:39 AM > > Subject: RE: [U2] UniOleDB Configuration > > > > > > > Hello > > > Tanks for your respons. > > > > > > After of have the changes the error is another, this is the change that > I > > > have been in uci.config of my computer. > > > > > > > > > DBMSTYPE = UNIVERSE > > > HOST = 10.0.0.3 > > > ACCOUNT = \\DELL\CUENTAS\COMERCIAL > > > USERNAME = CESAR > > > MAXFETCHBUFF = 2 > > > MAXFETCHCOLS = 800 > > > NETWORK = TCP/IP > > > SERVICE = uvserver > > > > > > > > > And the error that I recibe is: > > > Died in UCI::SQLConnect() with SQLSTATE IM976, Native error:0 > > > [Informix][SQL Client]An illegal configuration option was found. > > > > > > The string connection of Visual Basic is: > > > > > > Provider = "Informix.UniOLEDB" > > > DataSource = "vaquer" > > > Location = "\\DELL\CUENTAS\COMERCIAL" > > > User = "CESAR" > > > Password = "" > > > > > > Tanks > > > > > > Cesar > > > --- > > > u2-users mailing list > > > [EMAIL PROTECTED] > > > http://www.u2ug.org/listinfo/u2-users > > --- > > u2-users mailing list > > [EMAIL PROTECTED] > > http://www.u2ug.org/listinfo/u2-users > > --- > > u2-users mailing list > > [EMAIL PROTECTED] > > http://www.u2ug.org/listinfo/u2-users > --- > u2-users mailing list > [EMAIL PROTECTED] > http://www.u2ug.org/listinfo/u2-users > --- > u2-users mailing list > [EMAIL PROTECTED] > http://www.u2ug.org/listinfo/u2-users --- u2-users mailing list [EMAIL PROTECTED] http://www.u2ug.org/listinfo/u2-users --- u2-users mailing list [EMAIL PROTECTED] http://www.u2ug.org/listinfo/u2-users
Re: [U2] UniOleDB Configuration
Cesar, Ok, let's try this from another angle. Go back to the original OLE DB configuration under localuv: DBMSTYPEUNIVERSE networkTCP/IP serviceuvserver hostlocalhost Start with that, and change the host to the actual host, and test with that. That connection should work without a problem, just needing to be tuned to your specific needs. Then add one single configuration option at a time, and test until you identify the failure. You guys at IBM that read these posts can feel free to step in at anytime to provide some sort of reasonable documentation/insight on UniOLEDB configuration(s). Bryan - Original Message - From: "Cesar Riba" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, May 18, 2004 9:25 AM Subject: RE: [U2] UniOleDB Configuration > Hello Bryan > > I changed de name of Account in the uci.file of "E:\CUENTAS\COMERCIAL" to > "COMERCIAL" and the error is the same. > > Tanks. > > Cisar. > > -Mensaje original- > De: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] nombre de Bryan Haglund > Enviado el: martes, 18 de mayo de 2004 16:36 > Para: [EMAIL PROTECTED] > Asunto: Re: [U2] UniOleDB Configuration > > > Cesar, > > Is the account name 'COMERCIAL' ? If so, that's what it needs to be in the > UCI Config Editor, and not the explicit pathname for the account. > > Bryan > > - Original Message ----- > From: "Cesar Riba" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Sunday, May 16, 2004 11:26 PM > Subject: RE: [U2] UniOleDB Configuration > > > > Bryan > > > > In the file UV.ACCOUNTS the format of account is "E:\CUENTAS\COMERCIAL", > > but I change the parameter of account in the uci.config file in my > computer > > and the problem is the same. > > > > Tanks. > > > > -Mensaje original- > > De: [EMAIL PROTECTED] > > [mailto:[EMAIL PROTECTED] nombre de Bryan Haglund > > Enviado el: viernes, 14 de mayo de 2004 19:05 > > Para: [EMAIL PROTECTED] > > Asunto: Re: [U2] UniOleDB Configuration > > > > > > Cesar, > > > > The account name format is incorrect. It needs to be the actual UniVerse > > account name as defined in UV.ACCOUNTS. > > > > Bryan Haglund > > Haglund Consulting Inc. > > > > - Original Message - > > From: "Cesar Riba" <[EMAIL PROTECTED]> > > To: <[EMAIL PROTECTED]> > > Sent: Friday, May 14, 2004 9:39 AM > > Subject: RE: [U2] UniOleDB Configuration > > > > > > > Hello > > > Tanks for your respons. > > > > > > After of have the changes the error is another, this is the change that > I > > > have been in uci.config of my computer. > > > > > > > > > DBMSTYPE = UNIVERSE > > > HOST = 10.0.0.3 > > > ACCOUNT = \\DELL\CUENTAS\COMERCIAL > > > USERNAME = CESAR > > > MAXFETCHBUFF = 2 > > > MAXFETCHCOLS = 800 > > > NETWORK = TCP/IP > > > SERVICE = uvserver > > > > > > > > > And the error that I recibe is: > > > Died in UCI::SQLConnect() with SQLSTATE IM976, Native error:0 > > > [Informix][SQL Client]An illegal configuration option was found. > > > > > > The string connection of Visual Basic is: > > > > > > Provider = "Informix.UniOLEDB" > > > DataSource = "vaquer" > > > Location = "\\DELL\CUENTAS\COMERCIAL" > > > User = "CESAR" > > > Password = "" > > > > > > Tanks > > > > > > Cesar > > > --- > > > u2-users mailing list > > > [EMAIL PROTECTED] > > > http://www.u2ug.org/listinfo/u2-users > > --- > > u2-users mailing list > > [EMAIL PROTECTED] > > http://www.u2ug.org/listinfo/u2-users > > --- > > u2-users mailing list > > [EMAIL PROTECTED] > > http://www.u2ug.org/listinfo/u2-users > --- > u2-users mailing list > [EMAIL PROTECTED] > http://www.u2ug.org/listinfo/u2-users > --- > u2-users mailing list > [EMAIL PROTECTED] > http://www.u2ug.org/listinfo/u2-users --- u2-users mailing list [EMAIL PROTECTED] http://www.u2ug.org/listinfo/u2-users
Re: [U2] UniOleDB Configuration
I have run into some problems when explicitly defining the path, as opposed to using the actual account name, although, I have not tried the case sensitivity, but I will now. btw, your tagline made me think of something along the same lines: Fine-tuning - spanish for: It's working and I want to break it. :) Bryan - Original Message - From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, May 18, 2004 9:19 AM Subject: RE: [U2] UniOleDB Configuration > I use the full path all of the time - so I don't have to worry about > creating the entry in the ud_database file. > > I've found that if you treat *EVERYTHING* as case-sensitive then you have a > much better chance. I don't see anything blatantly wrong - the only other > problem that I've had is having a ';' in the password. > > Of course, I'm also using UniData so YMMV. > > hth > -- > Colin Alfke > Calgary, Alberta Canada > > "Just because something isn't broken doesn't mean that you can't fix it" > --- u2-users mailing list [EMAIL PROTECTED] http://www.u2ug.org/listinfo/u2-users
RE: [U2] UniOleDB Configuration
The following works for me in vb.net
Dim myCon As OleDbConnection = New
OleDbConnection("Provider=IBM.UniOLEDB;Location=; Data
Source=unidb; user id=;password=;")
Uci.conf:
---
DBMSTYPE = UNIDATA
Network = TCP/IP
Service = udserver
Host = server.hostname
jd
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Cesar Riba
Sent: Friday, May 14, 2004 12:39 PM
To: [EMAIL PROTECTED]
Subject: RE: [U2] UniOleDB Configuration
Hello
Tanks for your respons.
After of have the changes the error is another, this is the
change that I have been in uci.config of my computer.
<...>
Tanks
Cesar
---
u2-users mailing list
[EMAIL PROTECTED] http://www.u2ug.org/listinfo/u2-users
---
u2-users mailing list
[EMAIL PROTECTED]
http://www.u2ug.org/listinfo/u2-users
RE: [U2] UniOleDB Configuration
Hello Bryan I changed de name of Account in the uci.file of "E:\CUENTAS\COMERCIAL" to "COMERCIAL" and the error is the same. Tanks. Cisar. -Mensaje original- De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] nombre de Bryan Haglund Enviado el: martes, 18 de mayo de 2004 16:36 Para: [EMAIL PROTECTED] Asunto: Re: [U2] UniOleDB Configuration Cesar, Is the account name 'COMERCIAL' ? If so, that's what it needs to be in the UCI Config Editor, and not the explicit pathname for the account. Bryan - Original Message - From: "Cesar Riba" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Sunday, May 16, 2004 11:26 PM Subject: RE: [U2] UniOleDB Configuration > Bryan > > In the file UV.ACCOUNTS the format of account is "E:\CUENTAS\COMERCIAL", > but I change the parameter of account in the uci.config file in my computer > and the problem is the same. > > Tanks. > > -Mensaje original- > De: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] nombre de Bryan Haglund > Enviado el: viernes, 14 de mayo de 2004 19:05 > Para: [EMAIL PROTECTED] > Asunto: Re: [U2] UniOleDB Configuration > > > Cesar, > > The account name format is incorrect. It needs to be the actual UniVerse > account name as defined in UV.ACCOUNTS. > > Bryan Haglund > Haglund Consulting Inc. > > - Original Message - > From: "Cesar Riba" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Friday, May 14, 2004 9:39 AM > Subject: RE: [U2] UniOleDB Configuration > > > > Hello > > Tanks for your respons. > > > > After of have the changes the error is another, this is the change that I > > have been in uci.config of my computer. > > > > > > DBMSTYPE = UNIVERSE > > HOST = 10.0.0.3 > > ACCOUNT = \\DELL\CUENTAS\COMERCIAL > > USERNAME = CESAR > > MAXFETCHBUFF = 2 > > MAXFETCHCOLS = 800 > > NETWORK = TCP/IP > > SERVICE = uvserver > > > > > > And the error that I recibe is: > > Died in UCI::SQLConnect() with SQLSTATE IM976, Native error:0 > > [Informix][SQL Client]An illegal configuration option was found. > > > > The string connection of Visual Basic is: > > > > Provider = "Informix.UniOLEDB" > > DataSource = "vaquer" > > Location = "\\DELL\CUENTAS\COMERCIAL" > > User = "CESAR" > > Password = "" > > > > Tanks > > > > Cesar > > --- > > u2-users mailing list > > [EMAIL PROTECTED] > > http://www.u2ug.org/listinfo/u2-users > --- > u2-users mailing list > [EMAIL PROTECTED] > http://www.u2ug.org/listinfo/u2-users > --- > u2-users mailing list > [EMAIL PROTECTED] > http://www.u2ug.org/listinfo/u2-users --- u2-users mailing list [EMAIL PROTECTED] http://www.u2ug.org/listinfo/u2-users --- u2-users mailing list [EMAIL PROTECTED] http://www.u2ug.org/listinfo/u2-users
RE: [U2] UniOleDB Configuration
I use the full path all of the time - so I don't have to worry about creating the entry in the ud_database file. I've found that if you treat *EVERYTHING* as case-sensitive then you have a much better chance. I don't see anything blatantly wrong - the only other problem that I've had is having a ';' in the password. Of course, I'm also using UniData so YMMV. hth -- Colin Alfke Calgary, Alberta Canada "Just because something isn't broken doesn't mean that you can't fix it" Stu Pickles >-Original Message- >From: Bryan Haglund [mailto:[EMAIL PROTECTED] >Sent: Tuesday, May 18, 2004 8:36 AM >To: [EMAIL PROTECTED] >Subject: Re: [U2] UniOleDB Configuration > > >Cesar, > >Is the account name 'COMERCIAL' ? If so, that's what it needs >to be in the >UCI Config Editor, and not the explicit pathname for the account. > >Bryan > [snip] >> > >> > >> > DBMSTYPE = UNIVERSE >> > HOST = 10.0.0.3 >> > ACCOUNT = \\DELL\CUENTAS\COMERCIAL >> > USERNAME = CESAR >> > MAXFETCHBUFF = 2 >> > MAXFETCHCOLS = 800 >> > NETWORK = TCP/IP >> > SERVICE = uvserver >> > >> > >> > And the error that I recibe is: >> > Died in UCI::SQLConnect() with SQLSTATE IM976, Native error:0 >> > [Informix][SQL Client]An illegal configuration option was found. >> > >> > The string connection of Visual Basic is: >> > >> > Provider = "Informix.UniOLEDB" >> > DataSource = "vaquer" >> > Location = "\\DELL\CUENTAS\COMERCIAL" >> > User = "CESAR" >> > Password = "" >> > >> > Tanks >> > >> > Cesar --- u2-users mailing list [EMAIL PROTECTED] http://www.u2ug.org/listinfo/u2-users
RE: [U2] UniOleDB Configuration
Hello Gary: This provider I don't have, because I have Universe version 9.6.1.3, if I change the name of provider the system return an error indicating that this provider were is installed. Thanks. Cisar. -Mensaje original- De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] nombre de Gary Hines Enviado el: martes, 18 de mayo de 2004 14:55 Para: [EMAIL PROTECTED] Asunto: RE: [U2] UniOleDB Configuration Hi Cisar, In: Set cnUniConnect = New ADODB.Connection cnUniConnect.Provider = "Informix.UniOLEDB.1" cnUniConnect.Open "prueba", "CESAR", password.text Try changing Informix.UniOLEDB.1 to IBM.UniOLEDB. I was getting the same error until I made that change. Gary Hines Date: Tue, 18 May 2004 08:29:30 +0200 From: "Cesar Riba" <[EMAIL PROTECTED]> Subject: RE: [U2] UniOleDB Configuration Hello After change the data source name the "" to "" the error is the same. Very thanks for your help. Cisar. > Hello > > After configurating the file uci.config and the string conexion in > VB6 the > error ocurred is another. > > > Died in UCI::SQLConnect() with SQLSTATE IM976, Native error:0 > [Informix][SQL Client]ODB930077 > > > In VB6: > > Set cnUniConnect = New ADODB.Connection cnUniConnect.Provider = > "Informix.UniOLEDB.1" cnUniConnect.Open "prueba", "CESAR", > password.text > > > Thanks. > > Cisar > > Confidentiality Notice: The information in this electronic mail message is SHCDirect, LLC Confidential and may be legally privileged. It is intended solely for the addressee(s). Access to this Internet electronic mail message by anyone else is unauthorized. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it is prohibited and may be unlawful. If you have received this communication in error, please notify us immediately by replying to the message and deleting it from your computer. --- u2-users mailing list [EMAIL PROTECTED] http://www.u2ug.org/listinfo/u2-users --- u2-users mailing list [EMAIL PROTECTED] http://www.u2ug.org/listinfo/u2-users
Re: [U2] UniOleDB Configuration
Cesar, Is the account name 'COMERCIAL' ? If so, that's what it needs to be in the UCI Config Editor, and not the explicit pathname for the account. Bryan - Original Message - From: "Cesar Riba" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Sunday, May 16, 2004 11:26 PM Subject: RE: [U2] UniOleDB Configuration > Bryan > > In the file UV.ACCOUNTS the format of account is "E:\CUENTAS\COMERCIAL", > but I change the parameter of account in the uci.config file in my computer > and the problem is the same. > > Tanks. > > -Mensaje original- > De: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] nombre de Bryan Haglund > Enviado el: viernes, 14 de mayo de 2004 19:05 > Para: [EMAIL PROTECTED] > Asunto: Re: [U2] UniOleDB Configuration > > > Cesar, > > The account name format is incorrect. It needs to be the actual UniVerse > account name as defined in UV.ACCOUNTS. > > Bryan Haglund > Haglund Consulting Inc. > > - Original Message - > From: "Cesar Riba" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Friday, May 14, 2004 9:39 AM > Subject: RE: [U2] UniOleDB Configuration > > > > Hello > > Tanks for your respons. > > > > After of have the changes the error is another, this is the change that I > > have been in uci.config of my computer. > > > > > > DBMSTYPE = UNIVERSE > > HOST = 10.0.0.3 > > ACCOUNT = \\DELL\CUENTAS\COMERCIAL > > USERNAME = CESAR > > MAXFETCHBUFF = 2 > > MAXFETCHCOLS = 800 > > NETWORK = TCP/IP > > SERVICE = uvserver > > > > > > And the error that I recibe is: > > Died in UCI::SQLConnect() with SQLSTATE IM976, Native error:0 > > [Informix][SQL Client]An illegal configuration option was found. > > > > The string connection of Visual Basic is: > > > > Provider = "Informix.UniOLEDB" > > DataSource = "vaquer" > > Location = "\\DELL\CUENTAS\COMERCIAL" > > User = "CESAR" > > Password = "" > > > > Tanks > > > > Cesar > > --- > > u2-users mailing list > > [EMAIL PROTECTED] > > http://www.u2ug.org/listinfo/u2-users > --- > u2-users mailing list > [EMAIL PROTECTED] > http://www.u2ug.org/listinfo/u2-users > --- > u2-users mailing list > [EMAIL PROTECTED] > http://www.u2ug.org/listinfo/u2-users --- u2-users mailing list [EMAIL PROTECTED] http://www.u2ug.org/listinfo/u2-users
RE: [U2] UniOleDB Configuration
Hi Cisar, In: Set cnUniConnect = New ADODB.Connection cnUniConnect.Provider = "Informix.UniOLEDB.1" cnUniConnect.Open "prueba", "CESAR", password.text Try changing Informix.UniOLEDB.1 to IBM.UniOLEDB. I was getting the same error until I made that change. Gary Hines Date: Tue, 18 May 2004 08:29:30 +0200 From: "Cesar Riba" <[EMAIL PROTECTED]> Subject: RE: [U2] UniOleDB Configuration Hello After change the data source name the "" to "" the error is the same. Very thanks for your help. Cisar. > Hello > > After configurating the file uci.config and the string conexion in > VB6 the > error ocurred is another. > > > Died in UCI::SQLConnect() with SQLSTATE IM976, Native error:0 > [Informix][SQL Client]ODB930077 > > > In VB6: > > Set cnUniConnect = New ADODB.Connection cnUniConnect.Provider = > "Informix.UniOLEDB.1" cnUniConnect.Open "prueba", "CESAR", > password.text > > > Thanks. > > Cisar > > Confidentiality Notice: The information in this electronic mail message is SHCDirect, LLC Confidential and may be legally privileged. It is intended solely for the addressee(s). Access to this Internet electronic mail message by anyone else is unauthorized. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it is prohibited and may be unlawful. If you have received this communication in error, please notify us immediately by replying to the message and deleting it from your computer. --- u2-users mailing list [EMAIL PROTECTED] http://www.u2ug.org/listinfo/u2-users
RE: [U2] UniOleDB Configuration
Hello After change the data source name the "" to "" the error is the same. Very thanks for your help. Cisar. -Mensaje original- De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] nombre de Ray Wurlod Enviado el: lunes, 17 de mayo de 2004 22:51 Para: [EMAIL PROTECTED] Asunto: RE: [U2] UniOleDB Configuration Clutching at straws here. What happens if you use "" rather than "" as the data source name? - Original Message - From: "Cesar Riba" <[EMAIL PROTECTED]> Date: Mon, 17 May 2004 18:01:23 +0200 To: <[EMAIL PROTECTED]> Subject: RE: [U2] UniOleDB Configuration > Hello > > After configurating the file uci.config and the string conexion in VB6 the > error ocurred is another. > > > Died in UCI::SQLConnect() with SQLSTATE IM976, Native error:0 > [Informix][SQL Client]ODB930077 > > This is my configuration: > > > DBMSTYPE = UNIVERSE > NETWORK = TCP/IP > SERVICE = uvserver > HOST = 10.0.0.3 > ACCOUNT = E:\CUENTAS\COMERCIAL > USERNAME = CESAR > MAXFETCHBUFF = 8192 > MAXFETCHCOLS = 400 > > In VB6: > > Set cnUniConnect = New ADODB.Connection > cnUniConnect.Provider = "Informix.UniOLEDB.1" > cnUniConnect.Open "prueba", "CESAR", password.text > > > Thanks. > > Cisar > > > -Mensaje original- > De: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] nombre de Brian Leach > Enviado el: lunes, 17 de mayo de 2004 14:27 > Para: [EMAIL PROTECTED] > Asunto: Re: [U2] UniOleDB Configuration > > > Cesar, > > Here is my configuration for a test account. this works > ok. > > You did take the Location out of your connection string as > well, yes? > > > > DBMSTYPE = UNIVERSE > NETWORK = TCP/IP > SERVICE = uvserver > HOST = shark > ACCOUNT = c:\Accounts\oledb > USERNAME = Administrator > MAXFETCHBUFF = 8192 > MAXFETCHCOLS = 400 > > In VB6: > > Set dbConn = New ADODB.Connection > dbConn.Provider = "Informix.UniOLEDB.1" > dbConn.Open "OLEDB", "Administrator", txtPassword.Text > > Hope this is of some help, > > Brian Leach > > > On Mon, 17 May 2004 08:26:25 +0200 > "Cesar Riba" <[EMAIL PROTECTED]> wrote: > >Bryan > > > > In the file UV.ACCOUNTS the format of account is > >"E:\CUENTAS\COMERCIAL", > >but I change the parameter of account in the uci.config > >file in my computer > >and the problem is the same. > > > >Tanks. > > > This email was checked on leaving Microgen for viruses, similar > malicious code and inappropriate content by MessageLabs SkyScan. > > DISCLAIMER > > This email and any attachments are confidential and may also be > privileged. > > If you are not the named recipient, please notify the sender > immediately and do not disclose the contents to any other > person, use it for any purpose, or store or copy the information. > > In the event of any technical difficulty with this email, please > contact the sender or [EMAIL PROTECTED] > > Microgen Information Management Solutions > http://www.microgen.co.uk > --- > u2-users mailing list > [EMAIL PROTECTED] > http://www.u2ug.org/listinfo/u2-users > --- > u2-users mailing list > [EMAIL PROTECTED] > http://www.u2ug.org/listinfo/u2-users --- u2-users mailing list [EMAIL PROTECTED] http://www.u2ug.org/listinfo/u2-users --- u2-users mailing list [EMAIL PROTECTED] http://www.u2ug.org/listinfo/u2-users
RE: [U2] UniOleDB Configuration
Clutching at straws here. What happens if you use "" rather than "" as the data source name? - Original Message - From: "Cesar Riba" <[EMAIL PROTECTED]> Date: Mon, 17 May 2004 18:01:23 +0200 To: <[EMAIL PROTECTED]> Subject: RE: [U2] UniOleDB Configuration > Hello > > After configurating the file uci.config and the string conexion in VB6 the > error ocurred is another. > > > Died in UCI::SQLConnect() with SQLSTATE IM976, Native error:0 > [Informix][SQL Client]ODB930077 > > This is my configuration: > > > DBMSTYPE = UNIVERSE > NETWORK = TCP/IP > SERVICE = uvserver > HOST = 10.0.0.3 > ACCOUNT = E:\CUENTAS\COMERCIAL > USERNAME = CESAR > MAXFETCHBUFF = 8192 > MAXFETCHCOLS = 400 > > In VB6: > > Set cnUniConnect = New ADODB.Connection > cnUniConnect.Provider = "Informix.UniOLEDB.1" > cnUniConnect.Open "prueba", "CESAR", password.text > > > Thanks. > > Cisar > > > -Mensaje original- > De: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] nombre de Brian Leach > Enviado el: lunes, 17 de mayo de 2004 14:27 > Para: [EMAIL PROTECTED] > Asunto: Re: [U2] UniOleDB Configuration > > > Cesar, > > Here is my configuration for a test account. this works > ok. > > You did take the Location out of your connection string as > well, yes? > > > > DBMSTYPE = UNIVERSE > NETWORK = TCP/IP > SERVICE = uvserver > HOST = shark > ACCOUNT = c:\Accounts\oledb > USERNAME = Administrator > MAXFETCHBUFF = 8192 > MAXFETCHCOLS = 400 > > In VB6: > > Set dbConn = New ADODB.Connection > dbConn.Provider = "Informix.UniOLEDB.1" > dbConn.Open "OLEDB", "Administrator", txtPassword.Text > > Hope this is of some help, > > Brian Leach > > > On Mon, 17 May 2004 08:26:25 +0200 > "Cesar Riba" <[EMAIL PROTECTED]> wrote: > >Bryan > > > > In the file UV.ACCOUNTS the format of account is > >"E:\CUENTAS\COMERCIAL", > >but I change the parameter of account in the uci.config > >file in my computer > >and the problem is the same. > > > >Tanks. > > > This email was checked on leaving Microgen for viruses, similar > malicious code and inappropriate content by MessageLabs SkyScan. > > DISCLAIMER > > This email and any attachments are confidential and may also be > privileged. > > If you are not the named recipient, please notify the sender > immediately and do not disclose the contents to any other > person, use it for any purpose, or store or copy the information. > > In the event of any technical difficulty with this email, please > contact the sender or [EMAIL PROTECTED] > > Microgen Information Management Solutions > http://www.microgen.co.uk > --- > u2-users mailing list > [EMAIL PROTECTED] > http://www.u2ug.org/listinfo/u2-users > --- > u2-users mailing list > [EMAIL PROTECTED] > http://www.u2ug.org/listinfo/u2-users --- u2-users mailing list [EMAIL PROTECTED] http://www.u2ug.org/listinfo/u2-users
RE: [U2] UniOleDB Configuration
Hello After configurating the file uci.config and the string conexion in VB6 the error ocurred is another. Died in UCI::SQLConnect() with SQLSTATE IM976, Native error:0 [Informix][SQL Client]ODB930077 This is my configuration: DBMSTYPE = UNIVERSE NETWORK = TCP/IP SERVICE = uvserver HOST = 10.0.0.3 ACCOUNT = E:\CUENTAS\COMERCIAL USERNAME = CESAR MAXFETCHBUFF = 8192 MAXFETCHCOLS = 400 In VB6: Set cnUniConnect = New ADODB.Connection cnUniConnect.Provider = "Informix.UniOLEDB.1" cnUniConnect.Open "prueba", "CESAR", password.text Thanks. Cisar -Mensaje original- De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] nombre de Brian Leach Enviado el: lunes, 17 de mayo de 2004 14:27 Para: [EMAIL PROTECTED] Asunto: Re: [U2] UniOleDB Configuration Cesar, Here is my configuration for a test account. this works ok. You did take the Location out of your connection string as well, yes? DBMSTYPE = UNIVERSE NETWORK = TCP/IP SERVICE = uvserver HOST = shark ACCOUNT = c:\Accounts\oledb USERNAME = Administrator MAXFETCHBUFF = 8192 MAXFETCHCOLS = 400 In VB6: Set dbConn = New ADODB.Connection dbConn.Provider = "Informix.UniOLEDB.1" dbConn.Open "OLEDB", "Administrator", txtPassword.Text Hope this is of some help, Brian Leach On Mon, 17 May 2004 08:26:25 +0200 "Cesar Riba" <[EMAIL PROTECTED]> wrote: >Bryan > > In the file UV.ACCOUNTS the format of account is >"E:\CUENTAS\COMERCIAL", >but I change the parameter of account in the uci.config >file in my computer >and the problem is the same. > >Tanks. This email was checked on leaving Microgen for viruses, similar malicious code and inappropriate content by MessageLabs SkyScan. DISCLAIMER This email and any attachments are confidential and may also be privileged. If you are not the named recipient, please notify the sender immediately and do not disclose the contents to any other person, use it for any purpose, or store or copy the information. In the event of any technical difficulty with this email, please contact the sender or [EMAIL PROTECTED] Microgen Information Management Solutions http://www.microgen.co.uk --- u2-users mailing list [EMAIL PROTECTED] http://www.u2ug.org/listinfo/u2-users --- u2-users mailing list [EMAIL PROTECTED] http://www.u2ug.org/listinfo/u2-users
Re: [U2] UniOleDB Configuration
Cesar, Here is my configuration for a test account. this works ok. You did take the Location out of your connection string as well, yes? DBMSTYPE = UNIVERSE NETWORK = TCP/IP SERVICE = uvserver HOST = shark ACCOUNT = c:\Accounts\oledb USERNAME = Administrator MAXFETCHBUFF = 8192 MAXFETCHCOLS = 400 In VB6: Set dbConn = New ADODB.Connection dbConn.Provider = "Informix.UniOLEDB.1" dbConn.Open "OLEDB", "Administrator", txtPassword.Text Hope this is of some help, Brian Leach On Mon, 17 May 2004 08:26:25 +0200 "Cesar Riba" <[EMAIL PROTECTED]> wrote: Bryan In the file UV.ACCOUNTS the format of account is "E:\CUENTAS\COMERCIAL", but I change the parameter of account in the uci.config file in my computer and the problem is the same. Tanks. This email was checked on leaving Microgen for viruses, similar malicious code and inappropriate content by MessageLabs SkyScan. DISCLAIMER This email and any attachments are confidential and may also be privileged. If you are not the named recipient, please notify the sender immediately and do not disclose the contents to any other person, use it for any purpose, or store or copy the information. In the event of any technical difficulty with this email, please contact the sender or [EMAIL PROTECTED] Microgen Information Management Solutions http://www.microgen.co.uk --- u2-users mailing list [EMAIL PROTECTED] http://www.u2ug.org/listinfo/u2-users
RE: [U2] UniOleDB Configuration
Bryan In the file UV.ACCOUNTS the format of account is "E:\CUENTAS\COMERCIAL", but I change the parameter of account in the uci.config file in my computer and the problem is the same. Tanks. -Mensaje original- De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] nombre de Bryan Haglund Enviado el: viernes, 14 de mayo de 2004 19:05 Para: [EMAIL PROTECTED] Asunto: Re: [U2] UniOleDB Configuration Cesar, The account name format is incorrect. It needs to be the actual UniVerse account name as defined in UV.ACCOUNTS. Bryan Haglund Haglund Consulting Inc. - Original Message - From: "Cesar Riba" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, May 14, 2004 9:39 AM Subject: RE: [U2] UniOleDB Configuration > Hello > Tanks for your respons. > > After of have the changes the error is another, this is the change that I > have been in uci.config of my computer. > > > DBMSTYPE = UNIVERSE > HOST = 10.0.0.3 > ACCOUNT = \\DELL\CUENTAS\COMERCIAL > USERNAME = CESAR > MAXFETCHBUFF = 2 > MAXFETCHCOLS = 800 > NETWORK = TCP/IP > SERVICE = uvserver > > > And the error that I recibe is: > Died in UCI::SQLConnect() with SQLSTATE IM976, Native error:0 > [Informix][SQL Client]An illegal configuration option was found. > > The string connection of Visual Basic is: > > Provider = "Informix.UniOLEDB" > DataSource = "vaquer" > Location = "\\DELL\CUENTAS\COMERCIAL" > User = "CESAR" > Password = "" > > Tanks > > Cesar > --- > u2-users mailing list > [EMAIL PROTECTED] > http://www.u2ug.org/listinfo/u2-users --- u2-users mailing list [EMAIL PROTECTED] http://www.u2ug.org/listinfo/u2-users --- u2-users mailing list [EMAIL PROTECTED] http://www.u2ug.org/listinfo/u2-users
RE: [U2] UniOleDB With Crystal Reports
According to the support case I opened it's a known bug, but with no timescales for a fix. Hoping to move to Unidata 6 to see if the problem is resolved. Also rewriting chunks of the code with Raining Data's PDP product which appears to be faster and more importantly concurrent. I realise SQL is not a core feature of Unidata/Universe but it offers a lot of possibilities to those of us who want systems to talk to each other without having to skill up on UCI and C. Oh well. Nick -Original Message- From: Bryan Haglund [mailto:[EMAIL PROTECTED] Sent: 14 May 2004 17:01 To: [EMAIL PROTECTED] Subject: Re: [U2] UniOleDB With Crystal Reports Well, that would certainly tend to slow things down. I wonder why they would have set it to operate like that? Bryan - Original Message - From: "Nick Southwell" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, May 14, 2004 2:47 AM Subject: RE: [U2] UniOleDB With Crystal Reports > Worth mentioning that we have implemented > an OLEDB solution, driver version 1.4.3 > against Unidata 5.2 and have discovered that the driver is not > capable of concurrent execution, more specifically it's the > unirpc service which serialises all requests. > > Cheers > > Nick > > -Original Message- > From: Bryan Haglund [mailto:[EMAIL PROTECTED] > Sent: 13 May 2004 18:07 > To: [EMAIL PROTECTED] > Subject: Re: [U2] UniOleDB With Crystal Reports > > Eric, > > The first thing you need to do is to add your specific OLE connection > using the UCI Config Editor. The minimum requirements are: > DBMSTYPEUNIVERSE > NETWORKTCP/IP > SERVICEservice name (uvserver) > HOST ip address used. > > Note that for the host, there are certain configurations that will not > work with 'localhost' or '127.0.0.1' - as such, it is best to specify > the specific host, such as 'uvserver.foo.com' or '172.55.122.3' > > Next, in Crystal Reports, you need to expand the 'More Data Sources' > from the Data Explorer dialog box, then expand the 'Active Data', then > expand the 'Active Data (ADO)'. If nothing is set up, you are then > prompted to select a data source. The default is 'ODBC (ADO)' - change > this by clicking on the radio button for 'ADO and OLE DB'. The > connection string box is then no longer grayed out. Click on the > 'Build' button to have the specific string built for you. > > Under the 'Provider' tab, select the 'UniOLEDB Provider' and click > 'Next' > For the 'Data Source', enter the name of the OLE connection you saved in > the UCI Config Editor. > Specify a user name and password, and click on the 'Test Connection' > button. > The test should come back ok. You can then use this to access the data. > > On the downside, some systems have a performance issue with OLE DB where > ODBC works faster, but ODBC has an upper limit of around 160K-170K > records on some systems. I have not been able to find much in the way > of documentation from IBM that addresses how to tune the performance of > OLE DB. > > Hope this helps! > > Bryan Haglund > Haglund Consulting Inc. > > - Original Message - > From: "Eric Cox" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Thursday, May 13, 2004 8:46 AM > Subject: [U2] UniOleDB With Crystal Reports > > > > All, > > > > Has anyone had any luck connecting Crystal Reports to a U2 database > > using OleDB? I'm trying it here and keep getting the message 'cannot > > connect to non U2 databases' (I have UniVerse and SQL Server installed > > but I'm using the UniOleDB Provider) - ODBC connectivity works fine > but > > I want to use OleDB. > > > > Any help or thoughts as always, greatly appreciated. > > > > Regards > > > > Eric > > > > --- > > Outgoing mail is certified Virus Free. > > Checked by AVG anti-virus system (http://www.grisoft.com). > > Version: 6.0.677 / Virus Database: 439 - Release Date: 04/05/2004 > > --- > > u2-users mailing list > > [EMAIL PROTECTED] > > http://www.u2ug.org/listinfo/u2-users > --- > u2-users mailing list > [EMAIL PROTECTED] > http://www.u2ug.org/listinfo/u2-users > > This correspondence is confidential and is solely for the intended > recipient(s). If you are not the intended recipient, you must not use, > disclose, copy, distribute or retain this message or any part of it. If you > are not the intended recipient please delete this correspondence from your > system and notify the sender
Re: [U2] UniOleDB Configuration
Cesar, The account name format is incorrect. It needs to be the actual UniVerse account name as defined in UV.ACCOUNTS. Bryan Haglund Haglund Consulting Inc. - Original Message - From: "Cesar Riba" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, May 14, 2004 9:39 AM Subject: RE: [U2] UniOleDB Configuration > Hello > Tanks for your respons. > > After of have the changes the error is another, this is the change that I > have been in uci.config of my computer. > > > DBMSTYPE = UNIVERSE > HOST = 10.0.0.3 > ACCOUNT = \\DELL\CUENTAS\COMERCIAL > USERNAME = CESAR > MAXFETCHBUFF = 2 > MAXFETCHCOLS = 800 > NETWORK = TCP/IP > SERVICE = uvserver > > > And the error that I recibe is: > Died in UCI::SQLConnect() with SQLSTATE IM976, Native error:0 > [Informix][SQL Client]An illegal configuration option was found. > > The string connection of Visual Basic is: > > Provider = "Informix.UniOLEDB" > DataSource = "vaquer" > Location = "\\DELL\CUENTAS\COMERCIAL" > User = "CESAR" > Password = "" > > Tanks > > Cesar > --- > u2-users mailing list > [EMAIL PROTECTED] > http://www.u2ug.org/listinfo/u2-users --- u2-users mailing list [EMAIL PROTECTED] http://www.u2ug.org/listinfo/u2-users
RE: [U2] UniOleDB Configuration
Hello Tanks for your respons. After of have the changes the error is another, this is the change that I have been in uci.config of my computer. DBMSTYPE = UNIVERSE HOST = 10.0.0.3 ACCOUNT = \\DELL\CUENTAS\COMERCIAL USERNAME = CESAR MAXFETCHBUFF = 2 MAXFETCHCOLS = 800 NETWORK = TCP/IP SERVICE = uvserver And the error that I recibe is: Died in UCI::SQLConnect() with SQLSTATE IM976, Native error:0 [Informix][SQL Client]An illegal configuration option was found. The string connection of Visual Basic is: Provider = "Informix.UniOLEDB" DataSource = "vaquer" Location = "\\DELL\CUENTAS\COMERCIAL" User = "CESAR" Password = "" Tanks Cesar --- u2-users mailing list [EMAIL PROTECTED] http://www.u2ug.org/listinfo/u2-users
Re: [U2] UniOleDB Configuration
Cesar, If you are entering a path (location) in the connection string, you will likely have problems - leave this field blank, and let it pull the information from what is set up in the UCI Config Editor. Bryan Haglund Haglund Consulting Inc. - Original Message - From: "Cesar Riba" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, May 14, 2004 7:08 AM Subject: [U2] UniOleDB Configuration > Hello, > > My conexion with ODBC are working, but the conexion with UniOLEDB don't can > working, when I conect from Visual Basic I recived this error: > > Died in UCI::SQLConnect() with SQLSTATE IM976, Native error:0 > [Informix][SQL Client]UCI connections to non Universe databases is not > allowed. > > My uci.config file in my computer is, and the version of Universe is > [9.6.1.3]: > > > [ODBC DATA SOURCES] > > > DBMSTYPE = UNIDATA > network = TCP/IP > service = udserver > host = localhost > > > DBMSTYPE = UNIVERSE > HOST = 10.0.0.3 > MAXFETCHBUFF = 2 > MAXFETCHCOLS = 800 > NETWORK = TCP/IP > SERVICE = uvserver > > > > Can anybody help me. > > Tanks. > > Cisar Riba > Spain. > --- > u2-users mailing list > [EMAIL PROTECTED] > http://www.u2ug.org/listinfo/u2-users --- u2-users mailing list [EMAIL PROTECTED] http://www.u2ug.org/listinfo/u2-users
Re: [U2] UniOleDB With Crystal Reports
Well, that would certainly tend to slow things down. I wonder why they would have set it to operate like that? Bryan - Original Message - From: "Nick Southwell" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, May 14, 2004 2:47 AM Subject: RE: [U2] UniOleDB With Crystal Reports > Worth mentioning that we have implemented > an OLEDB solution, driver version 1.4.3 > against Unidata 5.2 and have discovered that the driver is not > capable of concurrent execution, more specifically it's the > unirpc service which serialises all requests. > > Cheers > > Nick > > -Original Message- > From: Bryan Haglund [mailto:[EMAIL PROTECTED] > Sent: 13 May 2004 18:07 > To: [EMAIL PROTECTED] > Subject: Re: [U2] UniOleDB With Crystal Reports > > Eric, > > The first thing you need to do is to add your specific OLE connection > using the UCI Config Editor. The minimum requirements are: > DBMSTYPEUNIVERSE > NETWORKTCP/IP > SERVICEservice name (uvserver) > HOST ip address used. > > Note that for the host, there are certain configurations that will not > work with 'localhost' or '127.0.0.1' - as such, it is best to specify > the specific host, such as 'uvserver.foo.com' or '172.55.122.3' > > Next, in Crystal Reports, you need to expand the 'More Data Sources' > from the Data Explorer dialog box, then expand the 'Active Data', then > expand the 'Active Data (ADO)'. If nothing is set up, you are then > prompted to select a data source. The default is 'ODBC (ADO)' - change > this by clicking on the radio button for 'ADO and OLE DB'. The > connection string box is then no longer grayed out. Click on the > 'Build' button to have the specific string built for you. > > Under the 'Provider' tab, select the 'UniOLEDB Provider' and click > 'Next' > For the 'Data Source', enter the name of the OLE connection you saved in > the UCI Config Editor. > Specify a user name and password, and click on the 'Test Connection' > button. > The test should come back ok. You can then use this to access the data. > > On the downside, some systems have a performance issue with OLE DB where > ODBC works faster, but ODBC has an upper limit of around 160K-170K > records on some systems. I have not been able to find much in the way > of documentation from IBM that addresses how to tune the performance of > OLE DB. > > Hope this helps! > > Bryan Haglund > Haglund Consulting Inc. > > - Original Message - > From: "Eric Cox" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Thursday, May 13, 2004 8:46 AM > Subject: [U2] UniOleDB With Crystal Reports > > > > All, > > > > Has anyone had any luck connecting Crystal Reports to a U2 database > > using OleDB? I'm trying it here and keep getting the message 'cannot > > connect to non U2 databases' (I have UniVerse and SQL Server installed > > but I'm using the UniOleDB Provider) - ODBC connectivity works fine > but > > I want to use OleDB. > > > > Any help or thoughts as always, greatly appreciated. > > > > Regards > > > > Eric > > > > --- > > Outgoing mail is certified Virus Free. > > Checked by AVG anti-virus system (http://www.grisoft.com). > > Version: 6.0.677 / Virus Database: 439 - Release Date: 04/05/2004 > > --- > > u2-users mailing list > > [EMAIL PROTECTED] > > http://www.u2ug.org/listinfo/u2-users > --- > u2-users mailing list > [EMAIL PROTECTED] > http://www.u2ug.org/listinfo/u2-users > > This correspondence is confidential and is solely for the intended > recipient(s). If you are not the intended recipient, you must not use, > disclose, copy, distribute or retain this message or any part of it. If you > are not the intended recipient please delete this correspondence from your > system and notify the sender immediately. > > No warranty is given that this correspondence is free from any virus. In > keeping with good computer practice, you should ensure that it is actually > virus free. E-mail messages may be subject to delays, non-delivery and > unauthorised alterations therefore, information expressed in this message is > not given or endorsed by Open and Direct Group Limited unless otherwise > notified by our duly authorised representative independent of this message. > > Open and Direct Group Limited is a limited company registered in United > Kingdom under number 4390810 whose registered office is at 10 Norwich > Street, London, EC4A 1BD > --- > u2-users mailing list > [EMAIL PROTECTED] > http://www.u2ug.org/listinfo/u2-users --- u2-users mailing list [EMAIL PROTECTED] http://www.u2ug.org/listinfo/u2-users
Re: [U2] UniOleDB With Crystal Reports
- Original Message - From: "Brian Leach" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, May 14, 2004 1:07 AM Subject: Re: [U2] UniOleDB With Crystal Reports > >I'd sure like to see some documentation that would help > >address performance > >when selecting large amounts of data. > > Frankly, you are unlikely to see great performance from > UniOleDB when reporting with most applications. As a > minimum, I would suggest that you need to look at your > data structures and possibly look at creating reporting > accounts: UniOleDB does a good job but it is an uphill > struggle when it has to handle 'regular' mv files > containing multiple associations, lots of fields per > record, lack of indexing etc. The things you outline had already been done. OLE DB is supposed to be 'newer and better' and ODBC. I guess that newer and better means slower. The problem is that ODBC drops off around 170K records, but is very fast, and OLE DB doesn't drop of but is very slow to retrieve. I have a customer that is told by IBM that they must use the partner who has the support contract, to whom money has been paid, but that partner will not provide the support that is needed. IBM won't talk to me about this because I'm not the partner, and my customer is again told to use the support partner. (sounds strangely like circular reasoning) Anyone have any thoughts for how to handle this? Thanks, Bryan Haglund Haglund Consulting Inc. --- u2-users mailing list [EMAIL PROTECTED] http://www.u2ug.org/listinfo/u2-users
RE: [U2] UniOleDB With Crystal Reports
Brian, As usual your advice is useful and objective and most welcome. Hopefully the OLEDB documentation will improve over time and I believe IBM could still do some work to make the interface easier to use and to improve its performance. The U2 product set has a lot to offer and has put a roof over my head for a good few years so I am prepared to be optimistic :) Cheers Eric -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brian Leach Sent: 14 May 2004 14:20 To: [EMAIL PROTECTED] Subject: Re: [U2] UniOleDB With Crystal Reports Eric, Think about what OleDB has to do. Then think about the standard multivalue application. Finally think what would happen to OleDB if you designed and implemented say a SQL server database using the same file structures. It would die. Relational databases that return row sets (like OleDB) are predicated on the fact that the database is highly normalized. That does not only mean that the data is 2 dimensional - it means that the tables are reduced to such an extent that each table contains only the minimal number of columns. Lots of tables, few columns. Since OleDB looks at each table, this means that the amount of data retrieved is kept to a minimum. Multivalue databases, on the other hand, frequently contain files with many hundreds of fields per record. This is not a bad thing - in fact it is part of the advantage of multivalue - but it does not fit well with record set technologies like OleDB. So the problem is not realy with OleDB or with the IBM implementation of OleDB : it is with trying to apply OleDB to existing file structures that are just not designed with that style of data presentation in mind. Create a reporting account with the data reformatted, and you will probably get a lot further. As for open standards, watch out for web services. These are the new open standard for access: and this is where multivalue databases like UniVerse can score highly, both at the functional and record set levels: the latter because of the near match between XML and multivalued data (see the TOXML keyword in UniVerse SQL and RetrieVe for example) and functionally because of the strength of the run machine built into the database. So don't give up hope. (though you might still want to buy mvQuery) Oh and by the way OleDB is superior to ODBC. That's the nature of the protocol: cleaner, leaner, less to heavy. But the documentation sucks. Brian > >I have seen a couple of posts previously on the list >where people >suggest that UniOleDB is superior to ODBC. From what I am >hearing it >would seem that this is not the case and furthermore both >the >implementation of ODBC and OLEDB under UniVerse are >poorly implemented >features with functionality issues which undermine the >feasibility of >using either solution in a large site (note I refer to >large sites >specifically as I am sure the solutions would serve the >needs of SMEs >adequately) > >I can understand no improvements being made to ODBC >connectivity as this >is clearly not the way forward for Microsoft but if IBM >do not improve >OleDB functionality, it is one more concession to the >benefit of >competing platforms and solutions. > >Am I worrying unnecessarily or should I abandon all hope >of ever >achieving open database connectivity with UniVerse >without the use of >third party tools such as MVQuery? > >Cheers > >Eric > >-Original Message- >From: [EMAIL PROTECTED] >[mailto:[EMAIL PROTECTED] On Behalf Of >Nick Southwell >Sent: 14 May 2004 10:47 >To: [EMAIL PROTECTED] >Subject: RE: [U2] UniOleDB With Crystal Reports > >Worth mentioning that we have implemented >an OLEDB solution, driver version 1.4.3 >against Unidata 5.2 and have discovered that the driver >is not >capable of concurrent execution, more specifically it's >the >unirpc service which serialises all requests. > >Cheers > >Nick > >-Original Message- >From: Bryan Haglund [mailto:[EMAIL PROTECTED] >Sent: 13 May 2004 18:07 >To: [EMAIL PROTECTED] >Subject: Re: [U2] UniOleDB With Crystal Reports > >Eric, > >The first thing you need to do is to add your specific >OLE connection >using the UCI Config Editor. The minimum requirements >are: >DBMSTYPEUNIVERSE >NETWORKTCP/IP >SERVICEservice name (uvserver) >HOST ip address used. > >Note that for the host, there are certain configurations >that will not >work with 'localhost' or '127.0.0.1' - as such, it is >best to specify >the specific host, such as 'uvserver.foo.com' or >'172.55.122.3' > >Next, in Crystal Reports, you need to expand the 'More >Data Sources' >from the
Re: [U2] UniOleDB Configuration
Cisar You need to add the line: ACCOUNT = yourpath to your file. Brian My conexion with ODBC are working, but the conexion with UniOLEDB don't can working, when I conect from Visual Basic I recived this error: DBMSTYPE = UNIVERSE HOST = 10.0.0.3 MAXFETCHBUFF = 2 MAXFETCHCOLS = 800 NETWORK = TCP/IP SERVICE = uvserver Can anybody help me. Tanks. Cisar Riba This email was checked on leaving Microgen for viruses, similar malicious code and inappropriate content by MessageLabs SkyScan. DISCLAIMER This email and any attachments are confidential and may also be privileged. If you are not the named recipient, please notify the sender immediately and do not disclose the contents to any other person, use it for any purpose, or store or copy the information. In the event of any technical difficulty with this email, please contact the sender or [EMAIL PROTECTED] Microgen Information Management Solutions http://www.microgen.co.uk --- u2-users mailing list [EMAIL PROTECTED] http://www.u2ug.org/listinfo/u2-users
RE: [U2] UniOleDB Configuration
Cesar, I encountered the same error - I dont think the interface likes the use of 'localhost' (as Bryan Haglund pointed out previously) - Try specifying your actual IP address instead (please find below a copy of my uci.config that works) Cheers Eric [ODBC DATA SOURCES] DBMSTYPE = UNIVERSE network = TCP/IP service = uvserver host = 192.168.0.21 account = HS.SERVICE MAXFETCHBUFF = 8192 MAXFETCHCOLS = 400 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Cesar Riba Sent: 14 May 2004 15:08 To: [EMAIL PROTECTED] Subject: [U2] UniOleDB Configuration Hello, My conexion with ODBC are working, but the conexion with UniOLEDB don't can working, when I conect from Visual Basic I recived this error: Died in UCI::SQLConnect() with SQLSTATE IM976, Native error:0 [Informix][SQL Client]UCI connections to non Universe databases is not allowed. My uci.config file in my computer is, and the version of Universe is [9.6.1.3]: [ODBC DATA SOURCES] DBMSTYPE = UNIDATA network = TCP/IP service = udserver host = localhost DBMSTYPE = UNIVERSE HOST = 10.0.0.3 MAXFETCHBUFF = 2 MAXFETCHCOLS = 800 NETWORK = TCP/IP SERVICE = uvserver Can anybody help me. Tanks. Cisar Riba Spain. --- u2-users mailing list [EMAIL PROTECTED] http://www.u2ug.org/listinfo/u2-users --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.677 / Virus Database: 439 - Release Date: 04/05/2004 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.677 / Virus Database: 439 - Release Date: 04/05/2004 --- u2-users mailing list [EMAIL PROTECTED] http://www.u2ug.org/listinfo/u2-users
RE: [U2] UniOleDB Configuration
Make sure your connection string is using the correct case for the Data Source as it has to match the uci.config exactly. Also make sure that the location is a proper account or full path. Here is a file I have on my desktop called myconnection.udl that will test the connection: [oledb] ; Everything after this line is an OLE DB initstring Provider=IBM.UniOLEDB.1;Password=yourpassword;Persist Security Info=True;User ID=youruser;Data Source=vaquer;Location=d:\unidata\demo If you double click on it you will get a MS Data Link Properties dialog that you can use to test the connection. Of course you also would have had to install all of the UniOleDb files when you installed the development kit. I just don't remember off hand if it is a separate option. hth -- Colin Alfke Calgary, Alberta Canada "Just because something isn't broken doesn't mean that you can't fix it" Stu Pickles >-Original Message- >From: Cesar Riba [mailto:[EMAIL PROTECTED] >Sent: Friday, May 14, 2004 8:08 AM >To: [EMAIL PROTECTED] >Subject: [U2] UniOleDB Configuration > > >Hello, > > My conexion with ODBC are working, but the conexion >with UniOLEDB don't can >working, when I conect from Visual Basic I recived this error: > > Died in UCI::SQLConnect() with SQLSTATE IM976, >Native error:0 >[Informix][SQL Client]UCI connections to non Universe databases is not >allowed. > > My uci.config file in my computer is, and the version >of Universe is >[9.6.1.3]: > > > [ODBC DATA SOURCES] > > > DBMSTYPE = UNIDATA > network = TCP/IP > service = udserver > host = localhost > > > DBMSTYPE = UNIVERSE > HOST = 10.0.0.3 > MAXFETCHBUFF = 2 > MAXFETCHCOLS = 800 > NETWORK = TCP/IP > SERVICE = uvserver > > > > Can anybody help me. > >Tanks. > >Cisar Riba >Spain. --- u2-users mailing list [EMAIL PROTECTED] http://www.u2ug.org/listinfo/u2-users
[U2] UniOleDB Configuration
Hello, My conexion with ODBC are working, but the conexion with UniOLEDB don't can working, when I conect from Visual Basic I recived this error: Died in UCI::SQLConnect() with SQLSTATE IM976, Native error:0 [Informix][SQL Client]UCI connections to non Universe databases is not allowed. My uci.config file in my computer is, and the version of Universe is [9.6.1.3]: [ODBC DATA SOURCES] DBMSTYPE = UNIDATA network = TCP/IP service = udserver host = localhost DBMSTYPE = UNIVERSE HOST = 10.0.0.3 MAXFETCHBUFF = 2 MAXFETCHCOLS = 800 NETWORK = TCP/IP SERVICE = uvserver Can anybody help me. Tanks. Cisar Riba Spain. --- u2-users mailing list [EMAIL PROTECTED] http://www.u2ug.org/listinfo/u2-users
Re: [U2] UniOleDB With Crystal Reports
Eric, Think about what OleDB has to do. Then think about the standard multivalue application. Finally think what would happen to OleDB if you designed and implemented say a SQL server database using the same file structures. It would die. Relational databases that return row sets (like OleDB) are predicated on the fact that the database is highly normalized. That does not only mean that the data is 2 dimensional - it means that the tables are reduced to such an extent that each table contains only the minimal number of columns. Lots of tables, few columns. Since OleDB looks at each table, this means that the amount of data retrieved is kept to a minimum. Multivalue databases, on the other hand, frequently contain files with many hundreds of fields per record. This is not a bad thing - in fact it is part of the advantage of multivalue - but it does not fit well with record set technologies like OleDB. So the problem is not realy with OleDB or with the IBM implementation of OleDB : it is with trying to apply OleDB to existing file structures that are just not designed with that style of data presentation in mind. Create a reporting account with the data reformatted, and you will probably get a lot further. As for open standards, watch out for web services. These are the new open standard for access: and this is where multivalue databases like UniVerse can score highly, both at the functional and record set levels: the latter because of the near match between XML and multivalued data (see the TOXML keyword in UniVerse SQL and RetrieVe for example) and functionally because of the strength of the run machine built into the database. So don't give up hope. (though you might still want to buy mvQuery) Oh and by the way OleDB is superior to ODBC. That's the nature of the protocol: cleaner, leaner, less to heavy. But the documentation sucks. Brian I have seen a couple of posts previously on the list where people suggest that UniOleDB is superior to ODBC. From what I am hearing it would seem that this is not the case and furthermore both the implementation of ODBC and OLEDB under UniVerse are poorly implemented features with functionality issues which undermine the feasibility of using either solution in a large site (note I refer to large sites specifically as I am sure the solutions would serve the needs of SMEs adequately) I can understand no improvements being made to ODBC connectivity as this is clearly not the way forward for Microsoft but if IBM do not improve OleDB functionality, it is one more concession to the benefit of competing platforms and solutions. Am I worrying unnecessarily or should I abandon all hope of ever achieving open database connectivity with UniVerse without the use of third party tools such as MVQuery? Cheers Eric -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Nick Southwell Sent: 14 May 2004 10:47 To: [EMAIL PROTECTED] Subject: RE: [U2] UniOleDB With Crystal Reports Worth mentioning that we have implemented an OLEDB solution, driver version 1.4.3 against Unidata 5.2 and have discovered that the driver is not capable of concurrent execution, more specifically it's the unirpc service which serialises all requests. Cheers Nick -Original Message- From: Bryan Haglund [mailto:[EMAIL PROTECTED] Sent: 13 May 2004 18:07 To: [EMAIL PROTECTED] Subject: Re: [U2] UniOleDB With Crystal Reports Eric, The first thing you need to do is to add your specific OLE connection using the UCI Config Editor. The minimum requirements are: DBMSTYPEUNIVERSE NETWORKTCP/IP SERVICEservice name (uvserver) HOST ip address used. Note that for the host, there are certain configurations that will not work with 'localhost' or '127.0.0.1' - as such, it is best to specify the specific host, such as 'uvserver.foo.com' or '172.55.122.3' Next, in Crystal Reports, you need to expand the 'More Data Sources' from the Data Explorer dialog box, then expand the 'Active Data', then expand the 'Active Data (ADO)'. If nothing is set up, you are then prompted to select a data source. The default is 'ODBC (ADO)' - change this by clicking on the radio button for 'ADO and OLE DB'. The connection string box is then no longer grayed out. Click on the 'Build' button to have the specific string built for you. Under the 'Provider' tab, select the 'UniOLEDB Provider' and click 'Next' For the 'Data Source', enter the name of the OLE connection you saved in the UCI Config Editor. Specify a user name and password, and click on the 'Test Connection' button. The test should come back ok. You can then use this to access the data. On the downside, some systems have a performance issue with OLE DB where ODBC works fast
RE: [U2] UniOleDB With Crystal Reports
Many thanks to everyone for their responses - I have now established a connection successfully. I have seen a couple of posts previously on the list where people suggest that UniOleDB is superior to ODBC. From what I am hearing it would seem that this is not the case and furthermore both the implementation of ODBC and OLEDB under UniVerse are poorly implemented features with functionality issues which undermine the feasibility of using either solution in a large site (note I refer to large sites specifically as I am sure the solutions would serve the needs of SMEs adequately) I can understand no improvements being made to ODBC connectivity as this is clearly not the way forward for Microsoft but if IBM do not improve OleDB functionality, it is one more concession to the benefit of competing platforms and solutions. Am I worrying unnecessarily or should I abandon all hope of ever achieving open database connectivity with UniVerse without the use of third party tools such as MVQuery? Cheers Eric -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Nick Southwell Sent: 14 May 2004 10:47 To: [EMAIL PROTECTED] Subject: RE: [U2] UniOleDB With Crystal Reports Worth mentioning that we have implemented an OLEDB solution, driver version 1.4.3 against Unidata 5.2 and have discovered that the driver is not capable of concurrent execution, more specifically it's the unirpc service which serialises all requests. Cheers Nick -Original Message- From: Bryan Haglund [mailto:[EMAIL PROTECTED] Sent: 13 May 2004 18:07 To: [EMAIL PROTECTED] Subject: Re: [U2] UniOleDB With Crystal Reports Eric, The first thing you need to do is to add your specific OLE connection using the UCI Config Editor. The minimum requirements are: DBMSTYPEUNIVERSE NETWORKTCP/IP SERVICEservice name (uvserver) HOST ip address used. Note that for the host, there are certain configurations that will not work with 'localhost' or '127.0.0.1' - as such, it is best to specify the specific host, such as 'uvserver.foo.com' or '172.55.122.3' Next, in Crystal Reports, you need to expand the 'More Data Sources' from the Data Explorer dialog box, then expand the 'Active Data', then expand the 'Active Data (ADO)'. If nothing is set up, you are then prompted to select a data source. The default is 'ODBC (ADO)' - change this by clicking on the radio button for 'ADO and OLE DB'. The connection string box is then no longer grayed out. Click on the 'Build' button to have the specific string built for you. Under the 'Provider' tab, select the 'UniOLEDB Provider' and click 'Next' For the 'Data Source', enter the name of the OLE connection you saved in the UCI Config Editor. Specify a user name and password, and click on the 'Test Connection' button. The test should come back ok. You can then use this to access the data. On the downside, some systems have a performance issue with OLE DB where ODBC works faster, but ODBC has an upper limit of around 160K-170K records on some systems. I have not been able to find much in the way of documentation from IBM that addresses how to tune the performance of OLE DB. Hope this helps! Bryan Haglund Haglund Consulting Inc. - Original Message - From: "Eric Cox" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, May 13, 2004 8:46 AM Subject: [U2] UniOleDB With Crystal Reports > All, > > Has anyone had any luck connecting Crystal Reports to a U2 database > using OleDB? I'm trying it here and keep getting the message 'cannot > connect to non U2 databases' (I have UniVerse and SQL Server installed > but I'm using the UniOleDB Provider) - ODBC connectivity works fine but > I want to use OleDB. > > Any help or thoughts as always, greatly appreciated. > > Regards > > Eric > > --- > Outgoing mail is certified Virus Free. > Checked by AVG anti-virus system (http://www.grisoft.com). > Version: 6.0.677 / Virus Database: 439 - Release Date: 04/05/2004 > --- > u2-users mailing list > [EMAIL PROTECTED] > http://www.u2ug.org/listinfo/u2-users --- u2-users mailing list [EMAIL PROTECTED] http://www.u2ug.org/listinfo/u2-users This correspondence is confidential and is solely for the intended recipient(s). If you are not the intended recipient, you must not use, disclose, copy, distribute or retain this message or any part of it. If you are not the intended recipient please delete this correspondence from your system and notify the sender immediately. No warranty is given that this correspondence is free from any virus. In keeping with good computer practice, you should ensure that it is actually virus free. E-mail messages may be subject to delays, non-delivery and unaut
RE: [U2] UniOleDB With Crystal Reports
Worth mentioning that we have implemented an OLEDB solution, driver version 1.4.3 against Unidata 5.2 and have discovered that the driver is not capable of concurrent execution, more specifically it's the unirpc service which serialises all requests. Cheers Nick -Original Message- From: Bryan Haglund [mailto:[EMAIL PROTECTED] Sent: 13 May 2004 18:07 To: [EMAIL PROTECTED] Subject: Re: [U2] UniOleDB With Crystal Reports Eric, The first thing you need to do is to add your specific OLE connection using the UCI Config Editor. The minimum requirements are: DBMSTYPEUNIVERSE NETWORKTCP/IP SERVICEservice name (uvserver) HOST ip address used. Note that for the host, there are certain configurations that will not work with 'localhost' or '127.0.0.1' - as such, it is best to specify the specific host, such as 'uvserver.foo.com' or '172.55.122.3' Next, in Crystal Reports, you need to expand the 'More Data Sources' from the Data Explorer dialog box, then expand the 'Active Data', then expand the 'Active Data (ADO)'. If nothing is set up, you are then prompted to select a data source. The default is 'ODBC (ADO)' - change this by clicking on the radio button for 'ADO and OLE DB'. The connection string box is then no longer grayed out. Click on the 'Build' button to have the specific string built for you. Under the 'Provider' tab, select the 'UniOLEDB Provider' and click 'Next' For the 'Data Source', enter the name of the OLE connection you saved in the UCI Config Editor. Specify a user name and password, and click on the 'Test Connection' button. The test should come back ok. You can then use this to access the data. On the downside, some systems have a performance issue with OLE DB where ODBC works faster, but ODBC has an upper limit of around 160K-170K records on some systems. I have not been able to find much in the way of documentation from IBM that addresses how to tune the performance of OLE DB. Hope this helps! Bryan Haglund Haglund Consulting Inc. - Original Message - From: "Eric Cox" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, May 13, 2004 8:46 AM Subject: [U2] UniOleDB With Crystal Reports > All, > > Has anyone had any luck connecting Crystal Reports to a U2 database > using OleDB? I'm trying it here and keep getting the message 'cannot > connect to non U2 databases' (I have UniVerse and SQL Server installed > but I'm using the UniOleDB Provider) - ODBC connectivity works fine but > I want to use OleDB. > > Any help or thoughts as always, greatly appreciated. > > Regards > > Eric > > --- > Outgoing mail is certified Virus Free. > Checked by AVG anti-virus system (http://www.grisoft.com). > Version: 6.0.677 / Virus Database: 439 - Release Date: 04/05/2004 > --- > u2-users mailing list > [EMAIL PROTECTED] > http://www.u2ug.org/listinfo/u2-users --- u2-users mailing list [EMAIL PROTECTED] http://www.u2ug.org/listinfo/u2-users This correspondence is confidential and is solely for the intended recipient(s). If you are not the intended recipient, you must not use, disclose, copy, distribute or retain this message or any part of it. If you are not the intended recipient please delete this correspondence from your system and notify the sender immediately. No warranty is given that this correspondence is free from any virus. In keeping with good computer practice, you should ensure that it is actually virus free. E-mail messages may be subject to delays, non-delivery and unauthorised alterations therefore, information expressed in this message is not given or endorsed by Open and Direct Group Limited unless otherwise notified by our duly authorised representative independent of this message. Open and Direct Group Limited is a limited company registered in United Kingdom under number 4390810 whose registered office is at 10 Norwich Street, London, EC4A 1BD --- u2-users mailing list [EMAIL PROTECTED] http://www.u2ug.org/listinfo/u2-users
Re: [U2] UniOleDB With Crystal Reports
I'd sure like to see some documentation that would help address performance when selecting large amounts of data. Frankly, you are unlikely to see great performance from UniOleDB when reporting with most applications. As a minimum, I would suggest that you need to look at your data structures and possibly look at creating reporting accounts: UniOleDB does a good job but it is an uphill struggle when it has to handle 'regular' mv files containing multiple associations, lots of fields per record, lack of indexing etc. If you need OleDB reporting, you should think about things from the SQL point of view, and look at reducing your tables to the bare minimum content just as you would when designing a normalized system. After all, that is what OleDB is presenting. Also ensure you set up separate dictionaries to access the data and use the HS.ADMIN facility to build your file information cache (used though not required by OleDB) and use the HS_FILE_ACCESS to strip out any files you do not require. You may get somewhere using the SQL CALL facility, as documented in the UCI guide. This allows you to call a BASIC subroutine and run an SQLExecDirect with a native SQL command: the results can be assigned to @HSTMT and returned to OleDB as a record set. I haven't tried performance testing with this in mind, but certainly under ODBC the best way to get any sort of performance was to ship statements out to the native SQL using the NATIVE statement (not supported on OleDB). Yes, any documentation on OleDB would help also. It is extremely poor, and what little is in existence is scattered across the manual sets. I've already raised this through U2UG as some of our clients are suffering from this. Of course, you could just ditch Crystal Reports and buy mvQuery instead. Good luck, Brian This email was checked on leaving Microgen for viruses, similar malicious code and inappropriate content by MessageLabs SkyScan. DISCLAIMER This email and any attachments are confidential and may also be privileged. If you are not the named recipient, please notify the sender immediately and do not disclose the contents to any other person, use it for any purpose, or store or copy the information. In the event of any technical difficulty with this email, please contact the sender or [EMAIL PROTECTED] Microgen Information Management Solutions http://www.microgen.co.uk --- u2-users mailing list [EMAIL PROTECTED] http://www.u2ug.org/listinfo/u2-users
RE: [U2] UniOleDB With Crystal Reports
The only things I can suggest are to select on indexed fields. Try to put your static selections into the view rather then in the crystal report selection. The example would be if you only want active customers then you would have the view select them rather then do this in the crystal report selection. The 2nd thing is to use the setting in Crystal to have the server do as much work as possible on the selection. Under file, options, database tab. Select use indexes or server for speed, perform grouping on server. I have perform query asynchronously un-checked but I don't remember why. Most of the reports I've done, hide the detail line and just show the top level break line with totals. I allow drill down to each of the levels and this tends to speed up the report because it will only return what is needed to the screen. The server does all the selecting, sorting, grouping and totals and then only sends the break totals to the report. When the drill down is done then it pulls only the records for the subset. If I'm wrong about this then please feel free to correct me. I'm going mostly on what I think is happening in the background. Not based on any tracing of activity on the backend. Also if anyone can explain the advantage or disadvantage of what the asynchronous option is I would like to know if I should check this or leave it unchecked. Jeffrey Lettau ERP Systems Manager polkaudio -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bryan Haglund Sent: Thursday, May 13, 2004 1:21 PM To: [EMAIL PROTECTED] Subject: Re: [U2] UniOleDB With Crystal Reports I have had no problems with the 'test' button - with it returning and answer within 2-3 seconds. However, I too have run into issues with performance. I'd sure like to see some documentation that would help address performance when selecting large amounts of data. Bryan Haglund Haglund Consulting Inc. - Original Message - From: "Lettau, Jeff" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, May 13, 2004 10:00 AM Subject: RE: [U2] UniOleDB With Crystal Reports > I setup the uci.config file with this > > Set the name of the definition to be the same as the account name. > > DBMSTYPE UNIDATA > NETWORK TCP/IP > SERVICE udserver > HOST enter your server name in all caps > ACCOUNT enter your account name in all caps > MAXFETCHBUFF 8192 > MAXFETCHCOLS 400 > > I think all the above is case sensitive so make sure this is correct. > > When adding the data source to the Crystal report. Don't try and test > the connection. Just trust that it will work. If you try to test the > connection then it will fail and lock up the OLE DB for a while. I'm > not sure what goes on but that is what I'm seeing happen. > When setting up the connection, use the account name in both the names > under the oledb setup, in crystal reports. > > Once I learned to not hit the test connection button and just trust that > it will work then I haven't had many problems. Other then performance > for large data sets. > > Jeffrey Lettau > ERP Systems Manager > polkaudio > > -Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Eric Cox > Sent: Thursday, May 13, 2004 11:47 AM > To: [EMAIL PROTECTED] > Subject: [U2] UniOleDB With Crystal Reports > > All, > > Has anyone had any luck connecting Crystal Reports to a U2 database > using OleDB? I'm trying it here and keep getting the message 'cannot > connect to non U2 databases' (I have UniVerse and SQL Server installed > but I'm using the UniOleDB Provider) - ODBC connectivity works fine but > I want to use OleDB. > > Any help or thoughts as always, greatly appreciated. > > Regards > > Eric > > --- > Outgoing mail is certified Virus Free. > Checked by AVG anti-virus system (http://www.grisoft.com). > Version: 6.0.677 / Virus Database: 439 - Release Date: 04/05/2004 > --- > u2-users mailing list > [EMAIL PROTECTED] > http://www.u2ug.org/listinfo/u2-users > --- > u2-users mailing list > [EMAIL PROTECTED] > http://www.u2ug.org/listinfo/u2-users --- u2-users mailing list [EMAIL PROTECTED] http://www.u2ug.org/listinfo/u2-users --- u2-users mailing list [EMAIL PROTECTED] http://www.u2ug.org/listinfo/u2-users
Re: [U2] UniOleDB With Crystal Reports
I have had no problems with the 'test' button - with it returning and answer within 2-3 seconds. However, I too have run into issues with performance. I'd sure like to see some documentation that would help address performance when selecting large amounts of data. Bryan Haglund Haglund Consulting Inc. - Original Message - From: "Lettau, Jeff" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, May 13, 2004 10:00 AM Subject: RE: [U2] UniOleDB With Crystal Reports > I setup the uci.config file with this > > Set the name of the definition to be the same as the account name. > > DBMSTYPE UNIDATA > NETWORK TCP/IP > SERVICE udserver > HOST enter your server name in all caps > ACCOUNT enter your account name in all caps > MAXFETCHBUFF 8192 > MAXFETCHCOLS 400 > > I think all the above is case sensitive so make sure this is correct. > > When adding the data source to the Crystal report. Don't try and test > the connection. Just trust that it will work. If you try to test the > connection then it will fail and lock up the OLE DB for a while. I'm > not sure what goes on but that is what I'm seeing happen. > When setting up the connection, use the account name in both the names > under the oledb setup, in crystal reports. > > Once I learned to not hit the test connection button and just trust that > it will work then I haven't had many problems. Other then performance > for large data sets. > > Jeffrey Lettau > ERP Systems Manager > polkaudio > > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Eric Cox > Sent: Thursday, May 13, 2004 11:47 AM > To: [EMAIL PROTECTED] > Subject: [U2] UniOleDB With Crystal Reports > > All, > > Has anyone had any luck connecting Crystal Reports to a U2 database > using OleDB? I'm trying it here and keep getting the message 'cannot > connect to non U2 databases' (I have UniVerse and SQL Server installed > but I'm using the UniOleDB Provider) - ODBC connectivity works fine but > I want to use OleDB. > > Any help or thoughts as always, greatly appreciated. > > Regards > > Eric > > --- > Outgoing mail is certified Virus Free. > Checked by AVG anti-virus system (http://www.grisoft.com). > Version: 6.0.677 / Virus Database: 439 - Release Date: 04/05/2004 > --- > u2-users mailing list > [EMAIL PROTECTED] > http://www.u2ug.org/listinfo/u2-users > --- > u2-users mailing list > [EMAIL PROTECTED] > http://www.u2ug.org/listinfo/u2-users --- u2-users mailing list [EMAIL PROTECTED] http://www.u2ug.org/listinfo/u2-users
Re: [U2] UniOleDB With Crystal Reports
Eric, The first thing you need to do is to add your specific OLE connection using the UCI Config Editor. The minimum requirements are: DBMSTYPEUNIVERSE NETWORKTCP/IP SERVICEservice name (uvserver) HOST ip address used. Note that for the host, there are certain configurations that will not work with 'localhost' or '127.0.0.1' - as such, it is best to specify the specific host, such as 'uvserver.foo.com' or '172.55.122.3' Next, in Crystal Reports, you need to expand the 'More Data Sources' from the Data Explorer dialog box, then expand the 'Active Data', then expand the 'Active Data (ADO)'. If nothing is set up, you are then prompted to select a data source. The default is 'ODBC (ADO)' - change this by clicking on the radio button for 'ADO and OLE DB'. The connection string box is then no longer grayed out. Click on the 'Build' button to have the specific string built for you. Under the 'Provider' tab, select the 'UniOLEDB Provider' and click 'Next' For the 'Data Source', enter the name of the OLE connection you saved in the UCI Config Editor. Specify a user name and password, and click on the 'Test Connection' button. The test should come back ok. You can then use this to access the data. On the downside, some systems have a performance issue with OLE DB where ODBC works faster, but ODBC has an upper limit of around 160K-170K records on some systems. I have not been able to find much in the way of documentation from IBM that addresses how to tune the performance of OLE DB. Hope this helps! Bryan Haglund Haglund Consulting Inc. - Original Message - From: "Eric Cox" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, May 13, 2004 8:46 AM Subject: [U2] UniOleDB With Crystal Reports > All, > > Has anyone had any luck connecting Crystal Reports to a U2 database > using OleDB? I'm trying it here and keep getting the message 'cannot > connect to non U2 databases' (I have UniVerse and SQL Server installed > but I'm using the UniOleDB Provider) - ODBC connectivity works fine but > I want to use OleDB. > > Any help or thoughts as always, greatly appreciated. > > Regards > > Eric > > --- > Outgoing mail is certified Virus Free. > Checked by AVG anti-virus system (http://www.grisoft.com). > Version: 6.0.677 / Virus Database: 439 - Release Date: 04/05/2004 > --- > u2-users mailing list > [EMAIL PROTECTED] > http://www.u2ug.org/listinfo/u2-users --- u2-users mailing list [EMAIL PROTECTED] http://www.u2ug.org/listinfo/u2-users
RE: [U2] UniOleDB With Crystal Reports
I setup the uci.config file with this Set the name of the definition to be the same as the account name. DBMSTYPEUNIDATA NETWORK TCP/IP SERVICE udserver HOSTenter your server name in all caps ACCOUNT enter your account name in all caps MAXFETCHBUFF8192 MAXFETCHCOLS400 I think all the above is case sensitive so make sure this is correct. When adding the data source to the Crystal report. Don't try and test the connection. Just trust that it will work. If you try to test the connection then it will fail and lock up the OLE DB for a while. I'm not sure what goes on but that is what I'm seeing happen. When setting up the connection, use the account name in both the names under the oledb setup, in crystal reports. Once I learned to not hit the test connection button and just trust that it will work then I haven't had many problems. Other then performance for large data sets. Jeffrey Lettau ERP Systems Manager polkaudio -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Eric Cox Sent: Thursday, May 13, 2004 11:47 AM To: [EMAIL PROTECTED] Subject: [U2] UniOleDB With Crystal Reports All, Has anyone had any luck connecting Crystal Reports to a U2 database using OleDB? I'm trying it here and keep getting the message 'cannot connect to non U2 databases' (I have UniVerse and SQL Server installed but I'm using the UniOleDB Provider) - ODBC connectivity works fine but I want to use OleDB. Any help or thoughts as always, greatly appreciated. Regards Eric --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.677 / Virus Database: 439 - Release Date: 04/05/2004 --- u2-users mailing list [EMAIL PROTECTED] http://www.u2ug.org/listinfo/u2-users --- u2-users mailing list [EMAIL PROTECTED] http://www.u2ug.org/listinfo/u2-users
[U2] UniOleDB With Crystal Reports
All, Has anyone had any luck connecting Crystal Reports to a U2 database using OleDB? I'm trying it here and keep getting the message 'cannot connect to non U2 databases' (I have UniVerse and SQL Server installed but I'm using the UniOleDB Provider) - ODBC connectivity works fine but I want to use OleDB. Any help or thoughts as always, greatly appreciated. Regards Eric --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.677 / Virus Database: 439 - Release Date: 04/05/2004 --- u2-users mailing list [EMAIL PROTECTED] http://www.u2ug.org/listinfo/u2-users
