Charlotte Foust
charlotte.foust at gmail.com
Tue May 3 09:27:12 CDT 2011
It's been a long time, but I don't think it will work to try to specify the
name of the stored procedure using a variable like that. Someone else can
correct me if I'm having a senior moment.
Charlotte Foust
On Apr 28, 2011 8:19 AM, "b heygood" <bheygood at abestsystems.com> 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