Viewing 15 posts - 1 through 15 (of 405 total)
Hi, first check and see if you can connect to the Oracle data source using a query tool. Can you do that?
July 6, 2022 at 12:58 pm
Hi if your issue is fixed please post the solution. My first response is validate your tnsnames.ora file. Another thing to check is how connections are made in production.
June 20, 2022 at 6:00 pm
Hi Scott, thanks for the comments. I think that your concerns apply to any table, not just a lookup table. I recommend making keys int. In any case, the table...
June 20, 2022 at 12:12 pm
Thanks rat, I take your point. I don't have access to check most of these but now I have a direction to look.
June 17, 2022 at 4:47 pm
My answer is that it depends. Sometimes the report parsing logic is so specialized that it will never be used elsewhere. In those cases I sometimes just slap it in...
June 17, 2022 at 4:42 pm
At its simplest, the MasterType table would have an ID, a Description, and a TypeIndex. All of the rows for, say, CustomerType would have TypeIndex of, say 1. Note that...
June 17, 2022 at 4:29 pm
This is about type tables in general, not about your question. I would call type tables a well-known design pattern. I have never seen a database without them. Over the...
June 16, 2022 at 9:41 pm
Nevermind, thanks for your comment.
January 21, 2021 at 6:32 pm
I'm not in any way discounting Steve's experience. In your example, the largest failure is in the joke, not the failure itself.
I have to second Rick again. In your...
January 21, 2021 at 5:10 pm
I have to second what Rick said. We all have two eyes, two ears, and a brain, all of which work similarly. No ethnicity is different enough that we cannot...
January 21, 2021 at 2:47 pm
A spoof is something that works but appears to be something else, like a packet of data from a fake IP. A mock is something that appears to be something...
January 20, 2021 at 4:40 pm
Great article on one of my favorite subjects. I think you are right, one of the keys to business success is a focus on customer needs. I agree that this...
January 19, 2021 at 4:18 pm
Extremely well said. A little bit of failure is a learning experience, is it? Nonsense.
January 19, 2021 at 2:28 pm
Allowing failure: Steve and others use children learning as an analogy for this. That works very well because this is childish. When I am a member of your team, there...
January 19, 2021 at 2:25 pm
Sorry you are ailing, Grant. When making your point you used medical data, which is a complication above just normal business data, but the point is the same. I have...
January 11, 2021 at 2:19 pm