>Wrote an application accessing SQL Server 6.5 on server
>using ODBC connection.
>1) Can't INSERT data at the server side.
> Used ODBC Ver 3.6 (Win 95 Ver C).
>
>2) Able to INSERT data at the server, using ODBC 2.5,
> (Win 95 Ver B).
>
>Both test were on different computers. Logged in using
>same user id and password.
>What could be the problem? Pls advise.Thanks.
I just wrestled with this last week. SQL 6.5 is VERY picky on the data passed to it, and it does not tell you what is wrong. A common problem is DATE and DATETIME data must be passed to SQL as character data: i.e. dtoc(date()) or ttoc(datetime()). In addition, SQL expects single quotes around them. The number of data elements passed from VFP must match exactly the number of parameters in your SQL stored procedure.
Dennis Schuette