Could not find stored procedure

I used ASP + mssql and got the following error:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC SQL Server Driver][SQL Server]Could not find stored
procedure 'my_db..po_fundprice_listVal'.
what is the error?
and how to solve it?
many many thanks.If you are sure the stored procedure exists, I suggest you check the server
name and database context specified in the connection string to be certain
you are looking in the correct database.
--
Hope this helps.
Dan Guzman
SQL Server MVP
<Blue> wrote in message news:ekYzXX8jEHA.3632@.TK2MSFTNGP09.phx.gbl...
>I used ASP + mssql and got the following error:
> Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
> [Microsoft][ODBC SQL Server Driver][SQL Server]Could not find stored
> procedure 'my_db..po_fundprice_listVal'.
>
> what is the error?
> and how to solve it?
> many many thanks.
>|||thanks for your reply.
since i am a newbie of sql server, how can I check whether the stored
procedure exists?
should I open the enterpise manager to check?
moreover, the db is newly given to us and we just import from the previous
vendor who exported all the data as a mdb file.
is it possible that they forgot to give us the stored procedure records?
thanks again. :-)
"Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> ¦b¶l¥ó
news:%23aufNl8jEHA.3852@.tk2msftngp13.phx.gbl ¤¤¼¶¼g...
> If you are sure the stored procedure exists, I suggest you check the
server
> name and database context specified in the connection string to be certain
> you are looking in the correct database.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> <Blue> wrote in message news:ekYzXX8jEHA.3632@.TK2MSFTNGP09.phx.gbl...
> >I used ASP + mssql and got the following error:
> >
> > Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
> > [Microsoft][ODBC SQL Server Driver][SQL Server]Could not find stored
> > procedure 'my_db..po_fundprice_listVal'.
> >
> >
> > what is the error?
> > and how to solve it?
> > many many thanks.
> >
> >
>|||You can use the object browser in SQL Server Enterprise Manager or Query
Analyzer to see if the procedure exists. Expand the desired database node
and then stored procedures.
I'm not sure exactly what you and the vendor did to export/import the SQL
Server database but there are no stored procedures in and Access mdb.
Perhaps this is why the proc was omitted in the process ...
--
Hope this helps.
Dan Guzman
SQL Server MVP
<Blue> wrote in message news:etoMlr8jEHA.2764@.TK2MSFTNGP11.phx.gbl...
> thanks for your reply.
> since i am a newbie of sql server, how can I check whether the stored
> procedure exists?
> should I open the enterpise manager to check?
> moreover, the db is newly given to us and we just import from the previous
> vendor who exported all the data as a mdb file.
> is it possible that they forgot to give us the stored procedure records?
> thanks again. :-)
> "Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> ¦b¶l¥ó
> news:%23aufNl8jEHA.3852@.tk2msftngp13.phx.gbl ¤¤¼¶¼g...
>> If you are sure the stored procedure exists, I suggest you check the
> server
>> name and database context specified in the connection string to be
>> certain
>> you are looking in the correct database.
>> --
>> Hope this helps.
>> Dan Guzman
>> SQL Server MVP
>> <Blue> wrote in message news:ekYzXX8jEHA.3632@.TK2MSFTNGP09.phx.gbl...
>> >I used ASP + mssql and got the following error:
>> >
>> > Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
>> > [Microsoft][ODBC SQL Server Driver][SQL Server]Could not find stored
>> > procedure 'my_db..po_fundprice_listVal'.
>> >
>> >
>> > what is the error?
>> > and how to solve it?
>> > many many thanks.
>> >
>> >
>>
>|||ic... thanks
"Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> ¦b¶l¥ó
news:%23nKyaS9jEHA.592@.TK2MSFTNGP11.phx.gbl ¤¤¼¶¼g...
> You can use the object browser in SQL Server Enterprise Manager or Query
> Analyzer to see if the procedure exists. Expand the desired database node
> and then stored procedures.
> I'm not sure exactly what you and the vendor did to export/import the SQL
> Server database but there are no stored procedures in and Access mdb.
> Perhaps this is why the proc was omitted in the process ...
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> <Blue> wrote in message news:etoMlr8jEHA.2764@.TK2MSFTNGP11.phx.gbl...
> > thanks for your reply.
> > since i am a newbie of sql server, how can I check whether the stored
> > procedure exists?
> > should I open the enterpise manager to check?
> >
> > moreover, the db is newly given to us and we just import from the
previous
> > vendor who exported all the data as a mdb file.
> > is it possible that they forgot to give us the stored procedure records?
> >
> > thanks again. :-)
> >
> > "Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> ¦b¶l¥ó
> > news:%23aufNl8jEHA.3852@.tk2msftngp13.phx.gbl ¤¤¼¶¼g...
> >> If you are sure the stored procedure exists, I suggest you check the
> > server
> >> name and database context specified in the connection string to be
> >> certain
> >> you are looking in the correct database.
> >>
> >> --
> >> Hope this helps.
> >>
> >> Dan Guzman
> >> SQL Server MVP
> >>
> >> <Blue> wrote in message news:ekYzXX8jEHA.3632@.TK2MSFTNGP09.phx.gbl...
> >> >I used ASP + mssql and got the following error:
> >> >
> >> > Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
> >> > [Microsoft][ODBC SQL Server Driver][SQL Server]Could not find stored
> >> > procedure 'my_db..po_fundprice_listVal'.
> >> >
> >> >
> >> > what is the error?
> >> > and how to solve it?
> >> > many many thanks.
> >> >
> >> >
> >>
> >>
> >
> >
>