Hi!
You can just check if SQL Server driver is used.
>Thanks daniel but the problem is I want to do it for all backends not just SQL Server.
>
>VFP
>SQL Server
>Oracle
>MSAccess
>DB2
>Oracle Lite DB
>ect...
>
>The problems is the properties on the connection are different for each backend and I need a common property or method to determine if I should use the stored procedure or SQL.
>
>I guess I can just build a case statement on the various provider's but a common property would be cleaner. If I ever decide to support a new system.
Vlad Grynchyshyn, Project Manager, MCP
vgryn@yahoo.comICQ #10709245
The professional level of programmer could be determined by level of stupidity of his/her bugs
It is not appropriate to say that question is "foolish". There could be only foolish answers. Everybody passed period of time when knows nothing about something.