Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Win 2003 listening to a port?
It's actually an application that I've coded so it opens a socket... it sends a text file to an IP addr & port #. I was wondering if I can get Windows 2003 SP1 standard edition to deal with everything else on the server end? Don't think I want to get my app to deal with FTP usr/pwd stuff! Just...- Aerodyne
- Post #3
- Forum: Microsoft: Windows servers
-
Win 2003 listening to a port?
Hi all, I need Windows 2003 SP1 to listen for a connection on a specific port & accept a file sent to that port... then save the file in a folder/dir that I set it? Is it possible to do this... or if I need some s/w (prefer free) set up please let me know. TIA- Aerodyne
- Thread
- Replies: 3
- Forum: Microsoft: Windows servers
-
synchronizing two mysql db's...(newbie)
Thanks for your reply... What I want to do is use C-JDBC between them, and in order to have that db A & db B need to be the same... so I need to get B==A. I hope this makes sence. TIA for any help. -
synchronizing two mysql db's...(newbie)
Hi all, I hope some one can point me in the right direction here... I need to synchronizing one db on a server (server A) to another db on a seprate server (server B). There both MySQL 4.1.*, is there any way to sync these from the command line (no gui tools)... and what's the easyist MySQL... -
MySQL clustering?
Hello, Thanks for your reply Bastien... I've read some chapters from the High performance MySQL book... but still it's a bit vague to me. Okay... I have a MySQL server running, the problem I'm trying to solve is: I have a query that gets sent from a client that takes time to complete, so when... -
MySQL clustering?
Hi all, Can any one shed some light on how to set this up and the advantages and disadvantages of it. I've read the manual ... but would kinda need some more clarification and idea's for supporting 4 db's. i.e. Shared-Nothing (will i need a machine for each db or can i run it on one... -
db relation set up...
So should it be somthing like: --ProductsDistibutor-- DistID PrdtID and the relationship: ProductsDistibutor 1-m DistributionTbl ProductsDistibutor 1-m PrductsTbl- Aerodyne
- Post #3
- Forum: Microsoft SQL Server: Programming
-
db relation set up...
Hi all, Help would be appreciated please ;-) Okay I have a client who wants to set up a web site to sell products … The client does not hold any stock … everything is dispatched from the Distributor, here are what the tables look like: --ProductsTbl-- *PrdtID CatID DistID --CustTbl--...- Aerodyne
- Thread
- Replies: 3
- Forum: Microsoft SQL Server: Programming
-
Optimization query...
I want the query to: -Most sold beer in a given month by revenue. -BreweryName & Addr that sold the most. -The ABV (strength of the beer) SELECT BeerPrices.PricePerUnit, Order.OrderDate, Beers.ABV, Brewery.BreweryName, Brewery.Addr, Order.OrderNo FROM BeerPrice, Order, Beers, Brewery WHERE... -
Optimization query...
Hi all, hvass many thx for your reply. I've only just started learning SQL in the last day or so, but I do understand DB & other langs ... For some reason my query is not working corectly and I also just wanted to know is there more than one way to do this query in. i.e an efficient way... -
Optimization query...
Hello, Here's what I've got so far: Order 1 - m OrderItems BeerPrices m - 1 OrderItems Beers 1 - m BeerPacks BeerPacks 1 - m BeerPrices Order *BreweryName *CustName *OrderNo OrderType OrderDate OrderItems *BreweryName *CustName *OrderNo *BeerName Qty BeerPrices... -
Optimization query...
Sorry ... will post tables & relations soon. But general tips for the time being would do fine as well as pseudo queries. Many thx. -
Optimization query...
Hi, Just getting started with this (newbie)... But I'd like to do a query that returns for each brewery, the beer that sold the most by value (revenue) in a given month. I also want it to include the name & addr of the brewery & the name and strength of the beer. Reason for this is that I'm...
