On Thursday 24 September 2009 05:06:02 [email protected] wrote: > I have investigated further and found that it is a bug in ODBC, not > Asterisk. The SQLColumns function, which asterisk uses to describe the > table, does not return any columns when the table name includes the > schema specification. You can show this by using isql to do "help table" > which returns info about all the columns, and then "help public.table" > which returns nothing. As chan_sip seems to be the only application that > tests the structure of the table before writing to it this is why > REGISTER fails. > > When I have time I will chase up ODBC and see if the issue is tracked > there. Do you still want me to raise it as an issue on bugtracker?
Yes, I want you to raise this on the bugtracker, and no, this is not a bug in ODBC, but a deficiency in my code. Since you tracked this down to the code in res_odbc.c, I might as well tell you that the first two NULL sets of arguments (NULL, 0) are for specifying the catalog and schema, respectively, of the database table, and it is because I never bothered parsing the schema out of the tablename that this does not work. -- Tilghman Lesher Digium, Inc. | Senior Software Developer twitter: Corydon76 | IRC: Corydon76-dig (Freenode) Check us out at: www.digium.com & www.asterisk.org _______________________________________________ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- AstriCon 2009 - October 13 - 15 Phoenix, Arizona Register Now: http://www.astricon.net asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
