RE: [U2] UniOleDB Configuration

2004-05-21 Thread Cesar Riba
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

2004-05-17 Thread Cesar Riba
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] UniOleDB Configuration

2004-05-14 Thread Cesar Riba
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


RE: [U2] UniOleDB Configuration

2004-05-14 Thread Cesar Riba
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