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> bl
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...
>
|||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> bl
> news:%23aufNl8jEHA.3852@.tk2msftngp13.phx.gbl g...
> server
>
|||ic... thanks
"Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> bl
news:%23nKyaS9jEHA.592@.TK2MSFTNGP11.phx.gbl g...[vbcol=seagreen]
> 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...
previous
>
Showing posts with label odbc. Show all posts
Showing posts with label odbc. Show all posts
Wednesday, March 7, 2012
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.
> >> >
> >> >
> >>
> >>
> >
> >
>
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.
> >> >
> >> >
> >>
> >>
> >
> >
>
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 st
ored
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> bl
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...
>|||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> bl
> news:%23aufNl8jEHA.3852@.tk2msftngp13.phx.gbl g...
> server
>|||ic... thanks
"Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> bl
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...
previous[vbcol=seagreen]
>
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC SQL Server Driver][SQL Server]Could not find st
ored
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> bl
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...
>|||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> bl
> news:%23aufNl8jEHA.3852@.tk2msftngp13.phx.gbl g...
> server
>|||ic... thanks
"Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> bl
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...
previous[vbcol=seagreen]
>
Could not find file 'C:\WINDOWS\system32\dbo.mdb
Error message "OLE DB error: OLE DB or ODBC error: Could not find file 'C:\WINDOWS\system32\dbo.mdb'.; 3024. is reported when I try to process a cube in the SQL Server Management Studio and in the SQL Server Business Intelligence Development Studio.
What is the problem, I didn't install new software!!
Check the data source connection string. It looks like a Jet data source pointing to C:\WINDOWS\system32\dbo.mdb. Edit the data source in SQL Mgmt Studio and fix it.
|||This is not a data source connection problem, all the cubes are reporting the same error message!!|||If Analysis Services is raising this error, then this Jet connection string must be specified *somewhere*. Check the config file msmdsrv.ini (or server properties in mgmt studio). Maybe the query log or something else points to this mdb.|||This error message do not appear when I'm connected to the network, only when I work stand alone!!!
My connection string in the data source property window:
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Data\SQL2005Cubes\TBC_Europe.mdb
Subscribe to:
Posts (Atom)