[sqlalchemy] Re: Connecting to a Microsoft Access Database
Hi,
access:///VMCPDB.mdb
Three slashes! The hostname is empty. And you want the full path to the .mdb
file.
Paul
On 10/18/07, Eddie [EMAIL PROTECTED] wrote:
Latest Version still gives me problems
still in the same engine = create_engine('access://VMCPDB') line.
Debug looks like the newest rev installed correctly...
any help would be nice...
[ Things before line 105 are unrelated to SA.. besides the import
lines :) ]
Traceback (most recent call last):
File monitor.py, line 105, in module
engine = create_engine('access://VMCPDB')
File c:\python25\lib\site-packages\SQLAlchemy-0.4.1dev_r3640-
py2.5.egg\sqlalchemy\engine\__init__
.py, line 173, in create_engine
return strategy.create(*args, **kwargs)
File c:\python25\lib\site-packages\SQLAlchemy-0.4.1dev_r3640-
py2.5.egg\sqlalchemy\engine\strategi
es.py, line 67, in create
(cargs, cparams) = dialect.create_connect_args(u)
File c:\python25\lib\site-packages\SQLAlchemy-0.4.1dev_r3640-
py2.5.egg\sqlalchemy\databases\acces
s.py, line 208, in create_connect_args
connectors.append(Dbq=%s % opts[database])
KeyError: 'database'
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups
sqlalchemy group.
To post to this group, send email to sqlalchemy@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~--~~~~--~~--~--~---
[sqlalchemy] Re: Connecting to a Microsoft Access Database
Latest Version still gives me problems
still in the same engine = create_engine('access://VMCPDB') line.
Debug looks like the newest rev installed correctly...
any help would be nice...
[ Things before line 105 are unrelated to SA.. besides the import
lines :) ]
Traceback (most recent call last):
File monitor.py, line 105, in module
engine = create_engine('access://VMCPDB')
File c:\python25\lib\site-packages\SQLAlchemy-0.4.1dev_r3640-
py2.5.egg\sqlalchemy\engine\__init__
.py, line 173, in create_engine
return strategy.create(*args, **kwargs)
File c:\python25\lib\site-packages\SQLAlchemy-0.4.1dev_r3640-
py2.5.egg\sqlalchemy\engine\strategi
es.py, line 67, in create
(cargs, cparams) = dialect.create_connect_args(u)
File c:\python25\lib\site-packages\SQLAlchemy-0.4.1dev_r3640-
py2.5.egg\sqlalchemy\databases\acces
s.py, line 208, in create_connect_args
connectors.append(Dbq=%s % opts[database])
KeyError: 'database'
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups
sqlalchemy group.
To post to this group, send email to sqlalchemy@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~--~~~~--~~--~--~---
[sqlalchemy] Re: Connecting to a Microsoft Access Database
On Oct 16, 11:13 pm, Eddie [EMAIL PROTECTED] wrote: Having problems all day connecting and tried various apps just in case... is there anyway I could get someone to zip and host this really quick? Error * PROPFIND request failed on '/sqlalchemy/trunk' PROPFIND of '/ sqlalchemy/trunk': could not connect to server (http:// svn.sqlalchemy.org) Connect you through a proxy server ? --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups sqlalchemy group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~--~~~~--~~--~--~---
[sqlalchemy] Re: Connecting to a Microsoft Access Database
Hi, Thanks for the help. Looks like I'm still stuck though. Use the latest SVN version of SA 0.4, where I've fixed this issue. You'll need to do something like: svn checkout http://svn.sqlalchemy.org/sqlalchemy/trunk sqlalchemy cd sqlalchemy setup.py develop Paul --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups sqlalchemy group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~--~~~~--~~--~--~---
[sqlalchemy] Re: Connecting to a Microsoft Access Database
Having problems all day connecting and tried various apps just in case... is there anyway I could get someone to zip and host this really quick? Error * PROPFIND request failed on '/sqlalchemy/trunk' PROPFIND of '/ sqlalchemy/trunk': could not connect to server (http:// svn.sqlalchemy.org) Otherwise, I have to traverse the paths and download file by file? On Oct 16, 2:14 am, Paul Johnston [EMAIL PROTECTED] wrote: Hi, Thanks for the help. Looks like I'm still stuck though. Use the latest SVN version of SA 0.4, where I've fixed this issue. You'll need to do something like: svn checkouthttp://svn.sqlalchemy.org/sqlalchemy/trunksqlalchemy cd sqlalchemy setup.py develop Paul --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups sqlalchemy group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~--~~~~--~~--~--~---
[sqlalchemy] Re: Connecting to a Microsoft Access Database
Thanks for the help. Looks like I'm still stuck though.
my code crashes after just 2 lines
from sqlalchemy import *
engine = create_engine('access://VMCPDB', echo=True)
The dump is as follows:
Traceback (most recent call last):
File C:\test.py, line 8, in module
engine = create_engine('access://VMCPDB', echo=True)
File build\bdist.win32\egg\sqlalchemy\engine\__init__.py, line
159, in create_engine
File build\bdist.win32\egg\sqlalchemy\engine\strategies.py, line
64, in create
File build\bdist.win32\egg\sqlalchemy\databases\access.py, line
187, in __init__
File build\bdist.win32\egg\sqlalchemy\engine\default.py, line 49,
in __init__
TypeError: preparer() takes exactly 1 argument (2 given)
Was wondering if anyone with experience /w Access db's and SA could
see if there is a quick fix?
Also, I just want to assert that the library files used are stored
inside the SA .egg file, making it rather hard to debug within the
code. Is this correct?
I am 99% sure that this isn't connected to the issue, but my mdb file
is registered as a user DSN (named 'VMCPDB'), and is verified to be
valid, if it helps...
On Oct 13, 4:19 am, Paul Johnston [EMAIL PROTECTED] wrote:
Hi,
Just curious but where would I look to find out that I needed to use
access instead of mssql?
At the moment, just by reading the source! This is what I mean by
_experimental_ support. If access support becomes more solid, the docs
will be updated to mention it.
just want to make sure I can read as much as I can before posting
another question.
Ask away.
Paul
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups
sqlalchemy group.
To post to this group, send email to sqlalchemy@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~--~~~~--~~--~--~---
[sqlalchemy] Re: Connecting to a Microsoft Access Database
On Oct 13, 2:13 am, Eddie [EMAIL PROTECTED] wrote:
engine = create_engine('mssql://VMCPDB', echo=True)
I think thi line is the error. Like previous post you should use access://
URI not tested:
engine = create_engine('access://VMCPDB', echo=True)
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups
sqlalchemy group.
To post to this group, send email to sqlalchemy@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~--~~~~--~~--~--~---
[sqlalchemy] Re: Connecting to a Microsoft Access Database
Thank your Paul (and Expo!) Just curious but where would I look to find out that I needed to use access instead of mssql? I did indeed go to that web page as well as scour some other resources, but nothing ever specifically mentioned access:///... just want to make sure I can read as much as I can before posting another question. Thanks again for your help! On Oct 12, 5:13 pm, Paul Johnston [EMAIL PROTECTED] wrote: Hi, I am very sorry for asking this question, but I was wondering if anyone could give me a short step by step process as to how to access a Microsoft Access Database using SQLAlchemy. Access support is experimental. Use the lastest 0.4 trunk, as I've committed a few fixes just now. Beyond that, all you do is use SQLAlchemy as with any other database. The DBURI is like access:///c:/my/file.mdb There's some more info here:http://www.sqlalchemy.org/trac/wiki/DatabaseNotes#MicrosoftAccess Paul --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups sqlalchemy group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~--~~~~--~~--~--~---
[sqlalchemy] Re: Connecting to a Microsoft Access Database
Eddie, Eddie wrote: Thank your Paul (and Expo!) Just curious but where would I look to find out that I needed to use access instead of mssql? You might want to check the documentation: http://www.sqlalchemy.org/docs/04 More specifically: http://www.sqlalchemy.org/docs/04/documentation.html#dbengine And then there are some notes per engine here (check the end of this page for Acess): http://www.sqlalchemy.org/trac/wiki/DatabaseNotes Werner --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups sqlalchemy group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~--~~~~--~~--~--~---
[sqlalchemy] Re: Connecting to a Microsoft Access Database
Hi, I am very sorry for asking this question, but I was wondering if anyone could give me a short step by step process as to how to access a Microsoft Access Database using SQLAlchemy. Access support is experimental. Use the lastest 0.4 trunk, as I've committed a few fixes just now. Beyond that, all you do is use SQLAlchemy as with any other database. The DBURI is like access:///c:/my/file.mdb There's some more info here: http://www.sqlalchemy.org/trac/wiki/DatabaseNotes#MicrosoftAccess Paul --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups sqlalchemy group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~--~~~~--~~--~--~---
[sqlalchemy] Re: Connecting to a Microsoft Access Database
Just giving a little more information on what I can't figure out...
All I'd like to know is the few lines of code to open and connect to
an existing .mdb file.
So far, I have registered the mdb file as a DNS and named it VCPDB.
Three lines of my code look like:
metadata = MetaData()
engine = create_engine('mssql://VMCPDB', echo=True)
metadata.bind = engine
However, I can't insert into / query the db afterwards
ANY help would be greatly appreciated. Great job on SA so far. It
looks very impressive.
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups
sqlalchemy group.
To post to this group, send email to sqlalchemy@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~--~~~~--~~--~--~---
