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 <[email protected]> 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 <[email protected]> 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 <[email protected]> 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 <[email protected]> > > > 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 <[email protected]> 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. > >
