search

rajeshveerepalli / pyodbc

Automatically exported from code.google.com/p/pyodbc
MIT No Attribution
0 stars 0 forks source link

Get current schema name #118

Closed GoogleCodeExporter closed 8 years ago

GoogleCodeExporter commented 8 years ago 
What steps will reproduce the problem?
1. cnxn = pyodbc.connect('DSN=dbname;PWD=password')
2. >>> for i in cursor.tables():
   ...     print i

What is the expected output? What do you see instead?
The output is good, but i don't get the name of the current schema that i have 
connected to.

What version of the product are you using? On what operating system?
pyodbc-2.1.7.win32-py2.7.exe

Original issue reported on code.google.com by dusan.sm...@gmail.com on 3 Sep 2010 at 1:58

GoogleCodeExporter commented 8 years ago 
I'm not entirely sure what you mean.  Do you mean the schema column is 
empty/NULL?  If so, that's up to the driver or database, not pyodbc.  pyodbc 
simply returns whatever the driver gives it here.

Original comment by mkleehammer on 5 Sep 2010 at 6:17

GoogleCodeExporter commented 8 years ago

Original comment by mkleehammer on 21 Nov 2010 at 5:47

GoogleCodeExporter commented 8 years ago 
This works in the databases I have tested, so it appears to be driver-specific. 
 Since I don't have any more information at this point, I'm going to close 
this.  Please re-open or post to the discussion group if it is still a problem.

Original comment by mkleehammer on 24 Nov 2010 at 8:14