Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Error with CA x ADO x SQL Server
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00945695
Message ID:
00945786
Views:
23
Fabio you are right.

Why when I use SQL Pass Through its run OK ?

SQL Pass Through use ODBC.

Result in SQL profile WITH CA/ADO
exec sp_executesql N'INSERT INTO "confeccao".."familia" ("CD_FAMILIA","DS_FAMILIA") VALUES (@P1,@P2)', N'@P1 varchar(4),@P2 varchar(30)', '0001', 'teste    
Result in SQL profile WITH SPT
INSERT INTO familia (cd_familia,ds_familia) values ('099','testee')
Paulo Cesar Carneiro
desenvolvimento@controplan.com.br


"My God, what have we done?"
-- Capt. Robert Lewis, co-pilot of the Enola Gay, recalling the moment the atomic bomb exploded over Hiroshima

At 8:15 a.m. on August 6 1945
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform