b heygood
bheygood at abestsystems.com
Thu Apr 28 10:18:01 CDT 2011
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