P
Patrick Temple
I'm trying to make a data connection using the data connection wizard and
modifying the sql statement. I enter the following call to a stored
procedure:
exec "dbo"."addnewId"
When I test the sql, it actually makes the call and executes the stored
procedure but the wizard gives me an sql error about not returning any data.
So it won't allow me to finish the data connection.
The form this is for, uses a XML schema as its main data source not a
database connection. So if I can't make the connection I'm in trouble.
I've seen the articles on calling a stored procedure from script but those
examples also assumed you used a database connection as your main connection.
So if there is a way to script the connection that would work as well.
Any help would be appreciated.
modifying the sql statement. I enter the following call to a stored
procedure:
exec "dbo"."addnewId"
When I test the sql, it actually makes the call and executes the stored
procedure but the wizard gives me an sql error about not returning any data.
So it won't allow me to finish the data connection.
The form this is for, uses a XML schema as its main data source not a
database connection. So if I can't make the connection I'm in trouble.
I've seen the articles on calling a stored procedure from script but those
examples also assumed you used a database connection as your main connection.
So if there is a way to script the connection that would work as well.
Any help would be appreciated.