pyodbc access to Teradata

[Andrew]

Hello,
I'm using pyodbc to connect to a Teradata database in my normal python
programs.
I am just starting to use web2py and experimenting with connecting to
the same database. No luck so far.

The webbook says there is support for pyodbc but I cannot find any
examples of the connection string. The one that works in python
that I'm trying to adapt is:

db =
DAL('pyodbc:"DRIVER={Teradata};DBCNAME=MyDBTST;UID=username;PWD=password;QUIETMODE=YES;"')

Although pyodbc is a generic module, do I still need specfic Teradata
support within web2py, which I assume doesn't exist ?


Thanks
Andrew

[Andrew]

Sorry, meant to post this to the web2py group. However, if you know
the answer then please reply. Thanks

On Jun 2, 5:42 pm, Andrew <awillima...@gmail.com> wrote:
> Hello,
> I'm using pyodbc to connect to a Teradata database in my normal python
> programs.
> I am just starting to use web2py and experimenting  with connecting to
> the same database.    No luck so far.
>
> The webbook says there is support for pyodbc but I cannot find any
> examples of the connection string.    The one that works in python
> that I'm trying to adapt is:
>
> db =

> DAL('pyodbc:"DRIVER={Teradata};DBCNAME=MyDBTST;UID=username;PWD=password;QU­IETMODE=YES;"')