Re: Errors with SqlSoup

"Jonathan Ellis" <[email protected]> Fri, 25 Aug 2006 21:14:01 -0700
Newsgroups gmane.comp.python.spyce.general
Message-ID <[email protected]>
On Sat, 26 Aug 2006 00:01:47 -0400, "Dustin" <[email protected]> said:
> Are there any library requirements for utilizing SqlSoup db connection
> strings? When I setup the following connection string to a Postgre
> database like such:
>  
> db = SqlSoup('postgres://username:password@localhost/database') (with
> username/password/database filled in of course)
>  
> it results in the following error:
>  
> [Fri Aug 25 23:58:35 2006] [error] PythonHandler
> run_spyceModpy::spyceMain: InvalidRequestError: Cant get DBAPI module for
> dialect '<sqlalchemy.databases.postgres.PGDialect object at 0x1133a44c>'
> I installed psycopg2 just in case but that didn't resolve the issue. I
> don't believe it's a permissions issue of any sort - 99.9827% sure.

You do need psycopg2.

Does "import psycopg2" work outside of Spyce?
-- 
C++ is history repeated as tragedy. Java is history repeated as farce.  --Scott McKay


-------------------------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642