python-sybase-misc

Re: [python-sybase] Pulling my hair out about a query... (solved?)

[Skip M. <sk...@po...>]

Dave & Stan,

I seem to have reached a useful conclusion about my query involving dates.
Our production Sybase server here is running 11.9.something while the Sybase
module is built using the 12.5 OCS libraries.  We have a test server running
12.5.  Grasping at straws this morning I tried running the script against
the test server.  Voila!  Valid results were returned!

That seems to solve my problem.  We will transition the test server to
production in a couple weeks and in the meantime I can just use the test
server directly.  That doesn't solve the problem for the Sybase module
though.  I suppose it's possible that some bit is set incompatibly at the
lower levels.  I'd be happy to try some more debugging if you want.  Just
let me know.

Thanks for the help,

-- 
Skip Montanaro
sk...@po...

Re: [python-sybase] Pulling my hair out about a query... (solved?)

[Gregory B. <gn...@it...>]

We still have 11.5 (youch!!), 12.0 and 12.5 servers on Solaris we can test
against.  

And if you ever get the bulkcopy implemented again we'd use it live!

Re: [python-sybase] Pulling my hair out about a query... (solved?)

[Dave C. <dj...@ob...>]

Gregory Bond wrote:
> We still have 11.5 (youch!!), 12.0 and 12.5 servers on Solaris we can test
> against.  
> 
> And if you ever get the bulkcopy implemented again we'd use it live!

Ben keeps tellng me to reimplement the bulkcopy stuff.  If you are happy 
to test it I should be able to do it over the weekend.

- Dave

-- 
http://www.object-craft.com.au

Re: [python-sybase] Pulling my hair out about a query... (solved?)

[Dave C. <dj...@ob...>]

Dave Cole wrote:
> Gregory Bond wrote:
> 
>> We still have 11.5 (youch!!), 12.0 and 12.5 servers on Solaris we can 
>> test
>> against. 
>> And if you ever get the bulkcopy implemented again we'd use it live!
> 
> 
> Ben keeps tellng me to reimplement the bulkcopy stuff.  If you are happy 
> to test it I should be able to do it over the weekend.

Have been sick for the last two days.  Getting bored at home so I had a 
crack at implementing bulkcopy again...

Install the attached Sybase.py and try something like the following:

import csv
import Sybase

db = Sybase.connect(server, user, passwd, database,
                     delay_connect=1, auto_commit=1)
db.set_property(Sybase.CS_BULK_LOGIN, Sybase.CS_TRUE)
db.connect()
blk = db.bulkcopy(table)
for row in csv.reader(file("some.csv")):
     blk.rowxfer(row)
blk.done()

- Dave

-- 
http://www.object-craft.com.au