HELP !!! Open Database with uppercase names

Hello, We have an informixserver with an the name ol_itaLia and a database called ncc. We could not open this DB with "dbname =ncc@ol_itaLia" "Exec SQL database $dbname" It works if the servername is ol_italia without a upper L and "Exec SQL database ncc@ol_italia". We use IDS 7.3. The error code is 25555 What can we do ? Thanxs Thorsten ------------------------------------------------------ Thorsten Geelhaar Telefon: +49 231 5599 106 Dr. Materna GmbH Fax : +49 231 5599 100 Vosskuhle 37 e-mail : Thorsten.Geelhaar@materna.de D-44141 Dortmund GERMANY ------------------------------------------------------

> We have an informixserver with an the name ol_itaLia > and a database called ncc. > We could not open this DB with > "dbname =ncc@ol_itaLia" > "Exec SQL database $dbname" Just a guess: does your $INFORMIXDIR/etc/sqlhosts contain the lower name ol_italia ? If so, change it to ol_itaLia. Hth, Chris

Christian Brauer wrote: > > > We have an informixserver with an the name ol_itaLia > > and a database called ncc. > > We could not open this DB with > > "dbname =ncc@ol_itaLia" > > "Exec SQL database $dbname" > > Just a guess: does your $INFORMIXDIR/etc/sqlhosts contain > the lower name ol_italia ? If so, change it to ol_itaLia. > > Hth, > > Chris No they are indentical -- Nach Paragraph 28 Abs. 3 des Bundesdatenschutzgesetz widerspreche ich der Nutzung oder Uebermittlung meiner Daten fuer Zwecke der Werbung oder der Markt- oder Meinungsforschung. ------------------------------------------------------ Thorsten Geelhaar Telefon: +49 231 5599 106 Dr. Materna GmbH Fax : +49 231 5599 100 Vosskuhle 37 e-mail : Thorsten.Geelhaar@materna.de D-44141 Dortmund GERMANY ------------------------------------------------------