MS-SQL demon select statement

[JPMacDonald]

Hi Bruce,

I wanted to bump this in case it fell off your to-do list.
 
This one is bizarre and I’m still debating if it’s a Clarion or Nettalk issue.
The environment is Clarion 10.12104, MSSQL 2008-14, NT9.05
 
I’ve have an application running for several years with C9 and NT8.6x, it runs solid but when I tried converting it to the later C10 builds it blows out when doing a very specific PropSQL call on a TurboSQL table. With all the chatter on the news groups about SQL issues in the current releases of C10 I chalked it up to that, particularly as if I put the MSSQL DLL from build 11822 in place it works again.
 
I prepared an example to report to SoftVelocity but the sample desktop app ran fine with the same query. So I built a very stripped down NT9 app to do the same thing and it crashes every time.
 
In the attached zip file are the 2 example apps I created (no dictionary required) both are designed to execute an SQL statement using a internally defined TurboSQL file and return the result. It also contains a backup of the sample MSSQL database they are both accessing, you would need to restore this to an SQL server of course.
 
Compile both apps, the desktop client when run has a menu option named “Open Form”, it will automatically populate the fields with the connect string which you need to change for your server, and the problematic SELECT statement. If you click the Execute SQL button several times it will return a total amount. Other values in the table besides 3100 that can be used in the WHERE clause are 3300 and 8393.
 
Run the web app and the server will crash on either the very first or second execution of the SQL statement.
 
If you remove the WHERE clause it will run successfully multiple times without issue.
 
So a Clarion driver or an NT issue with the new Clarion driver?
 
Thanks for looking.
 
Regards
 
Parker

[JPMacDonald]

bump

[osquiabro]

downloaded your app and run more than 100 times and no error, i think the problem is a SQL Client version, recently i have a conversion problem 6.3 NT to C10 and I thought that the problem is clarion but the problem is caused by a SQL Driver version, by default clarion use a older version installed in machine and you have to tell clarion that use a new version, try install SQL Client version 11 and force to use a last version in your connection string like this:

DRIVER={SQL Server Native Client 11.0}

[JPMacDonald]

Thanks for that but no joy.

SQL driver 10.0 was in place and I installed 11.0 (2011.110.5058.00)
Modified the connection string to force the use of version 11 of the driver and it still GPFs on the 2nd or 3rd try.

What version of C10 are you using when you compile and run this?
Are you getting a result back other than zero?

Regards

Parker

[osquiabro]

C10 11726, see image total number request 15 with ret value..

show me your connection string, my connection string is:

Windows8,bugDB,sa,*****;MARS_Connection=Yes;BUSYHANDLING=2;DRIVER={SQL Server Native Client 11.0}

[JPMacDonald]

Hi,

Yes, as mentioned this will work in C10 up to and including 11822 but it's broke in versions after that.
I think I have a work around for this for now.

Thanks for taking a look at this.

Regards

Parker

[osquiabro]

in what version don't work?

[kevin plummer]

Hi Parker,

what was your work around?