Hi SOCI developers,
[A] I had to change this string to get the Table names from MS SQL SERVER
default schema "dbo".
virtual std::string get_table_names_query() const
{
return "select table_name as \"Yummy_Data\""
" from information_schema.tables"
" where table_schema = '*dbo*'";
}
This returns all the Table names.
[B] I looked at underlying MSFT API's. They have an parameter option to
pass schema name. I could not find a way to send schema name in the SOCI
API.
Plz let me know if SOCI api can support schema name on SOCI ODBC API's.
Thanks
On Fri, May 7, 2021 at 4:10 PM Ravi chandra <particlere...@gmail.com> wrote:
> Hi,
>
> <> I am trying to access a table column/row from MS SQL.
> <>so far was able to establish a session [using file dsn using odbc driver]
> <> trying to fetch all table names. however it returns an empty vector.
> one of the suspects is schema name, which is "public" [by default], in MS
> SQL its odb [default schema name].
> [A] how to specify schema name in SOCI API to fetch all Table Names from
> that schema ?
> [B] I understand sql connection level handle. Is there any schema level
> handle and Table level handle?
>
> Thanks
>
>
>
--
god is always great and his miracles are enormous
_______________________________________________
soci-users mailing list
soci-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/soci-users
