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
