Re: oledb & locale problem
Posted in 2006
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