A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
Win a copy of
Refactoring for Software Design Smells: Managing Technical Debt
this week in the
OO, Patterns, UML and Refactoring
JDBC and Relational Databases
Create DSN in Linux
Joined: Feb 25, 2011
Jan 08, 2012 10:04:31
Is it possible to create a DSN for mysql server in LINUX/UNIX machine ?
Please help me with this.
Joined: Dec 26, 2011
Jan 08, 2012 10:37:26
Yes you can create this DSN by modifying the odbc.ini file located in your home directory
Here is the Sample for you
[ODBC Data Sources] Bug = PostgreSQL [Bug] Debug = 1 CommLog = 1 ReadOnly = no Driver = /usr/local/lib/psqlodbc.so Servername = 64.xxx.xxx.xx FetchBufferSize = 99 Username = kevin Password = passwordforkevin Port = 5432 Database = bugdb [Default] Driver = /home/kst/tmp/libiodbc-3.0.5/odbcsdk/lib/oplodbc.so.1
Joined: Oct 14, 2005
Jan 08, 2012 10:43:23
Why would you want to do that? Wouldn't it be more practical to use the
driver for MySQL?
Joined: Oct 27, 2005
Jan 08, 2012 16:28:57
DSN / ODBC is Microsoft's way of providing database abstraction. JDBC already does that for you. I agree with Paul, use JDBC to connect to the MySQL server directly.
SCJP 1.4 - SCJP 6 - SCWCD 5 - OCEEJBD 6 - OCEJPAD 6
How To Ask Questions
How To Answer Questions
I’ve looked at a lot of different solutions, and in my humble opinion Aspose is the way to go. Here’s the link:
subject: Create DSN in Linux
problem connecting to access
Problem on JDBC -- help urgent
Connecting to database form servlets
Connectting to MS Access in Remote machine without DSN
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2015