Hi,
eng = sqlalchemy.create_engine
(mssql:///?dsn=mydsn,UID=myusername,PWD=mypass,module=pyodbc)
Try this:
eng = sqlalchemy.create_engine
(mssql://myusername:mypass@/?dsn=mydsn,module=pyodbc)
Paul
--~--~-~--~~~---~--~~
You received this message because you are
On Tue, Mar 25, 2008 at 9:21 AM, Paul Johnston [EMAIL PROTECTED] wrote:
Hi,
eng =
sqlalchemy.create_engine(mssql:///?dsn=mydsn,UID=myusername,PWD=mypass,module=pyodbc)
Try this:
eng =
sqlalchemy.create_engine(mssql://myusername:mypass@/?dsn=mydsn,module=pyodbc)
Still the same
we have a new hook that will be coming soon called something like
__reconstitute__(), which will be called on instances after they've
been created and had their initial population from the result row.
Note that eagerly-loaded collections might not be fully loaded at this
stage.
at the
On Mar 25, 2008, at 10:45 AM, vkuznet wrote:
Hi Mike,
now everything seems to work fine. Many thanks to you and all others
who contribute to the threads and solving the problem.
But, there is a but.
The schema is present everywhere, in Table and in Table object of the
column and foreign
Hello,
I am using sqlalchemy 4.0 in my application to connect to mysql database. I
am running quries through session object which is instantiated as a
(bind=engine, Transactional = True). I am not using threadlocal strategy. My
question is that If I open 10 connection simultaneouslty then
On Mar 25, 2008, at 1:36 PM, Ahmad Hassan wrote:
Hello,
I am using sqlalchemy 4.0 in my application to connect to mysql
database. I am running quries through session object which is
instantiated as a (bind=engine, Transactional = True). I am not
using threadlocal strategy. My
Great, I was just wondering. But glad to see confirmation. Yes we do
have a use case when the same tablenames cause weird behavior in
ORACLE. Below is a message from our DBA in response to hick-up when we
occasionally got:
ORA-00942: table or view does not exist error.
Valentin.
Ok, here is an example in ORACLE.
Table schema (for simplicity I removed unnecessary columns):
CREATE TABLE Block
(
IDinteger,
Name varchar(500) unique not null,
Path varchar(500) not null,
primary key(ID)
);
So
My research shows that ROW_NUMBER() OVER (ORDER BY somecol) is the
standard SQL approach to producing the LIMIT/OFFSET functions, which
is from this article:
http://troels.arvin.dk/db/rdbms/#select-limit
I used to use the select rownum directly approach you've outlined
below, but
Yes this works too. So you'll accept/fix the bug :)?
Thanks a lot
Valentin.
--~--~-~--~~~---~--~~
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
can you update the ticket please with a summary of this ?
also #999 is your schema issue.
On Mar 25, 2008, at 5:03 PM, vkuznet wrote:
Yes this works too. So you'll accept/fix the bug :)?
Thanks a lot
Valentin.
--~--~-~--~~~---~--~~
You received this
(sqlalchemy 0.4.4/pymssql/windows/pylons)
Our MS SQL legacy database has column names with spaces and sometimes
other special characters. I'm able to get sqlalchemy to work with it
by having every column object include quote=True, and by having the
mapper() call include:
,properties=
hi all,
I am a newbie with sqlalchemy so bear with me,this is what i am trying
to do
my app has a client and server part
on the client i am retreiving data using sqlalchemy and transfering
the query objects on to the server this goes fine but when i try to
open a new session on the server and
13 matches
Mail list logo