|
One of our ERP system uses it and I need to write some SQL to get data out of it. This is the first time I am touching informix so not sure what to expect. First step is to install driver and so far no luck getting it
Zen and the art of software maintenance : rm -rf *
Maths is like love : a simple idea but it can get complicated.
|
|
|
|
|
If you have access to IBM Redbooks (and havnt already downloaded a copy, that was presumptious of me) download a copy of 'Informix Developers Handbook' IBM Redbooks | IBM Informix Developer's Handbook[^] - that might help - I havnt used it since IBM bought it, but IBM Redbooks were a vital resource back in the day when I had other IBM things going on (I used to run AS/400's)
Im not sure what platform you're running on, but we had so little issues with it, 'twas a pleasure to use - mind you, I started probably like you, no experience, so compiled and built most of the examples etc to figure out which way was up
|
|
|
|
|
Thank You. Will download the Red Book and see how I go with rest of the project ....
Zen and the art of software maintenance : rm -rf *
Maths is like love : a simple idea but it can get complicated.
|
|
|
|
|
..Anyone know his emailio addresstevez?
|
|
|
|
|
I Sheen it somwwhere?
New version: WinHeist Version 2.2.2 Beta tomorrow (noun): a mystical land where 99% of all human productivity, motivation and achievement is stored.
|
|
|
|
|
That was then, this is now.
|
|
|
|
|
|
Hello all,
I'm at my inlaws house... yes, this means... fun with computers!
They are paying a 300mbps optical fiber connection and they are receiving that speed upwards and downwards.
The computer that is plugged directly to the router is getting that speed and Works perfectly.
They have some DLINK 500mbps home plugs PLC connected to transmit that Ethernet to other rooms and computers.
The strange thing here is that they are getting a máximum 10 Mbps download speed and 38mbps upload speed in each room.
I know that more PLC devices means less speed, mixing types means less speed, but even if I plug only two of them the speed is behaving like that.
Is there any other way to send LAN through different rooms without using wifi? (it is clear that wifi is even slower). Without passing Ethernet cables through the house...
What would you recommend?
Thank you all.
|
|
|
|
|
|
I told them, they got a couple of pigeons and thrown them through walls... nothing nice to see...
|
|
|
|
|
I have four supposedly 600mbps adapters and get as little as 4mb through them sometimes. One thing I have found is that if the outlets are on different sides of the fusebox they don't play well. If they are on the same side (same circuit) they work much better. Most US fuseboxes have two sides or columns of fuses and all the ones on a given side are somehow connected together more directly than from one column to the other. I don't know why - I'm good at using electricity for things but have little idea as to the details of how it is distributed!
Does anyone else have a better (or more accurate) explanation?
- I would love to change the world, but they won’t give me the source code.
|
|
|
|
|
That was my first thought, different power lines and therefore bad connection between them, but I can't check it (no idea on how doing that without burning down the house or dying trying)...
Thank you!
|
|
|
|
|
Consult an electrian which has some experiences with PLCs, because often a special spare part is needed.
Try the PLC in an test szenario to check that they are fine.
Tip: connect the PLCs direct with the power line. AVOID additional plugs and cables.
Press F1 for help or google it.
Greetings from Germany
modified 18-Apr-16 5:36am.
|
|
|
|
|
How should/can I test it in a test cage?
All of them are connected to the wall plug directly.
I've also reduced the number of installed PLC's, they had some spare switches and in rooms where two PLCs were installed I replaced one for a switch...
Thank you!
|
|
|
|
|
The keyword is UPTO 500mbps .
A few questions that comes to mind.
1. Is the signal passing any automatic fuses on the way? Automatic fuses contains a coil that attenuates the signal considerably.
B. Are there any neighbours having PLCs as well? If so, they will disturb each other unless you put a filter on the feeder line.
III. Are your PILs house connected to one phase or three phase power? If it's three phases there's very little signal going between the phases, but some actually might since they have one lead in common.
Joan Murt wrote: Is there any other way to send LAN through different rooms without using wifi? (it is clear that wifi is even slower).
Is their house made of concrete?
|
|
|
|
|
1. No idea. don't know how to check it.
B. Probably, it is a fairly big community.
III. Two cables + ground?
Yep, the house is made of concrete, but having a laptop just by side of the router and plugged to the router using an Ethernet cable gives 300mbps in a speed test, this decreases to 10mbps when the connection is done through the wifi...
Thank you!
|
|
|
|
|
Hmmm ...
Actually,
A little trick I learned the last time I replaced (to the tune of $230.00 dUS) my router/modem on my DSL hookup to the mothership over copper was pulling the Cat-6 line out at the back of it with a pinch of the spongey wings, waiting for seven seconds, then replugging-in. You'll be able to stop any blinking LEDs, with some luck, after a true synchronization occurs where the LED for that particular line becomes steady if successful.
'Might have to try a couple of times to get the steadies.
This has always been key for me as long as I've had this service (... over a decade?). Getting rid of that non-synchronization. I know, you didn't exactly say the connection was dis-synchronized. But I'm taking some wind from one response here which mentioned the idea of the "brown out" due to loads on the line and distance between 'yer devices and where they're plugged in on the circuit in 'yer manse.
Oh, and the THE HARD WAY lesson: Don't be think'in you'll just keep turn'n on 'n off that modem until the synchronization shows steady. Doing just that repeatedly, say a dozen times
in three second succession, until it does ... makes for another outlay of $230.00 and a $120.00 service call from a tech/repair a absolute certainty. Every two months!
I was a slow learner once. Now I'm much older.
|
|
|
|
|
|
I have used PLC for many years across circuits. Admittedly, I'm in the UK which uses ring circuits and a shared fuse box; not an American star layout.
Look for any 'dodgy' appliances on your electrical system - fridges, washing machines etc - that may cause spikes.
Also, higher speed links need better quality lines due to signal-to-noise ratios which is one of the reasons that I only run 200Mbs PLCs.
|
|
|
|
|
I'll ask them to unplug the house and replug all the devices one by one to see if they can find which one is the cause of that so low speed.
Thank you!
|
|
|
|
|
Have you thought about setting up a Wifi system to get round these problems? My daughter uses wifi on my system to interact with the internet when she comes round.
|
|
|
|
|
Yes, but the wifi speed is even worse than the PLC one...
|
|
|
|
|
Must be an old or bad wifi? An ac router should give you faster speeds than the achieved PLC speeds you quote.
Edit - just a thought in your OP are Bits and Bytes getting confused? do you mean they get 10MB/s down or 10 Mb/s?
|
|
|
|
|
|