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: > > DBMSTYPE UNIVERSE > network TCP/IP > service uvserver > host localhost > > 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. > > > > > > > > <vaquer> > > > > DBMSTYPE = UNIVERSE > > > > HOST = 10.0.0.3 > > > > ACCOUNT = \\DELL\CUENTAS\COMERCIAL > > > > USERNAME = CESAR > > > > MAXFETCHBUFF = 20000 > > > > 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 = "xxxx" > > > > > > > > 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 ------- u2-users mailing list [EMAIL PROTECTED] http://www.u2ug.org/listinfo/u2-users