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

[Maneesh Singh]

 Hi Marc,
        Thanks for your help. There was an incorrect
 dsn,user & password strings given for the Python-MS
 SQL Server 2000 connection. I noticed it after you
 replied and I was reading the code again. It was a
 copy-paste code which I had used for another system
 & apparently forgot to change the strings when
reusing
 the code.
 
 Sorry for the inconvienence due to my overlooking!
 
 
 Thanks!
 
 Bye!
 
 Maneesh.
 
> --- "M.-A. Lemburg" <mal at egenix.com> wrote:
> 
> > 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 ! ::::
> > 
> 
> 
> 
> 		
> __________________________________ 
> Do you Yahoo!? 
> All your favorites on one personal page – Try My
> Yahoo!
> http://my.yahoo.com 
> 



		
__________________________________ 
Do you Yahoo!? 
All your favorites on one personal page – Try My Yahoo!
http://my.yahoo.com