dotnet clr: Hi everybody,
Does anyone know how to read a microfocus COBOL file from .NET ?
I have a requirement where i need to read these files and store it in a
sql-server database.

I will really apperciate if anyone can help me on this.

Thanks





*** Sent via Devdex http://www.devdex.com ***

I used Transoft U/SQL with good results. Basically it's an ODBC driver, so
you shouldn't have any problem.

http://www.transoft.com/products/ts_sqlgate.htm

Hi,
Thanks a lot for ur reply.Is there any way to access the Micro
focus cobol file through code using C# rather than using a tool. I wud
reaaly apperciate ur help.

Thanks a lot.



*** Sent via Devdex http://www.devdex.com ***

Hi Ponti,
Thanks a lot for ur response. Since our software
needs to be installed on the client machine would it mean that i need to
install the Transoft tool on every client machine?
My requirement is that i need to read data from a microfocus cobol file
during the installation of the software on the client machine and store
it in local MSDE(Microsoft Desktop Engine )database. I think we need to
write code to do that. Am i right in saying so?Please let me know your
valuable thoughts on this.

Once again thanks a lot!



*** Sent via Devdex http://www.devdex.com ***

If you can find the documentation about the file format of the Microfocus
COBOL files, then I guess you can write your own class in C# to manage these
files. Personally I think that is cheaper to use the Transoft U/SQL ODBC
driver than writing the whole thing yourself.

It's a little problematic in your situation because you are looking to do
this as part of the installation process. You would have to install the
Transoft ODBC driver, configure the data source programmatically, and do
your import in MSDE. Then remove data source and ODBC driver when you're
done.

I think that in your case it would be better to find a different approach,
like a COM object to read the COBOL files directly, or some kind of
conversion utility that would convert from MicroFocus to a CSV file that you
can then import into MSDE.

Unfortunately I don't have any specific product to suggest, but try Google.

Hello everyone,
Does any one whether there exists any native .NET drivers for
ISAM files? Any help will be apperciated.

Thanks a lot.


*** Sent via Devdex http://www.devdex.com ***

Jet ?

[quoted text, click to view]

Hi Gabriele, do you have some examples of code (VB.net?) you used to
connect to the Transoft ODBC data source?

Did you use the OdbcDataAdapter, and if so, what was your Connection
String?

Thanks,

John

*** Sent via Developersdex http://www.developersdex.com ***