> On Tuesday 19 June 2007 17:07, johnf wrote: >> Additional question: >> Do you have more than one instance of MS SQL running (if so what are their >> names). >> >> Still would like to see the SQL trace. > > Some items I'd like you to try: > > In the directory you downloaded psmssql.py to there should be a two programs. > 1. test.py > 2. apitest_mssql.py > > The files bypass Dabo and the pymssql.py files and work only with _mssql.py > (the low level interface to ntwdblib.dll). > > I think using the apitest_mssql.py would be the best for testing. You will > have to edit only the top few lines. Make sure you add the port in one of > the test. > > With the SQL in the Wins Auth mode run. You can edit as follows for one of > the test. > > #EDIT HERE######################################## > > HOST="localhost" > USER="sa" > PASSWORD="" > DATABASE="tempdb" > > To add a port it would be: > HOST="localhost:1433" > > Every parameter is required. >
John, I'm going to have to plead ignorance on both counts here. I can't find the two test programs you mention in the pymssql.zip that I downloaded from the pymssql sourceforge site: http://sourceforge.net/project/showfiles.php?group_id=40059 Also - for the trace, can you point me in the right direction? I found something called "C2 audit tracing" which when turned on generated a 1.5Mb file in about 2 minutes. The file appears to be something that can only be opened in something called Sql Profiler. I scanned it but did not see my login attempts. It mostly looked like internal database mumblings. I didn't see anything else that looked like a trace capability. Bill. _______________________________________________ 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/dabo-users/[EMAIL PROTECTED]
