|
I have tried the following, Install IIS and try to access from outside, and works perfectly.
Download a portable Apache-server and put it on USB. Start that on the machine that you are trying to reach. That way you can verify whether the computer can be found and the TCP settings/firwall/router is correct. I'm going to guess that the translation of the external IP to an internal IP is incorrect.
Sorry Eddy, but I don´t understand what have to do.
I have download xampp portable http://portableapps.com/apps/development/xampp[], but I´m a litle lost, If you can guide me ...
|
|
|
|
|
JM76 wrote: I don´t understand what have to do. You already done it; whether it's tested with IIS or Apache makes little difference. If you can connect from the outside and see the IIS-page, then the network-settings are correct.
To summarize; you have an application that servers webpages (IIS) and that is reachable from outside of the local network. You have another application (SSRS) that works correctly on the network, but does not talk to the outside world.
Does SSRS require credentials? I had expected an error-message if it is missing a authentication, but I can imagine that there's some kind of "lock" on SSRS to prevent anonymous browsing of the database.
Apparently it is complicated enough to write a book[^] on the subject.
Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
|
|
|
|
|
Hi Eddy
Finally SOLVED!!! After reading your linkhttp://searchitchannel.techtarget.com/feature/SQL-Server-2008-Reporting-Services-for-Internet-deployment[^]
All I have done, is edit the file rsreportserver.config and change the tag Authentication
<Authentication>
<AuthenticationTypes>
<RSWindowsBasic/>
<RSWindowsKerberos/>
</AuthenticationTypes>
<RSWindowsExtendedProtectionLevel>Off</RSWindowsExtendedProtectionLevel>
<RSWindowsExtendedProtectionScenario>Proxy</RSWindowsExtendedProtectionScenario>
<EnableAuthPersistence>true</EnableAuthPersistence>
</Authentication>
After this works perfectly.
Thank you very much
|
|
|
|
|
You're welcome, and thanks for posting the solution
Might save someone else some days of frustration.
Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
|
|
|
|
|
Hello Guys
I am facing one issue on ssis.
I have to fatch 100 record with pending status from DB and send to web service. on response of web service would get same 100 record and same need to update with completed status in DB. Now again I have to fatch 100 record with pending status..... so I have to execute ssis package till record with completed status.
plz let me know how I can execute ssis package till all record update.
|
|
|
|
|
|
PIEBALDconsult wrote: Now you've cross-posted.
Only after you told him not to post it in the C# forum.
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
The C# forum may well be the correct forum. He hasn't answered my question there.
|
|
|
|
|
Hi
Does anybody have any idea about the system/Link, Where Microsoft provides an Environment and we can do experiments , Work with database, run our query etc.
|
|
|
|
|
|
|
Hi all, I am trying to design a database to hold data for a job portal. Basically I have a database called SiteUsers which contains five tables (UsersTable, JobSeekersTable, ResumesTable, EmployersTable, and JobsTable). The following are the table schema for UsersTable, ResumesTable, and JobsTable.
The UsersTable has a Primary Key (PK) of UserID and a Foreign Key (FK) of Username.
The ResumesTable has a PK of ResumeID and the JobsTable has a PK of JobID.
The JobSeekersTable has a PK of Username.
The EmployersTable has a PK of Username.
The question I have is should the JobSeekersTable FK also be Username, or ResumeID, or a composite of Username and ResumeID. I think that the FK should be Username because it's unique but because it's not the primary key of the JobsTable I am uncertain. Also I did not want to use ResumeID as the FK in the JobSeekersTable because although it will be unique a job seeker can have more than one resume.
Whether you agree or disagree with my assumption that Username should be the PK and FK in the JobSeekersTable, please elaborate your answer . Thanks in advance for your help.
modified 30-Oct-14 12:35pm.
|
|
|
|
|
0) You don't actually define a foreign key on a table
1) You may want to define a unique index on UsersTable, but don't use it as a foreign key
2) The other tables should be related to UsersTable on UserID, not on Username
|
|
|
|
|
A foreign key is a primary key from another table. The "username" in the Users table (calling it userstable is redundant, all those things are tables and not chairs with little chance of confusing those) is not a foreign key - but it might be candidate-primary key.
Also, the artificial autonumber may be unique, but it does not mean that one can assign it blindly to be the primary key without asking oneself what the user will be using to uniquely identify a record.
You should look into normalization.
Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
|
|
|
|
|
Hi, thanks for responding. You said "calling it userstable is redundant", that was a typo.
|
|
|
|
|
What r the works u r doing in the IT company..I want to become plsql developer..please share ur works in brief..
|
|
|
|
|
The first thing you should do is learn to use a keyboard!
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
I foresee a return to single letter variables. Bring back the ZX80!
Life is like a s**t sandwich; the more bread you have, the less s**t you eat.
|
|
|
|
|
Hi all,
Suppose I have a database table named JobsTable and among the fields in the table are JobDescriptions, and JobTitle. How would I write my Where clause if users can get all the JobTitle where the JobDescriptions field contains any word in the comma separated list they entered?
I tried the Like keyword but it is not doing what I want. Thanks in advance for your help.
|
|
|
|
|
I have a function (every dev does) which splits a string and returns a table with ID and Item, you could then join the split with your data table
Select *
From Table T
inner join fn_Split(@List,',') l on L.item = T.FieldName
ALTER FUNCTION [dbo].[fn_Split]
(@List varchar(8000), @Delimiter char(1))
RETURNS @Results table
(Item varchar(8000),ID int Identity(1,1))
AS
begin
declare @IndexStart int
declare @IndexEnd int
declare @Length int
declare @Word varchar(8000)
set @IndexStart = 1
set @IndexEnd = 0
set @Length = len(@List)
If @Delimiter = '' Set @Delimiter = ','
Set @List = Replace(@List,char(9),'')
Set @List = Replace(@List,char(10),'')
Set @List = Replace(@List,char(13),'')
while @IndexStart <= @Length
begin
set @IndexEnd = charindex(@Delimiter, @List, @IndexStart)
If @Delimiter = char(32)
set @IndexEnd = charindex(Space(1), @List, @IndexStart)
if @IndexEnd = 0
set @IndexEnd = @Length + 1
set @Word = substring(@List, @IndexStart, @IndexEnd - @IndexStart)
set @IndexStart = @IndexEnd + 1
INSERT INTO @Results(Item)
SELECT @Word
end
return
end
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
|
Yeah I probably snaffled that code from someone in the 90s and have not looked at it since , I'm certain there is a better way of splitting the items.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
hi guys
I need some advice , i have a Query that runs very long because of the following lines of Code , i know you dont understand my data or table structure , you can just advice on a High Level
( CASE WHEN ( SELECT TOP 1
ATTRIB_CODE
FROM SDE.[NOTIFICATION] WITH ( NOLOCK )
WHERE ( LIS_KEY COLLATE SQL_Latin1_General_CP1_CI_AS = LP.LIS_KEY COLLATE SQL_Latin1_General_CP1_CI_AS
AND FUNCTION_KEY COLLATE SQL_Latin1_General_CP1_CI_AS = V.FUNCTION_KEY COLLATE SQL_Latin1_General_CP1_CI_AS
)
AND ARCHIVE_DATE IS NULL
) LIKE '00090009%'
THEN ( SELECT TOP 1
ATTRIB_CODE COLLATE SQL_Latin1_General_CP1_CI_AS
FROM SDE.[NOTIFICATION] N WITH ( NOLOCK )
WHERE N.ARCHIVE_DATE IS NULL
AND N.FUNCTION_KEY COLLATE SQL_Latin1_General_CP1_CI_AS = V.FUNCTION_KEY COLLATE SQL_Latin1_General_CP1_CI_AS
AND N.LIS_KEY COLLATE SQL_Latin1_General_CP1_CI_AS = V.LIS_KEY COLLATE SQL_Latin1_General_CP1_CI_AS
AND N.ATTRIB_CODE LIKE '00090009%'
AND N.ARCHIVE_DATE IS NULL
AND V.ARCHIVE_DATE IS NULL
)
ELSE ISNULL(( SELECT TOP 1
ATTRIBUTE_CODE
FROM SDE.VALUATION WITH ( NOLOCK )
WHERE ( LIS_KEY COLLATE SQL_Latin1_General_CP1_CI_AS = V.LIS_KEY COLLATE SQL_Latin1_General_CP1_CI_AS
AND FUNCTION_KEY COLLATE SQL_Latin1_General_CP1_CI_AS = V.FUNCTION_KEY COLLATE SQL_Latin1_General_CP1_CI_AS
)
AND VAL_STATUS_ID = 2
AND ARCHIVE_DATE IS NULL
), '')
END ) AS ATTRIBUTE_CODE ,
thanks
Vuyiswa Maseko,
Spoted in Daniweb-- Sorry to rant. I hate websites. They are just wierd. They don't behave like normal code.
C#/VB.NET/ASP.NET/SQL7/2000/2005/2008
http://www.vuyiswamaseko.com
vuyiswa[at]dotnetfunda.com
http://www.Dotnetfunda.com
|
|
|
|
|
SQL Server? Did you check the execution plan?
|
|
|
|
|
Vuyiswa Maseko wrote: you can just advice on a High Level There is a high level checklist for performance here[^].
I'd recommend against optimizer hints unless you can explain how SQL server handles locking. I'd also recommend on removing the collation-checks; it would be set once for the server, and not be repeated in each query as that takes extra time.
It also looks a lot like logic that could be run when inserting/updating the record. If that is not helping enough, then look into partitioning the table.
Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
|
|
|
|