Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
West Wind have a problem with CA?
Message
De
02/11/2010 06:46:07
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
 
Information générale
Forum:
Visual FoxPro
Catégorie:
West Wind Web Connection
Versions des environnements
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Database:
Visual FoxPro
Application:
Web
Divers
Thread ID:
01487784
Message ID:
01487835
Vues:
92
Hi Rick,
It seems to be caused by WC. I have 2 set of CA classes, one based on SQL and other VFP (cursorschema, select command, conversiofunc ... and the core is same connecting via ADO). Depending on the mode at a time (VFP or SQL) a CA cursor is created using one of the classes. These have been working for quite a time from VFP exe, or as a VFP COM server used in a Silverlight project. With WC however, when I changed mode to VFP it started to give this error. To test it, in the Process method I tried to directly open anyone of them and do nothing. It consistently gives this error and the CA cursor is not opened. Outside WC it works very well. Tried both in COM and File mode but I was desperate might have missed something. Will try again. Note that it works very well if the connection is SQL server, fails with VFPOLEDB.

Update: You were right. It works under file based messaging.

Cetin

>Cetin,
>
>Web Connection does nothing to change the base operation of Visual FoxPro, so whatever the error is, it's not likely to be caused by Web Connection per se...
>
>Are you running in COM mode? File Mode? It's possible that VFP under COM operation behaves differently when dealing with ADO recordsets???
>
>A type conversion usually means that the wrong cursor is open - maybe a work area is switched the wrong way when the import occurs.
>
>+++ Rick ---
>
>>I get this message when I try to create an ADO based cursoradapter against VFP tables:
>>
>>"Type conversion required by the DataType property for field 'Rec_id' is invalid."
>>
>>rec_id is I on source and cursorschema. I get this on every table I attempted to use via a west wind application. Outside WC I don't have this problem. That makes me think that it may be some sort of security (that makes no sense to me). Anyone have fix?
>>TIA
>>
>>Update: The same table also exist on SQL Server. If I switch to SQL server (change connection string and provider in CA connection) it works perfectly well. The problem is with VFPOLEDB and VFP tables.
>>
>>Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform