Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Sql sever call to vfp
Message
From
24/06/2008 13:05:40
 
General information
Forum:
Microsoft SQL Server
Category:
Other
Environment versions
SQL Server:
SQL Server 2005
Miscellaneous
Thread ID:
01326394
Message ID:
01326404
Views:
14
Do not know what this is. Can you explain more, or point me in the direction.

Thanks.
>Did you consider using SQL Server 2005 Service Broker?
>
>>
>>I am not sure if this is the correct place to post this.
>>
>>I am trying to create a trigger that will take the inserted information for the table and format it and pass it to another process. I have done this "in process" and it works fine, however "in-process" will take down the sql server if something nasty happens in the other process. I would like to make this "out of process", but foxpro wants the exe for this. When I use cmdshell I am limited to 256 characters in the arguements I am passing and that is not going to work. How do I call foxpro out of process without using commandshell from sql server? I tried the call from sql server using the 4(out of process) parameter with sp_OACreate, but is there something special I need to do in the foxpro exe to make this work?
>>
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform