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

[M.-A. Lemburg]

Maneesh Singh wrote:
> 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?

This is likely a permission problem. Please check your
MS SQL Server configuration. For details, see:

http://www.microsoft.com/resources/documentation/sql/2000/all/reskit/en-us/part3/c1061.mspx

> Can access views through mxODBC?

Sure.

-- 
Marc-Andre Lemburg
eGenix.com

Professional Python Services directly from the Source  (#1, Feb 09 2005)
 >>> Python/Zope Consulting and Support ...        http://www.egenix.com/
 >>> mxODBC.Zope.Database.Adapter ...             http://zope.egenix.com/
 >>> mxODBC, mxDateTime, mxTextTools ...        http://python.egenix.com/
________________________________________________________________________

::: Try mxODBC.Zope.DA for Windows,Linux,Solaris,FreeBSD for free ! ::::