V
Vinod
Hi All,
I'm trying to execute below code which will restore test backup database in
sql server 2005 using stored procedure 'Restore_DB'
I'm getting an error 'Can not execute a select query' error no:'3065' while
'qdfPass.Execute' statement is running.
Where as I'm able to get select query result with same connection string but
stored procedure is not working.
Sub test1()
Dim qdfPass As DAO.QueryDef
Set qdfPass = Nothing
Set qdfPass = CurrentDb.CreateQueryDef("qryPass")
qdfPass.Connect = "ODBC;DRIVER={SQL
Server};SERVER=PERSONAL-C4775E\SQLEXPRESS;DATABASE=test;Trusted_Connection"
qdfPass.sql = "execute Restore_DB"
qdfPass.Execute
End Sub
Please help me resolving the issue.
Advanced Thanks
Vinod
I'm trying to execute below code which will restore test backup database in
sql server 2005 using stored procedure 'Restore_DB'
I'm getting an error 'Can not execute a select query' error no:'3065' while
'qdfPass.Execute' statement is running.
Where as I'm able to get select query result with same connection string but
stored procedure is not working.
Sub test1()
Dim qdfPass As DAO.QueryDef
Set qdfPass = Nothing
Set qdfPass = CurrentDb.CreateQueryDef("qryPass")
qdfPass.Connect = "ODBC;DRIVER={SQL
Server};SERVER=PERSONAL-C4775E\SQLEXPRESS;DATABASE=test;Trusted_Connection"
qdfPass.sql = "execute Restore_DB"
qdfPass.Execute
End Sub
Please help me resolving the issue.
Advanced Thanks
Vinod