Re: Problems with SQLEXEC

Tech-Archive recommends: Fix windows errors by optimizing your registry

Hi Olaf,

I think this goes wrong, if the used driver is "SQL Native Client"
instead of "SQL Server". Another problem with the Native Client
driver was Varchar(MAX) sometimes retrieved as C(0) (depending
on the first row of the resultset). SQL Native Client seems to
"optimize" the resultset or VFP has it's usual way of determining
the record structure.

Was the schema-property set and CA configured to use the schema ?
My first thought would be to enforce the resulting cursorschema this way.

I think with "Driver=SQL Server" in the connection string everything
is fine including the Varchar(Max) problem. I try to reproduce those
errors.

thanks

thomas
.

Relevant Pages

  • Re: sqlCeResultSet readPrevious() method doesnt work always after a readAbsolut(currentPosition)
    ... > In my program i use a sqlCeResultSet for accessing my data. ... > When i execute a readPreviousafterwards, the resultset stays at the ... > sql server compact edition 3.1, ... > for me that seems to be a bug in the sql server compact edition. ...
    (microsoft.public.sqlserver.ce)
  • Re: SQL Server 2005 connection issues.
    ... Perhaps all your other computers connect with TCP\IP and the problem computers have Named Pipes as the preferred protocol instead of TCP\IP. ... To check the client protocols, use SQL Server Configuration Manager on the client computer, expand SQL Native Client, click Client Protocols, and then look at the order in the list. ... Could not open a connection to SQL Server." ...
    (microsoft.public.sqlserver.clients)
  • Re: Connection String SQL
    ... All my new dev work will be done in C# ... Store the connection string information in a config file that is ... As for the SQL Server Native client ... ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: When do selects execute for multiple resultsets
    ... SQL Server executes each query and stops when its ... When the first resultset is ... The CommandTimeout is measured from the time you execute the query until the ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: FTS query performance on SQL 2005
    ... Basically what i do is bank on the fact that it is rare for most people to ... believe this is because the full resultset is returned from the FTE back ... SQL Server, and then the count is taken on that. ... but I'd like to also display "Showing results ...
    (microsoft.public.sqlserver.fulltext)