perl sqlserver environment variable

mart2001

Hi,

I have an inline command that works from the command line connecting to a sqlserver database, but when I have it go through the formspub, it throughts an error about not able to load the driver.


DBI connect('DRIVER={SQL Server};SERVER={sqlserver1}','dbuser',...) failed: Specified driver could not be loaded due to system error 126: The specified module could not be found. (SQL Server, %WINDIR%\system32\SQLSRV32.dll). (SQL-IM003)(DBD: db_login/SQLConnect err=-1) at d:/Interwoven/TeamSite/custom/program.ipl line 13 Can't call method "do" on an undefined value at d:/Interwoven/TeamSite/custom/program.ipl line 14.

I am pretty sure I need to set an environment variable, but can't find the thread that talked about this.

tried to put this in the BEGIN block:


BEGIN {
$ENV{PATH}='C:/Windows/system32;C:/Windows;C:/Windows/System32/Wbem;d:/Interwoven/TeamSite/bin;D:/Interwoven/TeamSite/iw-perl/bin;';
};

but that didn't seem to do the trick. Any ideas?

Thanks,

Find more posts tagged with

Comments

ISCBorisB

I have an inline command that works from the command line...

Print out Environment Variables within the Environment where your code works. Identify
possible candidates (like for example DBI_DSN Env) and add them, one by one if needed.

Balaveera Thatikonda

@mart2001,

I had similar kind of problem when connecting to Oracle DB, ( do not remember the exact error msg), but when I set the following paths to the path env' variable, it worked.

c:\oracle\product\10.2.0\client_1\nls\data;c:\oracle\product\10.2.0\client_1;c:\oracle\product\10.2.0\client_1\LIB;

hope this helps.

mart2001

It looks like I need to set it with

$ENV{'WINDIR'}="C:\\Windows";

And that seem to do the trick.