Problems trying to build DBD:Oracle on Win2k

HI there,

I've been searching the forums for help on this issue, and found a few directions, but still having problems.

We have TS6.5 installed on Win2k Service Pack 4. I have followed the instructions as per the Readme http://search.cpan.org/src/PYTHIAN/DBD-Oracle-1.19/README.win32.txt. I did everything except use ActiveState install and download DBI, since TS6.5 already has DBI installed it seems.

What I did do is the following:

1. Downloaded Oracle.pm and Makefile.pl from cpan (v1.19.. could not use CPAN utility, FTP access is blocked on our network, so downloaded the two files manually)

2. Downloaded the latest Oracle Instant client and installed. Tested it and it works.

3. Downloaded and installed the Visual C++ 2003 toolkit and installed the "Core" api.

4. Downloaded and installed the Windows SDK

5. Downloaded and installed the .net framework SDK v1.1

6. Edited the vcvars32.bat as per instructions:

set path=D:\OracleInstantClient\instantclient_10_2;C:\Program Files\Microsoft Visual Studio .NET 2003\Common7\IDE;C:\Program Files\Microsoft Visual Studio .NET 2003\VC7\BIN;C:\Program Files\Microsoft Visual Studio .NET 2003\Common7\Tools;C:\Program Files\Microsoft Visual Studio .NET 2003\Common7\Tools\bin\prerelease;C:\Program Files\Microsoft Visual Studio .NET 2003\Common7\Tools\bin;C:\Program Files\Microsoft Visual Studio .NET 2003\SDK\v1.1\bin;C:\WINNT\Microsoft.NET\Framework\v1.1.4322;d:\iw-home\iw-perl\bin\;C:\WINNT\system32;C:\WINNT;C:\WINNT\System32\Wbem;C:\Program Files\Microsoft SDK\Bin;C:\Program Files\Microsoft SDK\Bin\WinNT;C:\Program Files\Microsoft Visual C++ Toolkit 2003\bin;C:\Program Files\Microsoft Platform SDK\Include;C:\Program Files\Microsoft Visual Studio .NET 2003\Vc7\lib;C:\Program Files\Microsoft Platform SDK\Lib%PATH%

Set INCLUDE=C:\Program Files\Microsoft Visual C++ Toolkit 2003\include;%INCLUDE%
Set LIB=C:\Program Files\Microsoft Visual C++ Toolkit 2003\lib;D:\OracleInstantClient\instantclient_10_2\sdk\lib;%LIB%
set ORACLE_HOME=D:\OracleInstantClient\instantclient_10_2
set NLS_LANG=.WE8ISO8859P15
set LD_LIBRARY_PATH=D:\OracleInstantClient\instantclient_10_2\SDK\LIB
set LD_RUN_PATH=D:\OracleInstantClient\instantclient_10_2\SDK\LIB

7. I open the C++ command prompt, and set the oracle_userid to my DB instance

8. iwperl Makefile.pl and get the following output:

\cpan\sources>iwperl Makefile.pl
*** Warning: Colons in the current directory path (D:/cpan/sources) may cause pr
oblems
Using DBI 1.38 installed in d:\iw-home\iw-perl\vendor\lib/auto/DBI

Configuring DBD: Smiley Surprised

racle for perl 5.008002 on MSWin32 (MSWin32-x86-multi)

Remember to actually *READ* the README file! Especially if you have any problems
.

Using Oracle in

/OracleInstantClient/instantclient_10_2
DEFINE _SQLPLUS_RELEASE = "1002000200" (CHAR)
Oracle version 10.2.0.2 (10.2)
Using OCI directory 'sdk'
Found sdk/lib/MSVC/oci.lib library
Found sdk/lib/MSVC/ociw32.lib library
Found sdk/lib/MSVC/oraocci10.lib library
Using sdk/lib/MSVC/OCI.lib

Checking for functioning wait.ph

System: perl5.008002
Compiler: cl -MD -DNDEBUG -O1 -nologo -GF -W3 -MD -DNDEBUG -O1 -DWIN32 -D_CONS
OLE -DNO_STRICT -DHAVE_DES_FCRYPT -DPERL_IMPLICIT_CONTEXT -DUSE_PERLIO -DPERL_M
SVCRT_READFIX
Linker: not found
Sysliblist:

WARNING: If you have problems you may need to rebuild perl with threading enable
d.
*** Warning: Colons in the current directory path (D:/cpan/sources) may cause pr
oblems
Note (probably harmless): No library found for user32.lib
Note (probably harmless): No library found for gdi32.lib
Note (probably harmless): No library found for winspool.lib
Note (probably harmless): No library found for comdlg32.lib
Note (probably harmless): No library found for advapi32.lib
Note (probably harmless): No library found for shell32.lib
Note (probably harmless): No library found for ole32.lib
Note (probably harmless): No library found for oleaut32.lib
Note (probably harmless): No library found for netapi32.lib
Note (probably harmless): No library found for uuid.lib
Note (probably harmless): No library found for wsock32.lib
Note (probably harmless): No library found for mpr.lib
Note (probably harmless): No library found for winmm.lib
Note (probably harmless): No library found for version.lib
Note (probably harmless): No library found for odbc32.lib
Note (probably harmless): No library found for odbccp32.lib
Note (probably harmless): No library found for msvcrt.lib
Ignoring LD_RUN_PATH='D:\OracleInstantClient\instantclient_10_2\SDK\LIB' in envi
ronment
LD_RUN_PATH=D:/OracleInstantClient/instantclient_10_2/sdk/lib
Using DBD: Smiley Surprised

racle 1.19.
Using DBD: Smiley Surprised

racle 1.19.
*** Warning: Colons in the current directory path (D:/cpan/sources) may cause pr
oblems
*** Warning: Colons in the current directory path (D:/cpan/sources) may cause pr
oblems
Using DBI 1.38 installed in d:\iw-home\iw-perl\vendor\lib/auto/DBI
Writing Makefile for DBD: Smiley Surprised

racle

9. I then run: nmake, and get the following:

\cpan\sources>nmake

Microsoft (R) Program Maintenance Utility Version 7.00.8882
Copyright (C) Microsoft Corp 1988-2000. All rights reserved.

makefile(825) : fatal error U1083: target macro '' expands to nothing
Stop.

Any ideas or advice is greatly appreciated.

Find more posts tagged with

Comments

Adam Stoller

I've not (yet) had to do this on Windows - so all I can do is highlight some of the messages that you received in the text you posted and hope that might lead you to finding the solutions you need.

...
\cpan\sources>iwperl Makefile.pl
*** Warning: Colons in the current directory path (D:/cpan/sources) may cause problems
[...]
Remember to actually *READ* the README file! Especially if you have any problems.
[...]
Linker: not found
[...]
*** Warning: Colons in the current directory path (D:/cpan/sources) may cause problems
Note (probably harmless): No library found for user32.lib
Note (probably harmless): No library found for gdi32.lib
Note (probably harmless): No library found for winspool.lib
Note (probably harmless): No library found for comdlg32.lib
Note (probably harmless): No library found for advapi32.lib
Note (probably harmless): No library found for shell32.lib
Note (probably harmless): No library found for ole32.lib
Note (probably harmless): No library found for oleaut32.lib
Note (probably harmless): No library found for netapi32.lib
Note (probably harmless): No library found for uuid.lib
Note (probably harmless): No library found for wsock32.lib
Note (probably harmless): No library found for mpr.lib
Note (probably harmless): No library found for winmm.lib
Note (probably harmless): No library found for version.lib
Note (probably harmless): No library found for odbc32.lib
Note (probably harmless): No library found for odbccp32.lib
Note (probably harmless): No library found for msvcrt.lib
Ignoring LD_RUN_PATH='D:\OracleInstantClient\instantclient_10_2\SDK\LIB' in environment
[...]
Using DBD:racle 1.19.
Using DBD:racle 1.19.
*** Warning: Colons in the current directory path (D:/cpan/sources) may cause problems
*** Warning: Colons in the current directory path (D:/cpan/sources) may cause problems
[...]
9. I then run: nmake, and get the following:

\cpan\sources>nmake

Microsoft (R) Program Maintenance Utility Version 7.00.8882
Copyright (C) Microsoft Corp 1988-2000. All rights reserved.

makefile(825) : fatal error U1083: target macro '' expands to nothing
Stop.

Any ideas or advice is greatly appreciated.

jed

Do you have to use DBD: Smiley Surprised

racle? I have not used any of the alternatives yet, but both of these could make your life easier (or harder?)

http://cpan.uwinnipeg.ca/dist/DBD-JDBC
http://cpan.uwinnipeg.ca/dist/JDBC

sgouin

Thanks Fish, Jed for the prompt replies.

Fish, I agree, the linker is most likely the root of my problem. I'm not a Perl/C expert, (coming from the Oracle PL/SQL world), so all this compiling, linking, making etc is a little foreign to me. I have to remember back to my limited C classes in college, oh about 10 years ago.. yeesh

I will keep perusing the READMEs once more to see if anything comes to me...

Jed, I'll look into it, but my problem is mostly related to the compiling/making part of the process... so I'll probably run into the same issues with DBD:JDBC... but definately worth a look.. especially since support for DBD Smiley Surprised

racle seems limited (ie ActiveState status for this module is "failed")...

Jed, I assume you have used this module in your implementation at Sun? Any lessons learned, advice in a nutshell?

Thanks guys

sgouin

From what I can see, DBD:JDBC requires Perl 5.8.6... TS6.5 runs 5.8.2... not sure if Perl can be upgraded safely or not... Well, one doc says 5.8, the other says 5.8.6 or higher...

TS6.5 also comes with DBI 1.38, not 1.48... so I'll have to figure out how to properly compile Perl modules, if I'm to get anywhere with this... *sigh*

sgouin

Getting somewhere.... nmake is actually "trying" to make something..

One of my problems was related to "copy and paste" error... the path to the Win SDK directory was wrong in the batch file.

Plus I downloaded the complete TAR of DBD Smiley Surprised

racle, and unpacked it in a directory, from where I ran the build.

So with that, I got the following output:

Using DBI 1.38 installed in d:\iw-home\iw-perl\vendor\lib/auto/DBI

Configuring DBD: Smiley Surprised

racle for perl 5.008002 on MSWin32 (MSWin32-x86-multi)

Remember to actually *READ* the README file! Especially if you have any problems.

Using Oracle in

:/OracleInstantClient/instantclient_10_2/rdbms/lib
Using DBD: Smiley Surprised

racle 1.19.
Using DBD: Smiley Surprised

racle 1.19.
Using DBI 1.38 installed in d:\iw-home\iw-perl\vendor\lib/auto/DBI
Writing Makefile for DBD: Smiley Surprised

racle

*** If you have problems...
read all the log printed above, and the README and README.help.txt files.
(Of course, you have read README by now anyway, haven't you?)

Skip blib\lib\DBD\Oracle.pm (unchanged)
Skip blib\lib\DBD\mkta.pl (unchanged)
Skip blib\lib/oraperl.ph (unchanged)
Skip blib\arch\auto\DBD\Oracle/dbdimp.h (unchanged)
Skip blib\arch\auto\DBD\Oracle/ocitrace.h (unchanged)
Skip blib\lib/Oraperl.pm (unchanged)
Skip blib\arch\auto\DBD\Oracle/Oracle.h (unchanged)
Skip blib\arch\auto\DBD\Oracle/mk.pm (unchanged)
Skip blib\lib\DBD\Oracle\GetInfo.pm (unchanged)
cl -c -ID:/OracleInstantClient/instantclient_10_2/sdk/include -ID:/OracleInstantClient/instantclient_10_2/rdbms/demo -Id:\iw-home\iw-perl\vendor\lib/auto/DBI -nologo -GF -W3 -MD -DNDEBUG -O1 -DWIN32 -D_CONSOLE -DNO_STRICT -DHAVE_DES_FCRYPT -DPERL_IMPLICIT_CONTEXT -DUSE_PERLIO -DPERL_MSVCRT_READFIX -MD -DNDEBUG -O1 -DVERSION=\"1.19\" -DXS_VERSION=\"1.19\" "-ID:\iw-home\iw-perl\lib\CORE" -DUTF8_SUPPORT -DNEW_OCI_INIT -DORA_OCI_VERSION=\"10.2.0.2\" Oracle.c
Oracle.c
cl -c -ID:/OracleInstantClient/instantclient_10_2/sdk/include -ID:/OracleInstantClient/instantclient_10_2/rdbms/demo -Id:\iw-home\iw-perl\vendor\lib/auto/DBI -nologo -GF -W3 -MD -DNDEBUG -O1 -DWIN32 -D_CONSOLE -DNO_STRICT -DHAVE_DES_FCRYPT -DPERL_IMPLICIT_CONTEXT -DUSE_PERLIO -DPERL_MSVCRT_READFIX -MD -DNDEBUG -O1 -DVERSION=\"1.19\" -DXS_VERSION=\"1.19\" "-ID:\iw-home\iw-perl\lib\CORE" -DUTF8_SUPPORT -DNEW_OCI_INIT -DORA_OCI_VERSION=\"10.2.0.2\" dbdimp.c
dbdimp.c
cl -c -ID:/OracleInstantClient/instantclient_10_2/sdk/include -ID:/OracleInstantClient/instantclient_10_2/rdbms/demo -Id:\iw-home\iw-perl\vendor\lib/auto/DBI -nologo -GF -W3 -MD -DNDEBUG -O1 -DWIN32 -D_CONSOLE -DNO_STRICT -DHAVE_DES_FCRYPT -DPERL_IMPLICIT_CONTEXT -DUSE_PERLIO -DPERL_MSVCRT_READFIX -MD -DNDEBUG -O1 -DVERSION=\"1.19\" -DXS_VERSION=\"1.19\" "-ID:\iw-home\iw-perl\lib\CORE" -DUTF8_SUPPORT -DNEW_OCI_INIT -DORA_OCI_VERSION=\"10.2.0.2\" oci8.c
oci8.c
Running Mkbootstrap for DBD: Smiley Surprised

racle ()

\iw-home\iw-perl\bin\iwperl.exe -MExtUtils::Command -e chmod 644 Oracle.bs
link -out:blib\arch\auto\DBD\Oracle\Oracle.dll -dll -nologo -nodefaultlib -release -libpath:"d:\iw-home\iw-perl\lib\CORE" -machine:x86 Oracle.obj dbdimp.obj oci8.obj

\iw-home\iw-perl\lib\CORE\perl58.lib

\OracleInstantClient\instantclient_10_2\sdk\LIB\MSVC\OCI.lib "C:\Program Files\Microsoft Visual C++ Toolkit 2003\lib\oldnames.lib" "C:\Program Files\Microsoft Visual C++ Toolkit 2003\lib\kernel32.lib" -def Smiley Surprised

racle.def
Creating library blib\arch\auto\DBD\Oracle\Oracle.lib and object blib\arch\auto\DBD\Oracle\Oracle.exp
Oracle.obj : error LNK2019: unresolved external symbol __imp__atof referenced in function _XS_DBD__Oracle_ORA_OCI
Oracle.obj : error LNK2001: unresolved external symbol __fltused
dbdimp.obj : error LNK2001: unresolved external symbol __fltused
Oracle.obj : error LNK2019: unresolved external symbol __imp__sprintf referenced in function _dbdxst_bind_params
dbdimp.obj : error LNK2019: unresolved external symbol __imp__sprintf referenced in function _GetRegKey
oci8.obj : error LNK2001: unresolved external symbol __imp__sprintf
Oracle.obj : error LNK2019: unresolved external symbol _strcmp referenced in function _boot_DBD__Oracle
dbdimp.obj : error LNK2001: unresolved external symbol _strcmp
dbdimp.obj : error LNK2019: unresolved external symbol __imp__RegCloseKey@4 referenced in function _GetRegKey
dbdimp.obj : error LNK2019: unresolved external symbol __imp__RegQueryValueExA@24 referenced in function _GetRegKey
dbdimp.obj : error LNK2019: unresolved external symbol __imp__RegOpenKeyExA@20 referenced in function _GetRegKey
dbdimp.obj : error LNK2019: unresolved external symbol _memset referenced in function _fb_ary_alloc
oci8.obj : error LNK2001: unresolved external symbol _memset
dbdimp.obj : error LNK2019: unresolved external symbol _strcpy referenced in function _dbd_preparse
oci8.obj : error LNK2019: unresolved external symbol _strcpy referenced in function _dbd_phs_out
dbdimp.obj : error LNK2019: unresolved external symbol __imp__atoi referenced in function _dbd_preparse
oci8.obj : error LNK2001: unresolved external symbol __imp__atoi
dbdimp.obj : error LNK2019: unresolved external symbol _strlen referenced in function _dbd_preparse
oci8.obj : error LNK2001: unresolved external symbol _strlen
dbdimp.obj : error LNK2019: unresolved external symbol __ftol2 referenced in function _dbd_preparse
oci8.obj : error LNK2019: unresolved external symbol __ftol2 referenced in function _fetch_func_varfield
oci8.obj : error LNK2019: unresolved external symbol _memcpy referenced in function _ora_blob_read_mb_piece
oci8.obj : error LNK2019: unresolved external symbol __imp__strchr referenced in function _ora_parse_uid
oci8.obj : error LNK2019: unresolved external symbol __imp__strncpy referenced in function _find_ident_after
oci8.obj : error LNK2019: unresolved external symbol _strcat referenced in function _init_lob_refetch
LINK : error LNK2001: unresolved external symbol __DllMainCRTStartup@12
blib\arch\auto\DBD\Oracle\Oracle.dll : fatal error LNK1120: 17 unresolved externals

NMAKE : fatal error U1077: 'link' : return code '0x460'

I guess this comes back to the "Linker not found" error... I looked at the Makefile.pl file, and saw the following code:

print "Linker: ". (find_bin('ld')||"not found") ."\n" unless $os eq 'VMS';

sub find_bin{
use filetest 'access';
my $bin = shift;
my $path_sep = $Config{path_sep};
foreach (split(/\Q$path_sep/, $ENV{PATH})){
return "$_/$bin" if -x "$_/$bin";
}
return undef;
}

Not sure why there is a hard-coded strin literal there, but I added an empty directory named "ld" to my C++/BIN directory which "cleared" the error... still did not work obviously, but is this where we specify the location of the linker? There is a "link.exe" in my C++/BIN directory...

Any thoughts?

jed

Jed, I assume you have used this module in your implementation at Sun? Any lessons learned, advice in a nutshell?

Doing the compile on Solaris is not too difficult. With gcc, gmake and binuitls, it goes pretty quick. As for windows--no clue.

Adam Stoller

Getting somewhere.... nmake is actually "trying" to make something..

Glad you're making progress.

...
I guess this comes back to the "Linker not found" error... I looked at the Makefile.pl file, and saw the following code:

print "Linker: ". (find_bin('ld')||"not found") ."\n" unless $os eq 'VMS';

sub find_bin{
use filetest 'access';
my $bin = shift;
my $path_sep = $Config{path_sep};
foreach (split(/\Q$path_sep/, $ENV{PATH})){
return "$_/$bin" if -x "$_/$bin";
}
return undef;
}

Not sure why there is a hard-coded strin literal there

To what string literal are you referring? 'ld' is the name of the linker executable being searched, not the name of a directory.

...but I added an empty directory named "ld" to my C++/BIN directory which "cleared" the error... still did not work obviously, but is this where we specify the location of the linker? There is a "link.exe" in my C++/BIN directory...

Any thoughts?

The only thought I can offer is remove that empty 'ld' directory and try copying 'link.exe' to 'ld.exe' and see if that helps.

Good luck

sgouin

An update...

I successfully installed DBD:JDBC. I had to upgrade the DBI to latest version (1.53) and downloaded the JDBC Oracle drivers (9.2.0.8) from OTN.

I was able to connect to our 9.2.0.7 Oracle database from the PT after getting the JDBC server running on the TS server.

I am getting errors with the server regarding Log4J appenders... but it doesn't affect server for managing connections, it just won't log anything if an error occurs.

As for DBD Smiley Surprised

racle, I was able to compile and install it. There were a few errors when running nmake test, (99% success), but I installed anyways. Some of the errors were relating to the query tests, the table used in the sample query was not accessible in my DB schema, so it through an error...

Problems I'm having with DBD Smiley Surprised

Racle are now relating to an ORA-012154: Invalid TNS, when previewing the DCR.

I'm using the latest Oracle Instant Client for Windows, which can't seem ro recognize the TNS configurations, even after setting the proper env variables, such as TNS_ADMIN. What I will try next is re-compiling DBD Smiley Surprised

racle with a full Oracle 9i client install...

I will post back results when done...

I'm leaning more towards DBD Smiley Surprised

racle than DBD:JDBC, mainly because it needs a server to run in the background to manage connections... another potential fail point...

sgouin

DBD

racle v.1.19 now works...

I decided to post my findings if anyone else is running into similar issues on Windows 2000 Service Pack 4 and TS 6.5 w/ Perl 5.8.2.

I have attached my C++ bat file for setting the compiler env variables (vcvars32.bat) as well as logs of the entire make and install process.

I pretty much followed the steps as outlined in the following README on CPAN:

http://search.cpan.org/src/PYTHIAN/DBD-Oracle-1.19/README.win32.txt

I was getting an Oracle TNS error with the latest Instant Client and could not get it working. So I installed Oracle 9i Client (basic install w/SQL Plus and OCI libs etc..), re-configured the C++ environment (vcvars32.bat) . I also set the ORACLE_USERID env variable locally in the C++ session :
set ORACLE_USERID=dbuser/dbpass@tnsname,
so that the test scripts can connect to the DB and run some tests. I also set the NLS_LANG:
set NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1

You have to ensure it is a valid value, otherwise you'll run into problems. (ie all your tests will fail during nmake test)

It is also recommended that the character set match the target DB... (Oracle recommendation) otherwise, you get into conversion problems between the client and the DB.

After all this is done, I run the make and install...

iwperl Makefile.pl
nmake
nmake test
nmake install

Now, in my TPL, I have the following code:

 <iw_sql_open data_source = "dbiracle:tnsname"
   user_name="dbuser"
   password="dbpass"
   aux_env="ORACLE_HOME => 'c:\ora92',
                               ORACLE_SID  => 'sid',
 NLS_LANG=>'AMERICAN_AMERICA.WE8ISO8859P1'">
       <iw_sql_query stmt       = 'select * from table'
                      result_set = 'sth'/> 
<ul>
        <iw_sql_iterate  var='row' result_set='sth'>
           <li> <iw_value name='$row->{column}'/></li>
        </iw_sql_iterate>  
</ul>
  </iw_sql_open>

I created a TNSNAME entry using the ORacle client, and entered the name in the DBI Smiley Surprised

racle: datasource string...

In the IW docs, the Oracle example does not mention setting the NLS_LANG param in the aux_env section. In my case, I was getting an ORA-12705. As per Oracle Docs, this error means:

ORA-12705 invalid or unknown NLS parameter value specified

Cause: There are two possible causes: Either an attempt was made to issue an ALTER SESSION statement with an invalid NLS parameter or value; or the NLS_LANG environment variable contains an invalid language, territory, or character set.

Action: Check the syntax of the ALTER SESSION statement and the NLS parameter, correct the syntax and retry the statement, or specify correct values in the NLS_LANG environment variable. For more information about the syntax of the ALTER SESSION statement, see the Oracle9i SQL Reference.

My guess is DBD Smiley Surprised

racle was either not setting the NLS_LANG param, or setting it to NULL, or another invalid value, since it was not specified in the aux_env. Setting it properly here resolved the issue, and my TPL outputted correctly.

Hope this helps... feedback and/or comments is appreciated...

MadhaviPalvai

Hi,
I am using Teamsite 6.5,Oracle 9.0.1 on Windows platform. Installing DBD: Smiley Surprised

racle is giving the trouble. I followed all the readme steps,mentioned in your notes, but in nmake test,I am getting illegal attribute type error. I set the environment variables for NLS_LANG as mentioned.
getting the following error

DBI connect(dsn,uid,password) failed: ORA-24315: illegal attribute type (DB
D ERROR: OCIAttrGet OCI_ATTR_ENV_CHARSET_ID)

I:\DBD-Oracle-1.19>nmake test

Microsoft (R) Program Maintenance Utility Version 7.00.8882
Copyright (C) Microsoft Corp 1988-2000. All rights reserved.

\iw-home\iw-perl\bin\iwperl.exe "-MExtUtils::Command::MM" "-e" "test_h
arness(0, 'blib\lib', 'blib\arch')" t\01base.t t\10general.t t\15nls.t t\20selec
t.t t\21nchar.t t\22nchar_al32utf8.t t\22nchar_utf8.t t\23wide_db.t t\23wide_db_
8bit.t t\23wide_db_al32utf8.t t\24implicit_utf8.t t\25plsql.t t\26exe_array.t t\
30long.t t\31lob.t t\40ph_type.t t\50cursor.t t\55nested.t t\60reauth.t t\70meta
.t
t\01base................ok
t\10general.............DBI connect('dsn','scott',password) failed: ORA-24315: ill
egal attribute type (DBD ERROR: OCIAttrGet OCI_ATTR_ENV_CHARSET_ID) at t\10gener
al.t line 18

any idea how to resolve this.

Thanks,
Madhavi

Vishakha

This question is for sgouin:-
As you have installed the DBD Smiley Surprised

racle overriding the Linker problem.
Can you explain how your linker problem was solved? We have modified the vcvars32.bat as mentioned by you. However we did not add the following two entries as those were not available on our server.

set PATH=C:\Program Files\Microsoft.NET\SDK\v1.1\bin;%PATH%
set PATH=C:\WINNT\Microsoft.NET\Framework\v1.1.4322;%PATH%

I guess this is something related to the C library and not the Oracle Client. We are using Oracle 8i client and we can successfully connect to the Oracle database using SQL plus. So I doubt installing another version of Oracle client can help.
Please help with this.