OLE DB error trace Non-interface error.

Hi ,
When I try running the below sql on MSDE i am getting this error, Can some
one pls help.
It works fine on other systems where SQL Server 2000 is installed.
Select * into Brand FROM OPENROWSET('MSDASQL.1','test1';'sa';'pat','select
* from [BRAND]')
This is the detail error msg when when i set TRACEON (7300, 3604).
Server: Msg 7330, Level 16, State 2, Line 1
Could not fetch a row from OLE DB provider 'MSDASQL.1'.
OLE DB error trace [Non-interface error: OLE DB provider MSDASQL.1 returned
an incorrect value for DBPROP_CONCATNULLBEHAVIOR which should be either
DBPROPVAL_CB_NULL or DBPROPVAL_CB_NON_NULL].
OLE DB error trace [OLE/DB Provider 'MSDASQL.1' IRowset::GetNextRows
returned 0x80040155].
MSDE version
Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation
Desktop Engine on Windows NT 5.2 (Build 3790: )
SQl Server Driver Version : 2000.85.1022.00
Thanks & Regards,
Ashish.Ashish P K wrote:
> Hi ,
> When I try running the below sql on MSDE i am getting this error,
> Can some one pls help.
> It works fine on other systems where SQL Server 2000 is installed.
>
> Select * into Brand FROM
> OPENROWSET('MSDASQL.1','test1';'sa';'pat','select * from [BRAND]')
Why not use the native SQL Server provider? SQLOLEDB instead of MSDASQL.
Bob Barrows
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.|||Hi,
When I tried with SQLOLEDB it worked, but I need to use DSN connection
with the OPENROWSET, So I think , need to use MSDASQL only.
Sql Server (MSDE) is on windows 2003 machine..whether this can cause any
problem?
Regards,
Ashish.
"Bob Barrows [MVP]" <reb01501@.NOyahoo.SPAMcom> wrote in message
news:%23Bq1SfRDFHA.3120@.TK2MSFTNGP12.phx.gbl...
> Ashish P K wrote:
> Why not use the native SQL Server provider? SQLOLEDB instead of MSDASQL.
>
> Bob Barrows
> --
> Microsoft MVP -- ASP/ASP.NET
> Please reply to the newsgroup. The email account listed in my From
> header is my spam trap, so I don't check it very often. You will get a
> quicker response by posting to the newsgroup.
>|||Ashish P K wrote:
> Hi,
> When I tried with SQLOLEDB it worked, but I need to use DSN
> connection with the OPENROWSET,
Why?

> So I think , need to use MSDASQL only.
> Sql Server (MSDE) is on windows 2003 machine..whether this can cause
> any problem?
MSDASQL has be deprecated for at least 3 versions of MDAC. New functionality
that has been added to SQLOLEDB in those three revisions may not be provided
by MSDASQL.
Bob Barrows
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.