Stored procedure

Unanswered Question
Jul 2nd, 2008

Is it possible to make an ODBC connection to a mysql database using a stored procedure ?

I have this problem too.
0 votes
  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 0 (0 ratings)
Loading.
darpotter Wed, 07/02/2008 - 06:55

Could be..

I assume you mean for ODBC authentication? Only works for software ACS and not appliance.

There is a cisco white paper (I wrote) that says all about ODBC auth - might have been merged into main ACS docs.

lni1 Thu, 07/03/2008 - 01:03

I configured everything following the white paper, now it keeps saying "External DB [ODBCAuthDll.dll]: DSN 'CsntOdbcAuth' doest not support procedures". I executed the stored procedure and it works, where is the problem?

darpotter Fri, 07/04/2008 - 03:15

As I recall ACS uses the Windows SQLGetInfo(SQL_PROCEDURES) api to ask the database if it supports stored procedures.

Your database must be returning something other than "Y"

You could ask your database providers tech support for their comment.

Actions

This Discussion