my paradox is : sybase or paradox??

[psteja2000]

ok, here is what I was dumped with. A hard drive which supposedly contains an application which uses sybase sqlanywhere 5.0. I never worked on that before.

After a lot of trotting onthe net and forums, finally I can now get teh sybase database up and running and the application works fine. I was even able to extract the sql structure and data etc.

The application contains images, but I found no image directories. Finally I found that the images are stored in a table (long binary).

After further messing around, I found that the table doesn't exist in the same directory as the rest of the tables.

Further, I found that the this table (which has 500MB of pic data- it's .mb file said so)consists of .xgo,.ygo files too. This is the only table to have these extra files.

More trotting on the net offered me that the table is a paradox table. No clue what it is, so more of trotting.

I have datadirect odbc drivers and using coldfusion I tried to connect to the table and atleast retrieve non BLOB fields.

WhenI create a dsn in coldfusion to the odbc dsn, it says ok. When I do a select count(*) on the table, it returns correct result. But when I do any other select, like select field names, It comes up with "Too Few Parameters. Expected N"

What the hell is that msg? I am guessing my ODBC driver is not proper??

WHAT DO I DO NOW (


Can anyone plz throw some light??

Oh I forgot, I have no clue which version of paradox that table is in. All I have is .db,.mb,.px,.xgo,.ygo files for this table.

For all the other tables, I have .db,.mb,.px per table. So one more question.. I know it is sybase database but where does paradox fit in ??????


regards,
Teja

 

[TonyMcGuire]

The .db, .mb, .px, .xg#, yg# tell me that the table is Paradox. NOT SyBase.

Likely it would be instant access of that data if you had a fairly recent copy of Paradox the application. Then you could save/export the data, and the images, for use in another program.

It may be that you are trying to use an ODBC driver that won't access the table level of the tables you have.

Have you asked this on a ColdFusion forum?

Tony McGuire

http://www.thedbcommunity.com

"It's not about having enough time. It's about priorities.

 

[psteja2000]

Thanks Tony for the reply.

I realized that it is a paradox table, little late. But anyway the rest of the database is in sybase and I found no paradox related stuff on the server. ALso this table alone is in a diff directory, so I am assuming the main sybase database links to this paradox table (there is a table in the sybase database with the same name, but hwen I do a dump/backup, it returns 0 rows).

This application is no way recent. It is very old, dating back to '99. That is when it is installed and nothing was ever changed.

Yes I realized that the right driver is lacking. I dont' even know the version of the paradox format that the table has, so it is kinda difficult for me to get teh right driver. I tried with microsoft paradox driver, it recognizes the rest of the fields except for the image fields. I tried the DataDirect driver for paradox, it doesn't load at all, don't know y. Looks like as of now, my options are none.
Any ideas??

regards,
Teja

 

[TonyMcGuire]

Get Paradox.

For a one-up situation like you have, it probably isn't worth spending $500 worth of your time to get it working when a $40 or so copy of Paradox would let you get everything done (and converted to a new format, I'm guessing) in a few minutes.

Course, you could also send the files to someone who has Paradox and they could convert the data to ASCII and images to bmp or jpeg and send them back.

At least, I'm guessing you just want the data out of the Paradox tables to convert to another format.

Or what is your goal exactly???

Tony McGuire

http://www.thedbcommunity.com

"It's not about having enough time. It's about priorities.

 

[psteja2000]

MY only goal is to get that images table (paradox) into ascii format and get all the images as files. What you said is true. I already wasted lot of hours on this. no point.

regards,
Teja