Script to import Avaya Informix database

Hello -

Please HELP! I need to use information from four tables which are from our
phone system (Avaya system; database type = Informix).

I've tried to import the info via ODBC (install disk given to us by Avaya,
but I need to do it on a Windows Server 2003 server and I am getting an
oledb_lt.lic (licensing) error that they cannot resolve.

In the end, I need to import this into a Sql Server database and schedule
daily imports.

Thought I could import it directly into Sql Server via BIDS and schedule it
through Agent, but to no avail.

I then tried to even get the info out in the form of a text file, but again
to no avail.

My next thought was perhaps a VB script may be the answer, but I don't know
how to do that.

Any help anyone can give me will be REALLY appreciated! Naturally, this is
a rush job . . .

--
Sheldon

McKirahan
Wed Jun 25 20:05:54 CDT 2008

"Sheldon" <Sheldon@discussions.microsoft.com> wrote in message
news:86966415-31F7-4B8C-959F-ED57C5F2D9E8@microsoft.com...
> Hello -
>
> Please HELP! I need to use information from four tables which are from
our
> phone system (Avaya system; database type = Informix).
>
> I've tried to import the info via ODBC (install disk given to us by Avaya,
> but I need to do it on a Windows Server 2003 server and I am getting an
> oledb_lt.lic (licensing) error that they cannot resolve.
>
> In the end, I need to import this into a Sql Server database and schedule
> daily imports.
>
> Thought I could import it directly into Sql Server via BIDS and schedule
it
> through Agent, but to no avail.
>
> I then tried to even get the info out in the form of a text file, but
again
> to no avail.
>
> My next thought was perhaps a VB script may be the answer, but I don't
know
> how to do that.
>
> Any help anyone can give me will be REALLY appreciated! Naturally, this
is
> a rush job . . .

A Google of "oledb_lt.lic" found this:
http://www.avayausers.com/showthread.php?p=43511

What connection string are you using?
http://www.devlist.com/ConnectionStringsPage.aspx

Is the database password-protected and do you have the password?

hb21l6
Fri Jun 27 08:13:34 CDT 2008


"Sheldon" <Sheldon@discussions.microsoft.com> wrote in message
news:86966415-31F7-4B8C-959F-ED57C5F2D9E8@microsoft.com...
> Hello -
>
> Please HELP! I need to use information from four tables which are from
> our
> phone system (Avaya system; database type = Informix).
>
> I've tried to import the info via ODBC (install disk given to us by Avaya,
> but I need to do it on a Windows Server 2003 server and I am getting an
> oledb_lt.lic (licensing) error that they cannot resolve.
>
> In the end, I need to import this into a Sql Server database and schedule
> daily imports.
>
> Thought I could import it directly into Sql Server via BIDS and schedule
> it
> through Agent, but to no avail.
>
> I then tried to even get the info out in the form of a text file, but
> again
> to no avail.
>
> My next thought was perhaps a VB script may be the answer, but I don't
> know
> how to do that.
>
> Any help anyone can give me will be REALLY appreciated! Naturally, this
> is
> a rush job . . .
>
> --
> Sheldon
>

Seldon,

I've worked with Informaix, Avaya systems before.
The ODBC connection should work fine, go back to Avaya and ask them for
assistance.

You'd still need to the connection components ( e.g. DLL's) to communicate
from Windows to the Informix database, so Scripting is out the question
until its resolved..

Dave