Re: Need your help on this strange loading problem ... Thanks

Hi Jonathan, Yes, environment is the same. I have hard-coded delimiter type in my loading script. So, I believe this is not the problem. IDS version: IBM Informix Dynamic Server Version 9.40.FC7 Platform: HP-UX B.11.23 U ia64 (tc) Thanks for your help.

---------- Forwarded message ---------- From: Henry <ggk517@gmail.com> Date: 20 Sep 2006 20:49:05 -0700 Subject: Re: Need your help on this strange loading problem ... Thanks To: informix-list@iiug.org Hi Jonathan, Yes, environment is the same. I have hard-coded delimiter type in my loading script. So, I believe this is not the problem. IDS version: IBM Informix Dynamic Server Version 9.40.FC7 Platform: HP-UX B.11.23 U ia64 (tc) Thanks for your help. _______________________________________________ Informix-list mailing list Informix-list@iiug.org http://www.iiug.org/mailman/listinfo/informix-list Henry Are you using LOAD FROM ... INSERT INTO ... ? If so what happens if you run within DBACCESS? Should tell you which line it fails at then you can compare lines for similarity. Was the source still being written the first time, but complete the second? Has there been a edit on the file between the two load attempts? These may seem obvious things to check, but that is usually where most errors are !! Keith

In the previous episode, Jonathan Leffler wrote: > Henry wrote: >> I met with a strange problem. I have a script to load data from a >> text file into a table. On the first run, I hit with an error said >> that the number of columns mismatch. But, when I tried another time >> with the same source file, i received no error. Is there any >> explanation to this strange phenomenon? >> >> Error message: 846: Number of values in load file is not equal to >> number of columns. > > Was the environment exactly the same? Specifically, could DBDELIMITER > have been set one time and not the other? > > (What version? What platform?) In response, Henry wrote: > Yes, environment is the same. I have hard-coded delimiter type in my > loading script. So, I believe this is not the problem. > > IDS version: IBM Informix Dynamic Server Version 9.40.FC7 > Platform: HP-UX B.11.23 U ia64 (tc) Well, computers are generally extremely consistent. Something changed. You have a number of possibilities: * The data file * The software you are using * The database you are loading * The environment * Anything I've not yet thought of! At the moment, you are probably going to say 'none of the first four items changed', so it must be the fifth. Could someone have played merry hell with the sqlhosts file so that you are no longer playing with the database you thought you were playing with? Did you have a stray cosmic ray go past and flip a bit in your computer's memory? -- Jonathan Leffler #include <disclaimer.h> Email: jleffler@earthlink.net, jleffler@us.ibm.com Guardian of DBD::Informix v2005.02 -- http://dbi.perl.org/

Hi, i'm having some problems with oledb connection. The problem is i can't connect using oledb provider but with odbc everything is ok. our database is using a modified character set (other than en_us.8859-1). I have installed another instance with en_us.8859-1 locale. When connecting to this instance with en_us.8859-1 locale, oledb connection succeeds. i changed the client_locale and db_locale in setnet32 and datasource property of oledb connection to our production database. This time it gives an error saying: "test connection failed because of an error initializing provider. 0x80040e21" if i do not change the client_locale and db_locale in setnet32 (leave default blank) then it gives an error:"test connection failed because of an error in initializing provider. EIX000:(-23101) Unable to load locale categories." Server side : Informix IDS 7.31 Client side : IBM Informix Client SDK 2.90 TC5 i am planning to use analysis services 2005 and it only supports oledb connection. So i have to make this oledb connection work. Have you got any idea or solution for my situation? Thanks Abdullah AKOGLU Bu e-posta mesaji kisiye ozel olup, gizli bilgiler iceriyor olabilir. Eger Bu e-posta mesaji size yanlislikla ulasmissa, icerigini hic bir sekilde kullanmayiniz ve ekli dosyalari acmayiniz. Bu durumda lutfen e-posta mesajini kullaniciya geri gonderiniz ve tum kopyalarini mesaj kutunuzdan siliniz. Bu e-posta mesaji, hicbir sekilde, herhangi bir amac icin cogaltilamaz, yayinlanamaz, para karsiligi satilamaz . Bu e-posta mesaji virus koruma sistemleri ile kontrol ediliyor olsa bile virus icermedigini garanti etmez ve meydana gelebilecek zararlardan dogacak hicbir sorumlulugu kabul etmez.Bu e-posta mesajindaki gorusler Vadeli Islem ve Opsiyon Borsasi A.S.'nin goruslerini yansitmayabilir ve kurumu baglayici degildir.