RE: oledb & locale problem
Yes i have run coledbp.sql against sysmaster database before. Db version is Informix IDS 7.31 UD3 On client side i set client_locale and db_locale environment variables and make the connection tests but nothing changed. Locale setting is tr_tr.8859-9@ifix. i create a connection file on my desktop with right click-> new -> text file. And rename it : For example a.udl if you double click that file it opens the db connection dialog. On first tab page i choose provider: IBM Informix OLE DB Provider, on connection page i give data source as testdb@thales then username and password. When i click test connection button i get the error. ________________________________ From: Sheshnarayan Agrawal [mailto:shagrawal@in.ibm.com] Sent: Friday, September 22, 2006 10:52 AM To: Abdullah Akoglu Cc: informix-list@iiug.org; informix-list-bounces@iiug.org Subject: Re: oledb & locale problem I hope you ran coledbp.sql (which is under CSDK %INFOMRIXDIR%\\etc dir) against "sysmaster" database of 7.31 server. I am not aware about any such connectivity issue with CSDK 2.90.TC5 and IDS 7.31 (can you provide exact version of 7.31?). Do you have client/db locales set in your system environment other than setnet32? Can you also post your connection string and the DB locale for the database you are trying to connect? -Shesh "Abdullah Akoglu" <aakoglu@vob.org.tr> Sent by: informix-list-bounces@iiug.org 09/22/2006 01:02 PM To <informix-list@iiug.org> cc Subject oledb & locale problem 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. _______________________________________________ Informix-list mailing list Informix-list@iiug.org http://www.iiug.org/mailman/listinfo/informix-list 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.