Re: pymssql

2016-09-11 Thread sum abiut
cription'],row['rate_type']) i am using django, and i prance it cheers, On Sat, Sep 10, 2016 at 1:36 AM, john wrote: > take a look at > > http://pymssql.org/en/latest/pymssql_examples.html > > Johnf > > On 09/08/2016 05:48 PM, sum abiut wrote: > >

Re: pymssql

2016-09-09 Thread john
take a look at http://pymssql.org/en/latest/pymssql_examples.html Johnf On 09/08/2016 05:48 PM, sum abiut wrote: Hi, i have used pymssql to connet to windows database but i want to be able iterate and only print out some specific fields. here is what i did conn=pymssql.connect(server

pymssql

2016-09-08 Thread sum abiut
Hi, i have used pymssql to connet to windows database but i want to be able iterate and only print out some specific fields. here is what i did conn=pymssql.connect(server,username,password,database) cus=conn.cursor() cus.execute("SELECT * FROM glbud ") for

Re: pymssql: Problem with Unicode string

2011-02-16 Thread Ramiro Morales
On Wed, Feb 16, 2011 at 8:46 AM, Orgil wrote: > Hello. > I can not get unicode string from MSSQL. > I have pymssql-1.0.2, freetds-0.82, ubuntu-10.10. It seems you have sent this message to the wrong mailing list. -- Ramiro Morales -- You received this message because you are subs

Re: pymssql: Problem with Unicode string

2011-02-16 Thread Adnan Sadzak
You did not install static libs and headers Try this: aptitude install freetds-bin freetds-common freetds-dev or just freetds-dev. Cheers On Wed, Feb 16, 2011 at 9:46 AM, Orgil wrote: > Hello. > I can not get unicode string from MSSQL. > I have pymssql-1.0.2, freetds-0.82, ubuntu-1

pymssql: Problem with Unicode string

2011-02-16 Thread Orgil
Hello. I can not get unicode string from MSSQL. I have pymssql-1.0.2, freetds-0.82, ubuntu-10.10. I have two computers. First is well configured and good working (i did not configured). From that computer, I can read the unicode. Now i am trying to set up connection to mssql and reading unicode

Re: pymssql: Problem with Unicode string

2011-01-29 Thread Orgil
sorry, let me correct some row: --- import pymssql conn = pymssql.connect(host='testserver', user='sa', password='sa', database='testdb', as_dict=True) crms = conn.cursor() crms.execute('SE

pymssql: Problem with Unicode string

2011-01-29 Thread Orgil
Hello! I am using pymssql-1.9.908. And I have MSSQL2008 database server. I ran following code from python 2.6: --- import pymssql conn = pymssql.connect(host='testserver', user='sa', password='sa', database='