Has anyone tested this further? I have an Access database that I'd like to parse for a web2py project. It's a live database that's too big to export to MySQL right now.
Thanks, Larry On Thursday, March 17, 2011 9:07:03 AM UTC-4, DenesL wrote: > > > It depends on how you want to connect. > The current mssql driver supports DSN connections: > mssql://the_dsn > > If you plan to use a different connection method please provide > examples to be able to code in the appropriate changes in the source. > > References that might be useful: > http://code.google.com/p/pyodbc/wiki/ConnectionStrings > http://www.connectionstrings.com/access > http://www.connectionstrings.com/access-2007 > > > On Mar 17, 5:04 am, Philnext <phil.pr...@gmail.com> wrote: > > I don't understand : how, with a "DAL('mssql: ...')", will pyodbc send > > the good connection string to tSQLDriverConnect for MS Access > > databases ? > > May you give an example of DAL connection string for connect to a > > 'mybase.mdb' Access database ? > > > > On 17 mar, 00:34, DenesL <denes1...@yahoo.ca> wrote: > > > > > There is no DAL('msaccess: ...'), not yet anyway. > > > > > You have to test using DAL('mssql: ...') or > > > DAL('mssql2: ...'). > > > > > On Mar 16, 7:15 pm, Philnext <phil.pr...@gmail.com> wrote: > > > > > > May you tell me the good connexion string for MS Access ? > > > > ( may be like "db = DAL('msaccess://mybase.mdb')" ?) > > > > > > (Sorry if this message is 'doubled') > > > > > > On 12 mar, 18:08, Massimo Di Pierro <massimo.dipie...@gmail.com> > > > > wrote: > > > > > > > Nobody has tried byt the mssql adapter (pyodbc) should work > withaccess. The SQL is the same. > > > > > Try and tel us know what problems you run into. > > > > > > > On Mar 12, 9:43 am, Philnext <phil.pr...@gmail.com> wrote: > > > > > > > > HelIo > > > > > > I saw in a last year post a question "do we have support forMS > > > > > >Access?" as I need it for my current projet I would know if there > is > > > > > > any previous dev. for it. > > > > > > Thanks. > > > >