Showing posts with label app. Show all posts
Showing posts with label app. Show all posts

Friday, March 9, 2012

Import data from Adaptive Server Anywhere 7 DB

My client has a custom app using a Sybase Adaptive Server Anywhere 7 DB
backend. I need to regularly extract read-only data from a couple of
tables in this database and I would have thought it would be simple to
setup a System DSN for this purpose, however I am finding it difficult
to locate an appropriate ODBC driver, without having to pay Sybase a
large fee for the privilege. I have never used any Sybase before, what
should I do?

Cheers,

StephenYou can Google for free Sybase clients/ODBC drivers, if that's what you
need, although I don't know whether or not any of them would be
suitable for you. Alternatively, look at it the other way round and ask
the client to export the data to flat files, so you can import it into
MSSQL.

Simon

Wednesday, March 7, 2012

Import Cobol files

Hi all,
I have a customer that needs to transform his old Cobol app into a VB or ASP
app.
I'm stuck here with his product listings that are all in .cob (cobol) files,
how can I import those into SQL or Excell ?
Thanks for your help
ManuYou cannot.
You will need a tool that translates the COBOL commands into VB or ASP.
There are a few companies out there that have that kind of a tool set you
might look at www.californiasoftware.com
Andrew C. Madsen
Information Architect
Harley-Davidson Motor Company
"Emmanuel Baeyens" <emmanuel.baeyens@.microplanet.be> wrote in message
news:ud3ZonlcEHA.4092@.TK2MSFTNGP10.phx.gbl...
> Hi all,
> I have a customer that needs to transform his old Cobol app into a VB or
ASP
> app.
> I'm stuck here with his product listings that are all in .cob (cobol)
files,
> how can I import those into SQL or Excell ?
> Thanks for your help
> Manu
>

Import Cobol files

Hi all,
I have a customer that needs to transform his old Cobol app into a VB or ASP
app.
I'm stuck here with his product listings that are all in .cob (cobol) files,
how can I import those into SQL or Excell ?
Thanks for your help
Manu
You cannot.
You will need a tool that translates the COBOL commands into VB or ASP.
There are a few companies out there that have that kind of a tool set you
might look at www.californiasoftware.com
Andrew C. Madsen
Information Architect
Harley-Davidson Motor Company
"Emmanuel Baeyens" <emmanuel.baeyens@.microplanet.be> wrote in message
news:ud3ZonlcEHA.4092@.TK2MSFTNGP10.phx.gbl...
> Hi all,
> I have a customer that needs to transform his old Cobol app into a VB or
ASP
> app.
> I'm stuck here with his product listings that are all in .cob (cobol)
files,
> how can I import those into SQL or Excell ?
> Thanks for your help
> Manu
>