[AccessD] A97 SQL Server

thanks, but no, that did not help.

 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of David Emerson
Sent: Thursday, April 28, 2011 1:09 PM
To: Access Developers discussion and problem solving; 'Access Developers
discussion and problem solving'
Subject: Re: [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

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com