Hi! All
We are in the process of development of a three-tier
financial accounting software. Our front end is delphi,
middle-tier is asta with delphi and third tier is ms sql
7. The application and database servers are residing on
the same machine in the USA through a web hosting service.
We are based in India. We have been provided with an asp
site to make any changes to the database - like
dropping/recreating etc. Two days back we created a stored
procedure for our application need.
We use a client data set component to access the stored
procedures. In the object browser of this component there
is "stored procedure" property which lists all the stored
procedure in the database. We are able to select the newly
created stored procedure from this list, but whenever we
are trying to execute this stored procedure it gives the
following error: "Invalid object name + procedure name".
Now to solve this problem we asked the web hosting people
to run a database script which also has this procedure
scripted. Everything works fine. Why is that whenever we
create an object from the asp site, we cannot access the
object? All the time we cannot ask those guys to run the
script for us. Kindly provide your insight in this
matter. This is really urgent.
Thanks
Jignesh