Shlomi,
I installed Terdata software packages like cli, teragss, and tdicu. I
edited windows hosts file.
Now I got the following error.
dmake.exe: makefile: line 871: Error: -- Missing targets or attributes in
rule
The following perl script is used to connect to SQL server database using
DBI and DBD::ODBC modules.
*my *$dbh = DBI->*connect*("DBI:ODBC:Driver={SQL
Server};Server=$db_instance;Database=$db_name;UID=$db_user;PWD=$db_pass") or
*die*("\n\nCONNECT ERROR:\n\n$DBI::errstr");
Using ODBC I am getting the following error.
DBI
connect('Driver={Teradata};Server=edwdevcop1;Database=HYP_STG_DEV;UID=hypshared;PWD=******','',...)
failed: [Teradata][ODBC Teradata Driver] Not enough information to log on
(SQL-28000) at Teradata_test.pl line 46
Any help is appreciated. Thank you.
On Fri, Sep 23, 2011 at 4:11 AM, Shlomi Fish <shlo...@shlomifish.org> wrote:
> Hi,
>
> On Wed, 21 Sep 2011 11:30:10 -0400
> Perl developer <perldevelopm...@gmail.com> wrote:
>
> > Thanks for the reply. How to install the headers?
> >
>
> you probably need to install the Teradata development package. Its
> installation
> procedure should be documented somewhere there. It's probably here:
>
> http://downloads.teradata.com/download
>
> Regards,
>
> Shlomi Fish
>
> > On Wed, Sep 21, 2011 at 11:23 AM, Shlomi Fish <shlo...@shlomifish.org
> >wrote:
> >
> > > On Wed, 21 Sep 2011 09:31:01 -0400
> > > Perl developer <perldevelopm...@gmail.com> wrote:
> > >
> > > > All,
> > > > I need help regarding install of CPAN modules in strawberry perl.
> > > >
> > > > I have a question about Perl connectivity to Teradata. Is it the
> correct
> > > > email address?
> > > >
> > > > I have been using Active Perl 5.12 on Windows xp since one year. I
> tried
> > > > installing a perl module from CPAN
> > > > and I got errors while performing the following steps.
> > > > perl makefile.pl
> > > > n|d(make)
> > > > n|d(make) install
> > > >
> > > > Recently I downloaded strawberry perl 5.12.3.0 and download CPAN
> module
> > > > named DBD::Teradata-1.52.
> > > > Using cpan client, I could download cpan module(get command).
> > > > Files related to the module are created at
> > > > C:\strawberry\cpan\build\DBD-Teradata-1.52-tLHaX2
> > > >
> > > > But I get errors while installing them using
> > >
> > > > Teradata.xs:5:22: coptypes.h: No such file or directory
> > > > Teradata.xs:6:21: dbcarea.h: No such file or directory
> > > > Teradata.xs:7:20: coperr.h: No such file or directory
> > > > Teradata.xs:8:20: parcel.h: No such file or directory
> > >
> > > You're missing some headers. You need to install them.
> > >
> > > Regards,
> > >
> > > Shlomi Fish
> > >
> > > > Teradata.xs:34: error: syntax error before "DBCAREA"
> > > > Teradata.xs:34: warning: no semicolon at end of struct or union
> > > > Teradata.xs:35: warning: data definition has no type or storage class
> > > > Teradata.xs: In function `XS_DBD__Teradata__Cli_tdxs_set_debug':
> > > > Teradata.xs:57: error: syntax error before "dbcp"
> > > > Teradata.xs:58: error: `dbcp' undeclared (first use in this function)
> > > > Teradata.xs:58: error: (Each undeclared identifier is reported only
> once
> > > > Teradata.xs:58: error: for each function it appears in.)
> > > > Teradata.xs: In function `XS_DBD__Teradata__Cli_tdxs_init_dbcarea':
> > > > Teradata.xs:67: error: syntax error before "dbc_ctx"
> > > > Teradata.xs:68: error: `DBCAREA' undeclared (first use in this
> function)
> > > > Teradata.xs:68: error: `dbcp' undeclared (first use in this function)
> > > > Teradata.xs:72: error: `dbc_ctx' undeclared (first use in this
> function)
> > > > Teradata.xs:72: error: syntax error before ')' token
> > > > Teradata.xs:78: error: `EM_OK' undeclared (first use in this
> function)
> > > > Teradata.xs: In function `XS_DBD__Teradata__Cli_tdxs_get_connection':
> > > > Teradata.xs:101: error: syntax error before "dbc_ctx"
> > > > Teradata.xs:102: error: `DBCAREA' undeclared (first use in this
> function)
> > > > Teradata.xs:102: error: `dbcp' undeclared (first use in this
> function)
> > > > Teradata.xs:102: error: `dbc_ctx' undeclared (first use in this
> function)
> > > > Teradata.xs:149: error: `DBFCON' undeclared (first use in this
> function)
> > > > Teradata.xs:156: error: `EM_OK' undeclared (first use in this
> function)
> > > > Teradata.xs:176: error: `DBFFET' undeclared (first use in this
> function)
> > > > Teradata.xs:184: error: `PclLSN' undeclared (first use in this
> function)
> > > > Teradata.xs:188: error: `PclSUCCESS' undeclared (first use in this
> > > function)
> > > > Teradata.xs:191: error: `PclFAILURE' undeclared (first use in this
> > > function)
> > > > Teradata.xs:192: error: `PclERROR' undeclared (first use in this
> > > function)
> > > > Teradata.xs:204: error: `PclENDSTATEMENT' undeclared (first use in
> this
> > > > function
> > > > )
> > > > Teradata.xs:205: error: `PclENDREQUEST' undeclared (first use in this
> > > > function)
> > > > Teradata.xs:213: error: `REQEXHAUST' undeclared (first use in this
> > > function)
> > > > Teradata.xs:234: error: `DBFERQ' undeclared (first use in this
> function)
> > > > Teradata.xs: In function
> `XS_DBD__Teradata__Cli_tdxs_get_tdat_release':
> > > > Teradata.xs:256: error: `dbc_ctx' undeclared (first use in this
> function)
> > > > Teradata.xs:256: error: syntax error before ')' token
> > > > Teradata.xs:257: error: `DBCAREA' undeclared (first use in this
> function)
> > > > Teradata.xs:257: error: `dbcp' undeclared (first use in this
> function)
> > > > Teradata.xs: In function `XS_DBD__Teradata__Cli_tdxs_cleanup':
> > > > Teradata.xs:272: error: syntax error before "dbc_ctx"
> > > > Teradata.xs:273: error: `DBCAREA' undeclared (first use in this
> function)
> > > > Teradata.xs:273: error: `dbcp' undeclared (first use in this
> function)
> > > > Teradata.xs:273: error: `dbc_ctx' undeclared (first use in this
> function)
> > > > Teradata.xs:277: error: `DBFDSC' undeclared (first use in this
> function)
> > > > Teradata.xs:280: error: `EM_OK' undeclared (first use in this
> function)
> > > > Teradata.xs: In function `XS_DBD__Teradata__Cli_tdxs_send_request':
> > > > Teradata.xs:302: error: syntax error before "dbc_ctx"
> > > > Teradata.xs:303: error: `DBCAREA' undeclared (first use in this
> function)
> > > > Teradata.xs:303: error: `dbcp' undeclared (first use in this
> function)
> > > > Teradata.xs:303: error: `dbc_ctx' undeclared (first use in this
> function)
> > > > Teradata.xs:334: error: `DBFIRQ' undeclared (first use in this
> function)
> > > > Teradata.xs:337: error: `EM_OK' undeclared (first use in this
> function)
> > > > Teradata.xs: In function
> `XS_DBD__Teradata__Cli_tdxs_wait_for_response':
> > > > Teradata.xs:358: error: `EM_OK' undeclared (first use in this
> function)
> > > > Teradata.xs: In function `XS_DBD__Teradata__Cli_tdxs_get_response':
> > > > Teradata.xs:384: error: `dbc_ctx' undeclared (first use in this
> function)
> > > > Teradata.xs:384: error: syntax error before ')' token
> > > > Teradata.xs:385: error: `DBCAREA' undeclared (first use in this
> function)
> > > > Teradata.xs:385: error: `dbcp' undeclared (first use in this
> function)
> > > > Teradata.xs:413: error: `DBFFET' undeclared (first use in this
> function)
> > > > Teradata.xs:414: error: `EM_OK' undeclared (first use in this
> function)
> > > > Teradata.xs:426: error: `EM_NODATA' undeclared (first use in this
> > > function)
> > > > Teradata.xs: In function `XS_DBD__Teradata__Cli_tdxs_end_request':
> > > > Teradata.xs:447: error: syntax error before "dbc_ctx"
> > > > Teradata.xs:448: error: `DBCAREA' undeclared (first use in this
> function)
> > > > Teradata.xs:448: error: `dbcp' undeclared (first use in this
> function)
> > > > Teradata.xs:448: error: `dbc_ctx' undeclared (first use in this
> function)
> > > > Teradata.xs:449: error: `EM_OK' undeclared (first use in this
> function)
> > > > Teradata.xs:455: error: `DBFERQ' undeclared (first use in this
> function)
> > > > Teradata.xs: In function `XS_DBD__Teradata__Cli_tdxs_abort_request':
> > > > Teradata.xs:474: error: syntax error before "dbc_ctx"
> > > > Teradata.xs:475: error: `DBCAREA' undeclared (first use in this
> function)
> > > > Teradata.xs:475: error: `dbcp' undeclared (first use in this
> function)
> > > > Teradata.xs:475: error: `dbc_ctx' undeclared (first use in this
> function)
> > > > Teradata.xs:476: error: `EM_OK' undeclared (first use in this
> function)
> > > > Teradata.xs:482: error: `DBFABT' undeclared (first use in this
> function)
> > > > Teradata.xs: In function `XS_DBD__Teradata__Cli_tdxs_test_leak':
> > > > Teradata.xs:504: error: `dbc_ctx' undeclared (first use in this
> function)
> > > > Teradata.xs:504: error: syntax error before ')' token
> > > > Teradata.xs:505: error: `DBCAREA' undeclared (first use in this
> function)
> > > > Teradata.xs:505: error: `dbcp' undeclared (first use in this
> function)
> > > > Teradata.xs:528: error: `DBFIRQ' undeclared (first use in this
> function)
> > > > Teradata.xs:530: error: `EM_OK' undeclared (first use in this
> function)
> > > > Teradata.xs:545: error: `DBFFET' undeclared (first use in this
> function)
> > > > Teradata.xs:555: error: `DBFERQ' undeclared (first use in this
> function)
> > > > dmake.exe: Error code 129, while making 'Teradata.o'
> > >
> > >
> > >
> > > --
> > > -----------------------------------------------------------------
> > > Shlomi Fish http://www.shlomifish.org/
> > > My Favourite FOSS - http://www.shlomifish.org/open-source/favourite/
> > >
> > > Beliefs are what divide people. Doubt unites them.
> > > — http://en.wikiquote.org/wiki/Peter_Ustinov
> > >
> > > Please reply to list if it's a mailing list post -
> http://shlom.in/reply .
> > >
>
>
>
> --
> -----------------------------------------------------------------
> Shlomi Fish http://www.shlomifish.org/
> Escape from GNU Autohell -
> http://www.shlomifish.org/open-source/anti/autohell/
>
> An original philosopher knows the right combination of ideas to steal.
>
> Please reply to list if it's a mailing list post - http://shlom.in/reply .
>
