[egenix-users] Error in accessing a view which works well with isql.

[Maneesh Singh]

Hi,
   I need to aceess a view on a MS SQL Server 2000
database from my Fedora Core 2 machine using
freetds+unixODBC+mxODBC (Python 2.3).
   The SQL query runs fine with isql but gives the
following error with a python script: 
----------------------------
mxODBC.ProgrammingError: ('S0002', 208,
"[unixODBC][FreeTDS][SQL Server]Invalid object name
'viewExEmployeeDetails'.", 4612)
----------------------------

The sql query fired is:
----------------------------
SELECT * FROM viewExEmployeeDetails WHERE
ProjectTilte='MIS' ORDER BY Name ASC
----------------------------


Does anyone have a reason/solution to this problem?
Can access views through mxODBC?


Thanks!



Maneesh Singh.


		
__________________________________ 
Do you Yahoo!? 
Yahoo! Mail - now with 250MB free storage. Learn more.
http://info.mail.yahoo.com/mail_250