General information
Forum:
Microsoft SQL Server
Title:
Sql sever call to vfp
Environment versions
SQL Server:
SQL Server 2005
Hi All,
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?
TIA
Beth
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only