Hello,

I would like to run a stored query from a script, but how do I do that ? I have tried this with no luck :(

Cheers
Per

Dim conn, rst, SQL_Table
Set conn = CreateObject("ADODB.Connection")
Set rst = CreateObject("ADODB.Recordset")

conn.ConnectionString = "Provider=MSDASQL;DSN=Database_1;UID=test;PWD=test;"
conn.CursorLocation = 3
conn.Open

SQL_Table = "EXEC C:\test\SQLQuery1.sql"
Set rst = conn.Execute(SQL_Table)



===> Solved
You need to create a procedure

CREATE PROCEDURE Test
AS
SELECT * FROM TestTable
GO

And use:
SQL_Table = "EXEC Test"