Problem with authentication prompting whilst fetching a report over the NET

Hi all,
I'm having a problem with accessing a report.
When I test it on my machine (2000 & reporting services installed on same
machine) there's no problem. As soon as I try to access it vie the internet
(I route through no-ip.org) then a window pops up wanting authentication. I
want to do away with this please.
How do I do this so no prompting occurs?
Regards
John.The authentication for a data source can be different for the dev env than
the production env... Go to the data source in the Prod env, and ensure
that something OTHER than prompt for credentials is set for the data
source...
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"John" <a@.b.c> wrote in message
news:%23iJ6eE7XFHA.2768@.tk2msftngp13.phx.gbl...
> Hi all,
> I'm having a problem with accessing a report.
> When I test it on my machine (2000 & reporting services installed on same
> machine) there's no problem. As soon as I try to access it vie the
> internet (I route through no-ip.org) then a window pops up wanting
> authentication. I want to do away with this please.
> How do I do this so no prompting occurs?
> Regards
> John.
>

Problem while fetching data from Oracle linked server

Hi,

I created a linked server as follows:

EXEC sp_addlinkedserver 'OracleLinkedServer', 'Oracle', 'MSDAORA', 'fcstage'

EXEC sp_addlinkedsrvlogin 'OracleLinkedServer', false, 'SA', 'fc_stage', 'password'

Now I try firing a simple select statement

SELECT FINANCIAL_TRX_INFO_ID FROM

[OracleLinkedServer]..[FC_STAGE].[WFS_FINANCIAL_TRX_INFO]

WHERE SFS_BUSINESS_SEGMENT IS NOT NULL

But I get the following error:

OLE DB provider "MSDAORA" for linked server "OracleLinkedServer" returned message "ORA-01426: numeric overflow

".

Msg 7330, Level 16, State 2, Line 1

Cannot fetch a row from OLE DB provider "MSDAORA" for linked server "OracleLinkedServer".

This seems to be a generic error statement. Can anyone tell me where am I going wrong.

Thanks.

Solved using OpenQuery

SELECT * FROM OPENQUERY([OracleLinkedServer], 'SELECT FINANCIAL_TRX_INFO_ID FROM WFS_FINANCIAL_TRX_INFO') AS Query

problem using System.Data.Oledb.OleDbDataAdapter for importing Excel

Hi All,

I am facing this weird problem of partial data being fetched when using oledbadapter for fetching data from a Excel spreadsheet. A few cells containing text values are not being fetched..I get an empty string. When i replace this text value by an integer, the problem is no more a problem...

Anyone having faced this problem or having knowledge about this..pls respond..

Thanks in advance

I'll recommend the use of DTS. then

create an SP that triggers the DTS thru xp_cmdshell using dtsrun.

call the SP from the application