Perl DBI inline issue

JoshProx

I am trying to make an inline ipl call to populate a dropdown from a SQL Server 2008 database. I am using a system DSN in my connection string.

my $dbConnection_dev = "DBIDBCSN=dsnname";

The code works fine from the command prompt but gives a connection issue when I call it from a formspublisher through inline

ERROR at [23:32:31 24.00.2010 ] in [D:\Interwoven\iw-home\custom\bin\project\content_category.ipl]: Development Database connection not made: [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied. (SQL-08001)
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect()). (SQL-01000)(DBD: db_login/SQLConnect err=-1)


Do I need to set some environment variables in my ipl to use a system DSN?

I also tried to use a fully ODBC driver in the connection string but that doesn't work

my $dbConnection_dev = "DBIDBCriver={SQL Server};Server=$sqlinstance;Database=DBName;UID=uid;PWD=pwd";

What am I missing here?

Adam Stoller

This issue has come up numerous times in the past and as been answered numerous times in the past - but given that the search mechanism has some significant problems ....

Check environment settings - get a list of what's available when you are at the command prompt, get a list of what's available to the script when you call it from FormsPublisher - compare the results, and figure out which one(s) will likely need to be explicitly set in your code in order to run it from FormsPublisher.