?
Solved

Do I need Samba??

Posted on 2002-03-30
9
Medium Priority
?
273 Views
Last Modified: 2010-04-21
Ok.

I dont know Unix.

I just got a contract to move a database from Unix to SQL Server.

I want to do this via ODBC (connecting a Windows Desktop to a Unix DB server)

Do I _have to_ configure Samba??
0
Comment
Question by:aaronkempf
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
9 Comments
 
LVL 40

Expert Comment

by:jlevie
ID: 6907478
No you don't need Samba for this. The Unix database does need to provide ODBC connectivity or you'll need to add an ODBC server to the Unix box, perhaps unixODBC (http://www.unixODBC.org)
0
 
LVL 1

Author Comment

by:aaronkempf
ID: 6908086
thanks.

ill grant points after verifying.

0
 
LVL 40

Expert Comment

by:jlevie
ID: 6908445
What database is the Unix box running?
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
LVL 1

Author Comment

by:aaronkempf
ID: 6908469
thats the clincher.

i dont know whay db its running.

i already asked that as a different question..
0
 
LVL 40

Expert Comment

by:jlevie
ID: 6908988
The particular DB and flavor of Unix are the important issues here. Some DB's (Oracle, Postgres, etc) have, or can have, a built in ODBC capability. If the ODBC capability is already present it's simply a matter of locating and installing the client ODBC driver on a windows box. However, if the DB doesn't provide ODBC connectivity the problem becomes more complex. In some cases it's simply a matter or installing the native ODBC component, or re-installing the DB S/W with that component. In other cases it's necessary to install an ODBC server that contains native support for that DB.

Samba doesn't have anything to do with ODBC connectivity. Samba is simply a means of providing authentication, file, and print sharing services for windows clients. It won't help in any way if you are looking for an ODBC conncetion to a Unix hosted DB.
0
 
LVL 1

Author Comment

by:aaronkempf
ID: 6909611
cool thanks for the explanation.

im sure ill be asking another question about odbc soon...
0
 
LVL 2

Accepted Solution

by:
festive earned 400 total points
ID: 6919892
you could do the following to help determine what the UNIX
system is running (in terms of Databases):

The following command will show you all running processes:
ps -eaf | more

The following command will show you all listening ports
netstat -a | more

If the system is solaris then you could try:
pkginfo -l | egrep -i "sql|database|oracle|ingres|postgres"

or linux:
rpm -q -a | egrep -i "sql|database|oracle|ingres|postgres"

Hope this helps,
Regards,
Festive
0
 
LVL 1

Author Comment

by:aaronkempf
ID: 6920056
cool i like that last comment.. thanks a lot...
0
 
LVL 9

Expert Comment

by:miron
ID: 7018078
well,
I am on a cool path, still a question on Samba is very well thought out. Once database is found, its data can be moved to flat files ( bypassing ODBC ) and moved very efficiently to SQL Server.
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Let's say you need to move the data of a file system from one partition to another. This generally involves dismounting the file system, backing it up to tapes, and restoring it to a new partition. You may also copy the file system from one place to…
Java performance on Solaris - Managing CPUs There are various resource controls in operating system which directly/indirectly influence the performance of application. one of the most important resource controls is "CPU".   In a multithreaded‚Ķ
Learn how to find files with the shell using the find and locate commands. Use locate to find a needle in a haystack.: With locate, check if the file still exists.: Use find to get the actual location of the file.:
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Suggested Courses

764 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question