LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   Linux - Newbie (https://www.linuxquestions.org/questions/linux-newbie-8/)
-   -   how to create dsn conneciton (https://www.linuxquestions.org/questions/linux-newbie-8/how-to-create-dsn-conneciton-932780/)

Welcome12 03-05-2012 04:43 AM

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

Satyaveer Arya 03-05-2012 05:39 AM

Check onto these links:

http://www.stata.com/support/faqs/data/odbcmu.html
http://www.easysoft.com/developer/in...dbc/linux.html

Welcome12 03-05-2012 06:20 AM

linux odbc connection_ms sql
 
Quote:

Originally Posted by Satyaveer Arya (Post 4618810)

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

Satyaveer Arya 03-05-2012 06:39 AM

Quote:

dirver is inbuilt or we have to install
Read the ODBC Drivers section of the second link I provided.

Welcome12 03-06-2012 01:30 AM

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

Satyaveer Arya 03-06-2012 02:50 AM

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


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