LinuxQuestions.org
Share your knowledge at the LQ Wiki.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!

Notices


Reply
  Search this Thread
Old 03-05-2012, 04:43 AM   #1
Welcome12
LQ Newbie
 
Registered: Mar 2012
Posts: 10

Rep: Reputation: Disabled
how to create dsn conneciton


Hi,

I am new to linux i just wanted to know how to create new odbc connetion in linux
my dabase microsoft sql server

please help with the steps

thanks

Last edited by Welcome12; 03-05-2012 at 04:47 AM.
 
Click here to see the post LQ members have rated as the most helpful post in this thread.
Old 03-05-2012, 05:39 AM   #2
Satyaveer Arya
Senior Member
 
Registered: May 2010
Location: Palm Island
Distribution: RHEL, CentOS, Debian, Oracle Solaris 10
Posts: 1,415

Rep: Reputation: 305Reputation: 305Reputation: 305Reputation: 305
Check onto these links:

http://www.stata.com/support/faqs/data/odbcmu.html
http://www.easysoft.com/developer/in...dbc/linux.html
 
2 members found this post helpful.
Old 03-05-2012, 06:20 AM   #3
Welcome12
LQ Newbie
 
Registered: Mar 2012
Posts: 10

Original Poster
Rep: Reputation: Disabled
linux odbc connection_ms sql

Quote:
Originally Posted by Satyaveer Arya View Post
Hi,

Please help with the steps. I know for windows for this i am new
os is linux mint 12
dirver is inbuilt or we have to install
i.e.

Name: MSSQLServer
Description: TDS MSSQL (description isn't important)
Servername: mssql.serverhost.com
UID: sa
PWD:
Port: 1433

Last edited by Welcome12; 03-05-2012 at 06:21 AM.
 
Old 03-05-2012, 06:39 AM   #4
Satyaveer Arya
Senior Member
 
Registered: May 2010
Location: Palm Island
Distribution: RHEL, CentOS, Debian, Oracle Solaris 10
Posts: 1,415

Rep: Reputation: 305Reputation: 305Reputation: 305Reputation: 305
Quote:
dirver is inbuilt or we have to install
Read the ODBC Drivers section of the second link I provided.
 
1 members found this post helpful.
Old 03-06-2012, 01:30 AM   #5
Welcome12
LQ Newbie
 
Registered: Mar 2012
Posts: 10

Original Poster
Rep: Reputation: Disabled
dscn connection-linux

Hi,

suppose i am available on linux machine how will i go to the odbc driver and paste my details and which driver i select. please provide the steps i am very much new

it is request

thanks
 
Old 03-06-2012, 02:50 AM   #6
Satyaveer Arya
Senior Member
 
Registered: May 2010
Location: Palm Island
Distribution: RHEL, CentOS, Debian, Oracle Solaris 10
Posts: 1,415

Rep: Reputation: 305Reputation: 305Reputation: 305Reputation: 305
I think you haven't read the article which I provided on second link. Read the "Where are ODBC drivers defined?" section . If you have installed unixODBC you can use odbcinst -j command and see the files where you want to set your details -

Quote:
$ odbcinst -j
unixODBC 2.2.7
DRIVERS............: /etc/odbcinst.ini
SYSTEM DATA SOURCES: /etc/odbc.ini
USER DATA SOURCES..: /home/auser/.odbc.ini
You need to read that article thoroughly, if you have understood that, then implement those steps according to your need... And if you face any problem then we are here to help you..

Last edited by Satyaveer Arya; 03-06-2012 at 02:55 AM.
 
  


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
how to create DSN in Linux vdx Programming 2 10-05-2007 02:19 AM
NFS/SMB: lose conneciton, hangs file manager DaveQB Linux - Networking 4 07-31-2007 12:33 AM
Ubantu to OSX conneciton bentley27 Ubuntu 4 03-27-2006 08:40 PM
How do I automatically bring up wireless internet conneciton in Slackware 10.1? n00bified Linux - Hardware 1 12-28-2005 01:17 PM
Slow conneciton to FTP and POP3 echid Linux - Newbie 3 05-15-2002 08:50 AM


All times are GMT -5. The time now is 11:53 AM.

Main Menu
Advertisement
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
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration