Search results for query: *

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...

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

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.

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...

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...

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...

So should it be somthing like: --ProductsDistibutor-- DistID PrdtID and the relationship: ProductsDistibutor 1-m DistributionTbl ProductsDistibutor 1-m PrductsTbl

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--...

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...

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...

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...

Sorry ... will post tables & relations soon. But general tips for the time being would do fine as well as pseudo queries. Many thx.

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...