This content has been marked as final. Show 1 reply
Ok Guys.I managed to get the things working...I am able to execute an SQL statement and I am able to write to the file.But the problem is that when I am trying to execute the stored procedure then I am encountering the following error.[SeeBeyond][SQLServer JDBC Driver][SQLServer]Could not locate entry in sysdatabases for database 'dbo'. No entry found with that name. Make sure that the name is entered correctly.
I believe its trying to execute dbo.dbo.Stored_procedure instead of <DBNAME>.dbo.stored_procedure.
Any hints on how to change the connection to force Java CAPS to run taking the proper dbo schema?
I tried changing the different properties like the default schema in the DB for the said user but the problem still persisits.Any help or pointers?