Hi, this is my installation :
Platform: Win
Python Version: 2.5.2 on win32
Dabo Version: Version 0.9.1; Revision ~5017
UI Version: 2.8.8.1 on wxMSW
Yesterday I downloaded and installed "pymssql-1.0.1.win32-py2.5.exe",
tried it in Dabo and did not work. So I went back just by running
"pymssql-0.8.0.win32-py2.5.exe" on top of the previous installation. And
I copied your "pymssql.py" into site-packages replacing the original.
Then I test it :
---------------------------------------------------------------------------------------------------------------------
>>> import pymssql
>>> pymssql.__version__
'0.8.0'
>>> conn = pymssql.connect(user='someuser', password='somepasswd',
host='somehost', database='somedb')
>>> cursor = conn.cursor()
>>> cursor.execute('select TablasVSID, Nombre from TablasVs (NOLOCK)')
>>> cursor.rowcount
7
>>> class reg(object):
... def __init__(self, cursor, registro):
... for (attr, val) in zip((d[0] for d in cursor.description),
registro) :
... setattr(self, attr, val)
...
>>> for row in cursor.fetchall() :
... r = reg(cursor, row)
... print r.TablasVSID, r.Nombre
...
1 ABCodOp
2 ABMovStock
3 ABAlmacen
4 ABGrupo
5 ABTipo
6 ABUnidad
7 ABArticulo
>>>
---------------------------------------------------------------------------------------------------------------------
So everything seems Ok.
Now to dabo, generate a connection, it tests ok :
---------------------------------------------------------------------------------------------------------------------
<?xml version="1.0" encoding="utf-8" standalone="yes"?>
<connectiondefs xmlns="http://www.dabodev.com";
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance";
xsi:schemaLocation="http://www.dabodev.com conn.xsd"
xsi:noNamespaceSchemaLocation = "http://dabodev.com/schema/conn.xsd";>
<connection dbtype="MsSQL">
<name>SomeName</name>
<host>SomeHost</host>
<database>SomeDB</database>
<user>SomeUser</user>
<password>E1123423134512347R89</password>
<port>1433</port>
</connection>
</connectiondefs>
---------------------------------------------------------------------------------------------------------------------
Open the Class Designer, on the dPanel rightClick->Add Controls from
Data Environment, and in comes the wizard.
Click on "Open a connection file", look for my connection, select it,
then click on "Next" and it does nothing, the window is still responding
as if the button had no code. If I select "sample" and click Next the
wizard informs me that it cannot connect to Sample, but with my
sqlserver connection nothing happens. Even if I create a new connection
on the spot and test ok then the Next button will do nothing.
Any ideas on how could I trace what's going on?
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users
Searchable Archives: http://leafe.com/archives/search/dabo-users
This message: http://leafe.com/archives/byMID/[email protected]
