[AccessD] A97 SQL Server

Try adding a space after _byRoute and before the closing quote.

Regards

David
Dalyn Software Ltd
New Zealand

At 29/04/2011, b heygood wrote:
>having a "ODBC - Call failed" message from A97 when running the code below.
>RTE is a long var.
>code generates no errors up to the last line.
>I can link to tables using the log on info and password successfully.
>
>any ideas??
>
>
>
>'populate the object variables
>Set wkTest = CreateWorkspace("ODBCWorkspace", "admin", "", dbUseODBC)
>Set conTest = wkTest.OpenConnection("CONNECTION", dbDriverNoPrompt, True,
>CONNECT_STR)
>conTest.QueryTimeout = 0
>
>'Execute the stored procedure (SQL Server 7.0)
>DoEvents
>conTest.Execute "EXEC sp_Add_FutureServicesOrders_byRoute" & RTE
>
>--
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com