Il 04/06/13 02:06, Nam Soo In ha scritto:
> I am trying to write a application that connects two DB
> I have locally running sqlite DB and I need to access one remote MSSql db.
> I have default set-up on sqlite and I am trying to setup MSSql db access.
> MSSql side I only have one given view name. I dont have access to
> other tables only one view.
> what is the way to set it up DAL?
> Thank you in advance.
Hi Nam,
if you have the complete description of the MSSql table create a second
DAL connection and define the view as you would do with a table following:
http://web2py.com/books/default/chapter/29/06#DAL,-Table,-Field
e.g.
mssqldb = DAL(<your string connection>)
mssqldb.define_table(<your table name>, Field(...), ...)
I hope I've been of any help
Cheers
Manuele
>
> --
>
> ---
> You received this message because you are subscribed to the Google
> Groups "web2py-users" group.
> To unsubscribe from this group and stop receiving emails from it, send
> an email to [email protected].
> For more options, visit https://groups.google.com/groups/opt_out.
>
>
--
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/groups/opt_out.
