I've been developing SQL Server 2000 for some time now, and frequently use Access as a front end. When running a stored procedure using ADO I generally use the cmd.Parameters("@param1"
= etc method. However, I'm working with SQL Server 7 and the moment and it doesn't like this one bit. I know there is a method of creating a parameter array which SQL 7 will accept, but I can't for the life of me remember the syntax. Any help?
= etc method. However, I'm working with SQL Server 7 and the moment and it doesn't like this one bit. I know there is a method of creating a parameter array which SQL 7 will accept, but I can't for the life of me remember the syntax. Any help?