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.
>
>

Reply via email to