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] <javascript:>> > >> 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/<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 >>>> <http://github.com/web2py/web2py>(Source code) >>>> - >>>> https://code.google.com/p/**web2py/issues/list<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 web2py+un...@**googlegroups.com. >>>> >>>> For more options, visit >>>> https://groups.google.com/**groups/opt_out<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] <javascript:>. >> 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.
