Search results for query: *

Hi Manga, Interested to know how you do it. Can you post the code?

Thanks for your replies. I just realized that application won’t run because of “ActiveX component can’t create object” error. Looks like the application can’t locate certain .dll or .ocx files used. Some says repackage the setup files, others says install MDAC download from MS. Any comments...

We have an application developed in VB5 Enterprise Edition (SP3) on a development machine with Windows 95. Apparently, we upgraded the OS to Windows 98 SE. The development environment was remained intact. However, the compiled exe works fine on new development machine (Windows 98), however, it...

hi, I recently migrating a VB5 (RDO) project to VB6 (ADO). I noticed this SourceTable property in RDO return the name of underlying table of the data for an rdoColumn object. Is there an equivalent of SourceTable property in ADO and if not any alternative way in ADO to get the based table name...

Hi I did that and I believe sqexplain.out is in the /HOME dir. Just wonder why the result of SET EXPLAIN ON doesn't append into the file when it is running from SQL Editor. I tried in Unix, it worked. Could it be a bug in IUS 9.14 (on Irix 6.4) or SQL Editor 4.0 (on Win 98 client machine)?

Hi Thanks for the note. So in my case, i am in the second scenario. I have a home dir defined but when I try running SQL stmt with SET EXPALIN ON from SQL Editor on Win 98 machine. I don't see the result of the SET EXPLAIN being stored in the sqexplain.out? Did i missed out anything?

Anybody know where the default path for the sqexplain.out when the SQL stmt is run from SQL Editor?

Hi, I discovered that when a SELECT stmt with a ORDER By clause in informix will always sort the results from capital "A" to "Z" then all lower-case "a" to "z". But ideally, what I wants is the results from A to Z regardless of (upper or lower) case. I...

Hi Schaefer, Thanks for your advice. As for Q3, I found out from a book that say ontape -a always overwrite the same logical log file (in disk) whenever the command is performed. I tried that and it really does. That raise to another question, how do i prevent the logical log file from...

I have a few questions about the logical files backup. 1) In the IDS200 archive and backup manual it says that IDS does not check the tape device when u specify TAPEDEV & LTAPEDEV. Infomrix recommends verify the the tape device can read the block size specify in TAPEDEV & LTAPEDEV for a...

Of course you can. What i have done is that i installed the ODBC driver for informix and start cystal report in PC and create a new report by selecting the SQL/ODBC in the Report Type and Data Type in custom option. Select the DSN that has been set up earlier in the Server Log prompt. Select the...

hi Jane, Thanks for the reply. we are using cooked files for chunks. I think u misunderstood the tar backup i mentioned. The backup process is first using "unload...select..." for every table in our DB into a text file. Then, come the tar command to backup of all the regular unix...

How do i know whether I'm using the raw device or unix cooked files? I wasn't the one that set up the DB server and the person has left.

Hi jbcamel, I run into problem of tables have too many extents. How could i rebuild these tables with acceptable extents? Btw, how do you come up with statement of 8 extents per table is reasonable? I'm running IUS 9.14 on Irix 6.5

I do not know hoctro run on what OS However, I encounter the same error message too when i tried to start to create a new instance and i am sure it is not due to the permission . I am running informix engine run on redhat 6.2, help please???

Hi, I just come to learn about administration of Informix DB. Wish you can give me some good advice. I have many large tables (>50MB) in my Informix IUS 9.14 DB (running on Irix 6.5) which all has extent of 16 pages (the default) when these tables are first created. So I think these tables...

Hi there, I'm new to administration of Informix Universal Server. I really need precise advice from you ppl out there. I'm using the normal unix tar compress (all files in the server) as the backup after a data dump (to files) process from all the tables in the database. Will that be...

How do I extract data in a Visual Basic client program (using RDO) from informix database and dump them into a file using unload in SQL statement e.g. "Unload to 'c:\mydata.txt' select......". I have tried many times, but there is always a complaint saying "a syntax error in SQL...