how to solve this issue

Hi i am calling stored procedure and it works fine before but noe i am getting error as

[Macromedia][SQLServer JDBC Driver][SQLServer]Login failed for user 'sam'.(when i use username and password attributes in cfstoredproc)

[Macromedia][SQLServer JDBC Driver][SQLServer]Could not find stored procedure 'getData'(when i removed usename and password fields from cfstoredproc)

my cfsoredproc consists of

This topic has been closed for replies.

Participating Frequently

Assuming that you have a user and password assigned in ColdFsuion Administrator for the DSN, what do you get if you try it this way?

Phil

Participating Frequently

Make sure that you can login to the database with the user and the

password you specified and that user has the right to execute the

stored procedure (you can check that by logging in to your db with a

program like EMS MS Manager).

Mack

Sign up