Clarion - Problems with Clarions TRACE program.

Author

Problems with Clarions TRACE program.

MikeV

2008-03-05, 3:55 am

Morning All
I have a very strange problem, my Clarion appeared to be broken.

My Clarion 6.3 9055 seemingly lost the ability to connect to my MS
SQL
Server 2005. in Windows XP Pro.
Yesterday I was trying to get Capesoft's FM3 to upgrade an SQL table
(done
many times before), also using the CW Trace program in the Examples
directory.
I then found every time I tried to compile and run, or just run ANY of
my
SQL table Apps I got the same result.
" SQL_Test_App has encountered a problem and needs to close. We are
sorry
etc etc. " and the two buttons "Send Error Report" and "Don't Send".
Also
Application Name SQL_Test_App
App. Version 0.0.0.0
Mod Name ntdll.dll
Module Version 5.7 2600.2180 Offset 0000001010.

I then tried to import a table from the SQL database into my
dictionary. I
select MSSQL as the file driver and instantly get in a GPF, every
time.

I have reinstalled SQL Server 2005.
I have recopied a disk copy of my Clarion installation to my Clarion6
directory.

Made no difference at all.

I then found the cause.

If I start the trace program and select MSSQL driver, click on Apply,
ALL IS
WELL.
All the SQL programs run fine and the dictionary SQL table import
works.
If I untick all the tick boxes for MSSQL on the trace program and
click
Apply, I get the program crashes as described above and cannot import
SQL
tables.

Of course I cannot have a trace file growing and growing on the
client
site.....:-)

How to I get rid of this connection/effect from the trace program on
my
Apps?

Any suggestions would be gratefully received.

Mike Valente

MikeV

2008-03-05, 7:55 am

Afternoon All
Problem solved.
After using the trace program it leaves a load of stuff in the WIN.INI
file
in C:\Windows/, which I commented out.
See Below....

;[Modified MIICSQL18.exe]
;[CWMSSQL]
;Trace=3D0
;TraceFile=3DC:\Documents and Settings\mike.MAIN\Desktop\TuTtrace.txt
;Profile=3D0
;Flush=3D1
;Details=3D1
;[CWADOSYNCHRONISER]
;Trace=3D0
;TraceFile=3DC:\Documents and Settings\mike.MAIN\Desktop\fleets_trace
;Profile=3D0
;Flush=3D0
;Details=3D1
;[Xtra_flange.exe]
;[Current Xtra.exe]
;[xtra5.exe]
;[SQLMID10.exe]
;[CWTOPSPEED]
;TraceFile=3DC:\DOCUME~1\MIKE~1.MAIN\Desktop\tpstrace.txt
;Profile=3D0
;Details=3D1
;Flush=3D0
;[CWVIEW]
;TraceFile=3D
;Profile=3D0
;TraceIntoFiles=3D0
;0
;TraceIntoFiles=3D0

;0
;TraceIntoFiles=3D0

;0
;TraceIntoFiles=3D0
;Flush=3D0

Cheers
Mike

On Mar 5, 9:43=A0am, MikeV <m...@mikeccc.demon.co.uk> wrote:
> Morning All
> I have a very strange problem, my Clarion appeared to be broken.
>
> My Clarion 6.3 9055 seemingly lost the ability to connect to my MS
> SQL
> Server 2005. in Windows XP Pro.
> Yesterday I was trying to get Capesoft's FM3 to upgrade an SQL table
> (done
> many times before), also using the CW Trace program in the Examples
> directory.
> I then found every time I tried to compile and run, or just run ANY of
> my
> SQL table Apps I got the same result.
> " SQL_Test_App has encountered a problem and needs to close. We are
> sorry
> etc etc. " and the two buttons "Send Error Report" and "Don't Send".
> Also
> Application Name SQL_Test_App
> App. Version 0.0.0.0
> Mod Name ntdll.dll
> Module Version 5.7 2600.2180 Offset 0000001010.
>
> I then tried to import a table from the SQL database into my
> dictionary. I
> select MSSQL as the file driver and instantly get in a GPF, every
> time.
>
> I have reinstalled SQL Server 2005.
> I have recopied a disk copy of my Clarion installation to my Clarion6
> directory.
>
> Made no difference at all.
>
> I then found the cause.
>
> If I start the trace program and select MSSQL driver, click on Apply,
> ALL IS
> WELL.
> All the SQL programs run fine and the dictionary SQL table import
> works.
> If I untick all the tick boxes for MSSQL on the trace program and
> click
> Apply, I get the program crashes as described above and cannot import
> SQL
> tables.
>
> Of course I cannot have a trace file growing and growing on the
> client
> site.....:-)
>
> How to I get rid of this connection/effect from the trace program on
> my
> Apps?
>
> Any suggestions would be gratefully received.
>
> Mike Valente

Sponsored Links