Yes i know how to connect to db2 with or without a dsn
I just want to know if i can tweak the autocomplete widget to query
directly an external odbc source.In my case a db2.
I just want to avoid having to copy some tables to my web2py sqlite because
this way i have to update it daily.
I think that as long as i have my db2 connection like
db = DAL('db2://DSN=MYDATABASE;UID=userid;PWD=password')
I can use it in my autocomplete widget right?
Best regards
António
2013/11/6 Derek <[email protected]>
> Do it the usual way like Niphlod said, the DSN stands for 'Data Source
> Name' and it's a DSN as defined in the ODBC setup. You'd have to configure
> that ODBC connection before setting up web2py to connect to it. In Linux,
> usually you have ODBCconfig, or a sys.odbc.ini file. On Windows, just go
> into admin, data sources (odbc).
>
>
> On Tuesday, November 5, 2013 7:26:07 AM UTC-7, Ramos wrote:
>
>> Because my db2 is not in a windows/linux/ machine.
>>
>> ITS ON A OS400 Machine
>>
>>
>> 2013/11/5 Niphlod <[email protected]>
>>
>> uhm, sorry. ADODB kinda make me point in that way.
>>> why aren't you able to connect to db2 using the "usual"
>>>
>>> db2://DSN=dsn;UID=user;PWD=pass
>>>
>>> notation ?
>>>
>>>
>>> On Monday, November 4, 2013 10:11:46 PM UTC+1, Ramos wrote:
>>>
>>>> I didnt say anything about microsoft Access. What the hell is that?
>>>> HEHEHE
>>>>
>>>> I´m using db2 via odbc
>>>>
>>>> Best regards
>>>> António
>>>>
>>>>
>>>> 2013/11/4 Niphlod <[email protected]>
>>>>
>>>>> DAL doesn't support Access as a database, so you can't expect the
>>>>> widget to work directly on your Access file.
>>>>> BTW, Access has really too many problems to be considered as a backend
>>>>> for a web application...
>>>>>
>>>>> That being said, if you want to experiment a little bit (please note
>>>>> that you could crash your computer AND your database to the ground, so I'm
>>>>> not taking any responsibility) is to create an odbc connection with a
>>>>> connectionstring
>>>>>
>>>>> http://www.connectionstrings.com/microsoft-access-odbc-driver/
>>>>>
>>>>> and using it with
>>>>>
>>>>> db2 = DAL('mssql://connectionstring')
>>>>>
>>>>> defining the tables you need with migrate=False (so they don't get
>>>>> created in the backend) and playing with those.
>>>>>
>>>>> --
>>>>> Resources:
>>>>> - http://web2py.com
>>>>> - http://web2py.com/book (Documentation)
>>>>> - http://github.com/web2py/web2py (Source code)
>>>>> - https://code.google.com/p/web2py/issues/list (Report Issues)
>>>>> ---
>>>>> 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.
>>>>>
>>>>
>>>> --
>>> Resources:
>>> - http://web2py.com
>>> - http://web2py.com/book (Documentation)
>>> - http://github.com/web2py/web2py (Source code)
>>> - https://code.google.com/p/web2py/issues/list (Report Issues)
>>> ---
>>> 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.
>>>
>>
>> --
> Resources:
> - http://web2py.com
> - http://web2py.com/book (Documentation)
> - http://github.com/web2py/web2py (Source code)
> - https://code.google.com/p/web2py/issues/list (Report Issues)
> ---
> 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.
>
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
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.
