LinuxQuestions.org
Register a domain and help support LQ
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Networking
User Name
Password
Linux - Networking This forum is for any issue related to networks or networking.
Routing, network cards, OSI, etc. Anything is fair game.

Notices

Reply
 
Search this Thread
Old 12-19-2003, 12:00 PM   #1
edigital
LQ Newbie
 
Registered: Dec 2003
Posts: 17

Rep: Reputation: 0
Networking Mysql into Win2000


Ok, here is the situation:

At work we are stuck on a SQL project due to a lack of resources from IT (as usual). We have gotten a nod from higher up to buy a cheap box and set up our own SQL system locally outside of IT. The comapny (which is a huge national comapny by the way) is running on WIN2k and we would like to grab a cheap box (sub $1000) and use linux and MySQL to do it ourselves.

I have set up and run Linux on my machine at home, but don't have the kind of technical knowledge to forsee possible problems in networking with a windows environment. My questions are these: How difficult is it to network a Linux box into a win2k system. How much support would I need from IT... let me rephrase that... what is the minimum amount of support I would need from IT (assuming that I have a few guys that really know what they're doing locally). Is it possible to run an SQL Linux box inside a Win2k network and keep it under the IT radar?

What distro of linux would work well with something like this? what tools would be useful in setting something like this up and making it as easy as possible.

thanks for all your help. I've found this community is the best resource of all.

-e
 
Old 12-19-2003, 01:37 PM   #2
david_ross
Moderator
 
Registered: Mar 2003
Location: Scotland
Distribution: Slackware, RedHat, Debian
Posts: 12,047

Rep: Reputation: 64
Welcome to LQ.

All you would probably need from IT is to get them to assign you a valid IP address, this lets them keep track of fixed IPs and make sure they aren't in a dhcp range and maybe make sure the physical connections are in place to support your system. If you intend to make it available throught your national organisation - ie outside your lan then it may be a bit more work and you may run into problems depending on their IP allocation etc.

What are you going to get the clients to use in order to interface with the SQL server?

Any sitro should work fine but something like redhat is probably the simplest.
 
Old 12-19-2003, 01:52 PM   #3
edigital
LQ Newbie
 
Registered: Dec 2003
Posts: 17

Original Poster
Rep: Reputation: 0
access

The idea is that the clients will be on Win2k machines and will interface with the linux sql box via microsoft access. it will be on our local intranet. Can access get an odbc connection to the linux box?
 
Old 12-19-2003, 01:57 PM   #4
david_ross
Moderator
 
Registered: Mar 2003
Location: Scotland
Distribution: Slackware, RedHat, Debian
Posts: 12,047

Rep: Reputation: 64
Yes you can:
http://www.mysql.com/products/myodbc/index.html

I actually looked into last week for a similar project I am likely to be setting up in the new year but so far I haven't got as far as trying it.
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
XP and Win2000 networking problem Micro420 General 1 07-05-2005 03:03 PM
Linux And Win2000 Networking ganja_man9999 Linux - Networking 4 02-25-2005 05:40 AM
Networking with win2000 Stingray Linux - Newbie 6 05-16-2003 12:17 PM
Linux & Win2000 Networking Problem... Hacker Linux - Networking 0 05-02-2002 06:56 AM
Win2000/Red Hat 6.1 instalation always starts WIN2000 ovieira Linux - Software 1 03-30-2001 11:21 PM


All times are GMT -5. The time now is 03:23 AM.

Main Menu
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration