Re: [DB-SIG] python connection to Velocis Database

2009-12-08 Thread Susan
Marc-Andre, good to know but given what I know about the company I'm doing this work for, that would be my last resort. Vernon, "a bit light" is a bit of an under statement. :) adodbapi looks somewhat better..but I think the problem lies with the vendor's odbc driver and what "should work" doesn'

Re: [DB-SIG] python connection to Velocis Database

2009-12-08 Thread Vernon Cole
Susan: That's not a very good error message, it is true. I suspect that your vendor's ODBC driver may be a bit light on diagnostics. To extract the most information from the exception, try something like this: v v v v v start Python code v v v v v from win32com.client import Dispatch import pywi

Re: [DB-SIG] python connection to Velocis Database

2009-12-08 Thread M.-A. Lemburg
Susan wrote: > Thanks Vernon & Marc-Andre for your replies. Your suggestion has been > helpful and I am running Microsoft Windows. The following: > > from win32com.client import Dispatch > conn = Dispatch(r'ADODB.Connection') > conn.Open("Dsn=xxx;uid=xxx;pwd=xxx") > conn.Execute('create table foo

Re: [DB-SIG] python connection to Velocis Database

2009-12-07 Thread Carl Karsten
On Mon, Dec 7, 2009 at 11:40 PM, Susan wrote: > Thanks Vernon & Marc-Andre for your replies. Your suggestion has been > helpful and I am running Microsoft Windows. The following: > > from win32com.client import Dispatch > conn = Dispatch(r'ADODB.Connection') > conn.Open("Dsn=xxx;uid=xxx;pwd=xxx")

Re: [DB-SIG] python connection to Velocis Database

2009-12-07 Thread Susan
Thanks Vernon & Marc-Andre for your replies. Your suggestion has been helpful and I am running Microsoft Windows. The following: from win32com.client import Dispatch conn = Dispatch(r'ADODB.Connection') conn.Open("Dsn=xxx;uid=xxx;pwd=xxx") conn.Execute('create table foo (blah char(30) )') conn.Exe

Re: [DB-SIG] python connection to Velocis Database

2009-12-03 Thread M.-A. Lemburg
Susan wrote: > Hi, > > Is there a python library for connecting to a Raima Velocis database? According to the web page, Raima supports ODBC 3.51, so you can use our mxODBC database adapters together with the Raima ODBC drivers on almost all platforms supported by Python itself. For single-tier s

Re: [DB-SIG] python connection to Velocis Database

2009-12-02 Thread Vernon Cole
Susan: You failed to mention the platform on which you are running Python. I will assume that you are running Microsoft Windows. I was not aware of Raima before seeing your question, so I have never tried this, but it will probably work... I see in Raima's FAQ that they support both ODBC 3.51

[DB-SIG] python connection to Velocis Database

2009-12-02 Thread Susan
Hi, Is there a python library for connecting to a Raima Velocis database? Cheers, S ___ DB-SIG maillist - DB-SIG@python.org http://mail.python.org/mailman/listinfo/db-sig