Callable Statement + SQL Server 2000

I am using the Microsoft SQl Server 2000 JDBC driver and a CallableStatement (Java). The call is to a (SELECT action) stored procedure which works fine in Query Manager with the same login params. I am getting a "Could not find stored procedure" error? I am using the fully qualified procedure name. I have looked on TechNet for this type problem but to no avail.

Thanks

Greg

[394 byte] By [TaylorGreg] at [2007-9-27 21:35:39]

«« Thread InterruptedException explain
»» Changing Swing Component L&F

# 1

I'm getting this same problem on one of my stored procs.Did you ever get to the bottom of your problem?

BigMikeW at 2007-7-7 3:32:29 >

top of Java-index,Database Connectivity,Java Database Connectivity (JDBC)...

# 2

Have you tried this syntax: {?=call storedProcedureName;1 ?, ?}

Nerisson at 2007-7-7 3:32:29 >

# 3

Hmmmm, forgot to include the databaseName parameter when I opened the JDBC connection

BigMikeW at 2007-7-7 3:32:29 >

Java Database Connectivity (JDBC)

Java programming resources: FAQs, tutorials, compiler and browser download sites, documentation, books lists, IDEs, etc.

Callable Statement + SQL Server 2000

Database Connectivity New Topic

Database Connectivity Hot Topic

Database Connectivity

All Classified