Eric, The first thing you need to do is to add your specific OLE connection using the UCI Config Editor. The minimum requirements are: DBMSTYPE UNIVERSE NETWORK TCP/IP SERVICE service 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
