Error open/accessing a MSSQL Linked Server

Hi!

Im having the fallowing error when I try to open/access a linked server
Error:
Error 7302: Could not create an instance of OLE DB provider 'MSOLAP.2'.
OLE DB error trace [Non-interface error: CoCreate of DSO for MSOLAP.2 returned 0x80004005].

I have already tried to create the server using SEM and also with SQL syntax in ISQLW.
Code:
EXEC sp_addlinkedserver
@.server='LINKED_OLAP',
@.srvproduct='',
@.provider='MSOLAP.2',
@.datasrc='MyServerName.MyDomain,
@.catalog='MyDataBase'

Im allowed to create the linked server but I cant use it.

Information:
OS: Windows 2003EE
SQL: MSSQL 2000 + SP3a
MDAC: MDAC2.8 rtm

Thanks,
Paulowhen referring to objects defined in a linked server, you should use the convention:
servername.databasename.userid.object|||That it's not the problem for sure.|||I'd see if any of Microsoft's (http://search.microsoft.com/search/results.aspx?view=msdn&st=b&na=82&qu=0x80004005+OLAP&s=1) ideas help.

-PatP|||Thanks, but none of the links apply to.

Paulo

Error on updating/adding record

I upsized (using Upsize Wizard) ACCESS back end to MSSQL 2000. Front end is still ACCESS. I'm getting error when trying to add or updated a record entry from front end.
The error message reads: 'Error # 3027 was generated by DAO.Recordset Cannot update. Database or object is read only.'

Thanks for any help.you should be using ADO not DAO

Error Messages

Does anyone know of a way to suppress the error messages while executing a stored procedure in MSSQL. Basically I don't want it yelling at me becuase the primary_key is invalid. I am using the @.@.ERROR object to do my own error catching and such. But when executing a SP from if it errors out it kills the program calling it, becuase of server error. Any help would be greatly appreciated.

ThanksGood programming practice is to check data validity before trying to insert it into a table. If a critical error occurs it will stop execution for the batch, so if you want to continue processing you need to separate batches (with GO statements) or enclose them in transactions.

blindman|||Thanks for the input. I have since added valididty checks in the code so that no critical errors should occur.

Error Message and (Hopefully) some guidance

I am trying to switch an application from SYBASE ASE12.5.1 to MSSQL 2000.
The application is a Java App running through TOMCAT. I have the JDBC
drivers installed and they are working correctly, since I can log in to the
app (which required DB access). I can also navigate through the app. When
I submit a report I get the following error:
[Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Invalid ob
ject name
'#utilization'.
The query that I am submitting runs flawlessly in Query Analyzer. I am
using Velocity to generate the queries and have to utilize temp tables (that
is what #utilization is).
I suspect that my ability to create Tmp tables as the web user is
suspicious, but during the normal operation of the app I am able to create
and drop temp tables as needed.
Thanks in advance
Harry
The actual query is below:
create table #period ( id numeric(6,2))
create table #facility ( id smallint)
insert into #period values ( 2002.00 )
insert into #period values ( 2002.25 )
insert into #period values ( 2002.50 )
insert into #period values ( 2002.75 )
insert into #facility
select hospital_code
from azal..hospital hospital
inner join azal..zip zip on hospital.zip_code = zip.zip_code
where ( (city='Phoenix' and state='AZ') )
create table #utilization
( pri_grp varchar(64) ,
sec_grp varchar(64) ,
ter_grp varchar(64) ,
qua_grp varchar(64) ,
qui_grp varchar(64) ,
cases numeric(16,4) NOT NULL,
days numeric(16,4) NOT NULL,
charges numeric(24,4) NOT NULL,
daystocases numeric(20,4) NOT NULL,
chargestocases numeric(24,4) NOT NULL,
relwght numeric(20,4) NOT NULL,
filtered int)
-- _GO_
INSERT INTO #utilization
SELECT
rdrg_specialty.rdrg_specialty_name
,
'',
'',
'',
'',
count(inpatient.case_id),
sum( inpatient.los ) ,
round(sum(inpatient.charge * 1.0),4),
round(sum(hospital_rdrg_all.st_total_days * 1.0 /
hospital_rdrg_all.st_total_cases ),4),
round(sum(hospital_rdrg_all.st_total_charges * 1.0 /
hospital_rdrg_all.st_total_cases ),4),
round(sum( hospital_rdrg_all.relative_weight ),4) ,0
FROM azal..inpatient inpatient,
azal..hospital_rdrg_all hospital_rdrg_all
, #period, #facility, azal..rdrg rdrg_sl, azal..rdrg_specialty
rdrg_specialty
WHERE hospital_rdrg_all.period_code = inpatient.period_code
AND hospital_rdrg_all.rdrg_code = inpatient.rdrg_code
AND hospital_rdrg_all.hospital_code = inpatient.hospital_code
and inpatient.period_code = #period.id
and inpatient.hospital_code = #facility.id
and inpatient.rdrg_code = rdrg_sl.rdrg_code AND rdrg_sl.rdrg_specialty_code
= rdrg_specialty.rdrg_specialty_code
GROUP BY rdrg_specialty.rdrg_specialty_name
-- ORDER BY rdrg_specialty.rdrg_specialty_name
-- ========================================
============
-- Primary Group Level
select
pri_grp,
round(sum(cases),4),
round(sum(days),4),
round(sum(charges),4),
round(sum(days) / sum(cases),4),
round(sum(daystocases) / sum(cases),4),
round(sum(charges) / sum(cases),4),
round(sum(chargestocases) / sum(cases),4),
round(sum(relwght) / sum(cases),4),
round(sum(days) / sum(daystocases),4),
round(sum(charges) / sum(chargestocases),4)
from #utilization
group by pri_grp
order by
2 desc,
pri_grp
--END Primary Group Level
-- ========================================
============
-- Report Totals, all data including filtered data
select
round(sum(cases),4),
round(sum(days),4),
round(sum(charges),4),
round(sum(days) / sum(cases),4),
round(sum(daystocases) / sum(cases),4),
round(sum(charges) / sum(cases),4),
round(sum(chargestocases) / sum(cases),4),
round(sum(relwght) / sum(cases),4),
round(sum(days) / sum(daystocases),4),
round(sum(charges) / sum(chargestocases),4)
from #utilization
-- _DROP_
truncate table #period
drop table #period
truncate table #facility
drop table #facility
truncate table #utilization
drop table #utilizationPerhaps several connections are opened for the SQL statements? Use Profiler
to trace the SQL actually
submitted to SQL Server.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Harry" <handersoiii@.msn.com> wrote in message news:uKRocsyFEHA.2580@.TK2MSFTNGP12.phx.gbl..
.
> I am trying to switch an application from SYBASE ASE12.5.1 to MSSQL 2000.
> The application is a Java App running through TOMCAT. I have the JDBC
> drivers installed and they are working correctly, since I can log in to th
e
> app (which required DB access). I can also navigate through the app. Whe
n
> I submit a report I get the following error:
> [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Invalid
object name
> '#utilization'.
> The query that I am submitting runs flawlessly in Query Analyzer. I am
> using Velocity to generate the queries and have to utilize temp tables (th
at
> is what #utilization is).
> I suspect that my ability to create Tmp tables as the web user is
> suspicious, but during the normal operation of the app I am able to create
> and drop temp tables as needed.
> Thanks in advance
> Harry
> The actual query is below:
> create table #period ( id numeric(6,2))
> create table #facility ( id smallint)
> insert into #period values ( 2002.00 )
> insert into #period values ( 2002.25 )
> insert into #period values ( 2002.50 )
> insert into #period values ( 2002.75 )
> insert into #facility
> select hospital_code
> from azal..hospital hospital
> inner join azal..zip zip on hospital.zip_code = zip.zip_code
> where ( (city='Phoenix' and state='AZ') )
>
>
> create table #utilization
> ( pri_grp varchar(64) ,
> sec_grp varchar(64) ,
> ter_grp varchar(64) ,
> qua_grp varchar(64) ,
> qui_grp varchar(64) ,
> cases numeric(16,4) NOT NULL,
> days numeric(16,4) NOT NULL,
> charges numeric(24,4) NOT NULL,
> daystocases numeric(20,4) NOT NULL,
> chargestocases numeric(24,4) NOT NULL,
> relwght numeric(20,4) NOT NULL,
> filtered int)
> -- _GO_
>
> INSERT INTO #utilization
> SELECT
> rdrg_specialty.rdrg_specialty_name
> ,
> '',
> '',
> '',
> '',
> count(inpatient.case_id),
> sum( inpatient.los ) ,
> round(sum(inpatient.charge * 1.0),4),
> round(sum(hospital_rdrg_all.st_total_days * 1.0 /
> hospital_rdrg_all.st_total_cases ),4),
> round(sum(hospital_rdrg_all.st_total_charges * 1.0 /
> hospital_rdrg_all.st_total_cases ),4),
> round(sum( hospital_rdrg_all.relative_weight ),4) ,0
> FROM azal..inpatient inpatient,
> azal..hospital_rdrg_all hospital_rdrg_all
> , #period, #facility, azal..rdrg rdrg_sl, azal..rdrg_specialty
> rdrg_specialty
> WHERE hospital_rdrg_all.period_code = inpatient.period_code
> AND hospital_rdrg_all.rdrg_code = inpatient.rdrg_code
> AND hospital_rdrg_all.hospital_code = inpatient.hospital_code
> and inpatient.period_code = #period.id
> and inpatient.hospital_code = #facility.id
> and inpatient.rdrg_code = rdrg_sl.rdrg_code AND rdrg_sl.rdrg_specialty_cod
e
> = rdrg_specialty.rdrg_specialty_code
> GROUP BY rdrg_specialty.rdrg_specialty_name
> -- ORDER BY rdrg_specialty.rdrg_specialty_name
>
> --
>
> -- ========================================
============
> -- Primary Group Level
> select
> pri_grp,
> round(sum(cases),4),
> round(sum(days),4),
> round(sum(charges),4),
> round(sum(days) / sum(cases),4),
> round(sum(daystocases) / sum(cases),4),
> round(sum(charges) / sum(cases),4),
> round(sum(chargestocases) / sum(cases),4),
> round(sum(relwght) / sum(cases),4),
> round(sum(days) / sum(daystocases),4),
> round(sum(charges) / sum(chargestocases),4)
> from #utilization
> group by pri_grp
> order by
> 2 desc,
> pri_grp
> --END Primary Group Level
>
>
>
> -- ========================================
============
> -- Report Totals, all data including filtered data
> select
> round(sum(cases),4),
> round(sum(days),4),
> round(sum(charges),4),
> round(sum(days) / sum(cases),4),
> round(sum(daystocases) / sum(cases),4),
> round(sum(charges) / sum(cases),4),
> round(sum(chargestocases) / sum(cases),4),
> round(sum(relwght) / sum(cases),4),
> round(sum(days) / sum(daystocases),4),
> round(sum(charges) / sum(chargestocases),4)
> from #utilization
>
> -- _DROP_
>
> truncate table #period
> drop table #period
> truncate table #facility
> drop table #facility
> truncate table #utilization
> drop table #utilization
>|||Thanks, it does appear that the query when being submitted is not staying
contained within 1 session, and spans 3 sessions, I am using connection
pooling with TOMCAT and will go look into that.
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:%23SDBVyyFEHA.3252@.TK2MSFTNGP11.phx.gbl...
> Perhaps several connections are opened for the SQL statements? Use
Profiler to trace the SQL actually
> submitted to SQL Server.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
>
> "Harry" <handersoiii@.msn.com> wrote in message
news:uKRocsyFEHA.2580@.TK2MSFTNGP12.phx.gbl...
2000.
the
When
name
(that
create
rdrg_sl.rdrg_specialty_code
>

Error message

I have installed the the MSSQL Server 2000 along with its
service pack 2. However, I am getting an error message
(pop window) that says:
isqlw.exe - Ordinal Not Found
"The ordinal 29 could not be located in the dynamic link
library odbcbcp.dll"
Please help me resolve this issue.
ThanksThe error is usually caused by MDAC issues (mismatched
dlls). Try applying the latest service pack (SP3a) or
reapply you mdac version. You can check versions with the
component checker. The component check and recent MDAC
versions are available for download from:
http://msdn.microsoft.com/data/mdac/default.aspx
-Sue
On Thu, 22 Apr 2004 13:06:36 -0700, "Ashraf"
<anonymous@.discussions.microsoft.com> wrote:

>I have installed the the MSSQL Server 2000 along with its
>service pack 2. However, I am getting an error message
>(pop window) that says:
>isqlw.exe - Ordinal Not Found
>"The ordinal 29 could not be located in the dynamic link
>library odbcbcp.dll"
>Please help me resolve this issue.
>Thanks
>

Error message

I have installed the the MSSQL Server 2000 along with its
service pack 2. However, I am getting an error message
(pop window) that says:
isqlw.exe - Ordinal Not Found
"The ordinal 29 could not be located in the dynamic link
library odbcbcp.dll"
Please help me resolve this issue.
Thanks
The error is usually caused by MDAC issues (mismatched
dlls). Try applying the latest service pack (SP3a) or
reapply you mdac version. You can check versions with the
component checker. The component check and recent MDAC
versions are available for download from:
http://msdn.microsoft.com/data/mdac/default.aspx
-Sue
On Thu, 22 Apr 2004 13:06:36 -0700, "Ashraf"
<anonymous@.discussions.microsoft.com> wrote:

>I have installed the the MSSQL Server 2000 along with its
>service pack 2. However, I am getting an error message
>(pop window) that says:
>isqlw.exe - Ordinal Not Found
>"The ordinal 29 could not be located in the dynamic link
>library odbcbcp.dll"
>Please help me resolve this issue.
>Thanks
>