[web2py] Re: app uses SQLite but needs to also connect to MSSQL as well

2010-11-14 Thread mart
great! was going through the book and had just spotted something looking like that:) thanks :) One issue though: have been trying to connect to the remote mssql db for a while, and not really getting anywhere :( any tips and tricks with that one? I'm on MAC OS, 10.6 installed pyodbc the MSSQL db

[web2py] Re: app uses SQLite but needs to also connect to MSSQL as well

2010-11-14 Thread mdipierro
connect to mssql db.export_to_csv_file(file) change uri to connect to sqlite db.import_from_csv_file(file) Should work On Nov 14, 8:54 am, mart wrote: > I guess another question, is ... does the DAL support migrating the > MSSQL DB (MS SQL server 2005) to SQLite? > > Thanks > Mart :) > >

[web2py] Re: app uses SQLite but needs to also connect to MSSQL as well

2010-11-14 Thread mart
I guess another question, is ... does the DAL support migrating the MSSQL DB (MS SQL server 2005) to SQLite? Thanks Mart :) On Nov 14, 9:37 am, mart wrote: > sounds easy enough then :) I think I equated something I configured > wrong to something not supported. SO, will do the second connection

[web2py] Re: app uses SQLite but needs to also connect to MSSQL as well

2010-11-14 Thread mart
sounds easy enough then :) I think I equated something I configured wrong to something not supported. SO, will do the second connection as you suggest. Thanks for the reply :) Mart On Nov 14, 6:28 am, Nico de Groot wrote: > Hi Mart, > > No problem, you can define a second connection, say db_ms,

[web2py] Re: app uses SQLite but needs to also connect to MSSQL as well

2010-11-14 Thread Nico de Groot
Hi Mart, No problem, you can define a second connection, say db_ms, that connects to your ms sql database. And then query and insert across databases. Nico On 14 nov, 07:30, mart wrote: > Hi, > > So, application "build system" uses SQLite for most current and future > software builds. But woul