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,
Stored Procedure Stage
Moderators: chulett, rschirm, roy
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
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
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 18
- Joined: Mon Mar 26, 2007 1:02 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.
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.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers