web2py uses pyodbc to connect to MS SQL Server.
The connection string has the following format:
db=DAL("mssql://user:password@host/database")
If there are no differences in the SQL language betweeen MSSQL and
Teradata then you are in luck and the current adapter might just work.
On Jun 2, 1:52 am, Andrew <[email protected]> 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;"')
>
> Although pyodbc is a generic module, do I still need specfic Teradata
> support within web2py, which I assume doesn't exist ?
>
> Thanks
> Andrew
