Re: odbc_procedurecolumns

Avrum Goodblatt wrote: > > I have been trying to get some of the new odbc functions to work. > > odbc_procedurecolumns (and odbc_columns, odbc_procedures etc) works if I only > give the connect string. > i.e. odbc_procedurecolumns($conn). > If I try to give any other parameters, I get an sql error. My details: > NT,microsoft access 2000 odbc driver. > Can someone give me an example of how to write the other parameters in this Haven't tried it with Access but you may not get this function to work seeing as Access2k does not have procedures. Whether it will pull out queries a good question. It's important with this function to get the parameters correct. The function syntax is odbc_procedures(conn, catalog, owner, procedure); The cata log is the database name (not the DSN name) and the owner is the owner of the table. With Access you really have neither a database name (apart from the file name) and an owner, at least not in say the SQL-Server sense of the word. Having saisd that you can try using the wildcard to see if you can at least get something. odbc_procedures($conn, "%", "%", "Queryname"); Cheers, Graeme