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. vaquer 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
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
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 = 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 Configuration
Clutching at straws here. What happens if you use OLEDB rather than prueba 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: prueba 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? OLEDB 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
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] localud DBMSTYPE = UNIDATA network = TCP/IP service = udserver host = localhost vaquer 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 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 = 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