Stored Procedure Stage

karthik_j013 · Post by **karthik_j013** » Thu May 22, 2008 3:54 am

I am having a stored procedure of SQL Server. I am trying to use the stored procedure stage. Problems I encountered are:

1. There is no SQL Server in the Database Vendor. (Work around I have given that in the Job parameter).

2. Error while running the Job is:
Stored_Procedure_6,0: Error: Unknown client library - SQL Server
Stored_Procedure_6,0: Error occurred in call to ORPHCallActivePluginInitialize().

Please help me in solving this problem.

Thanks,

chulett · Post by **chulett** » Thu May 22, 2008 7:04 am

A couple of problems...

1. You can't "make up" a database vendor. If something isn't there, it isn't there.

2. SQL Server is Windows only.

http://www.sommarskog.se/mssqlperl/unix.html

karthik_j013 · Post by **karthik_j013** » Mon May 26, 2008 1:33 am

But in the help file it as been given to add it to the Job Parameter.

Can you please let me know the work around for the stored procedure.

chulett · Post by **chulett** » Mon May 26, 2008 7:10 am

Still... you can only use valid values in any job parameter there, it doesn't allow you to magically make one up.

Assuming you are actually on UNIX as noted, and you've managed to be accessing SQL Server all along, you could use the ODBC stage to call the stored procedure. Or consider taking whatever the procedure does and building a job to replace it.