• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Need help - MySQL + Solaris

 
Ben Roy
Ranch Hand
Posts: 70
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
My native environment is windows (Jbuilder for development) but I'm working on a project on Solaris. What I've done before to access a MySQL database is configure an odbc source in windows, then use the jdbc dbc driver to access the data. So the db url is something like jdbc dbc:datasourcename. What I can't figure out is, now that I've moved the code to solaris, how do I create the odbc data source? Assuming I could create a datasource named the same as on my windows machine, I shouldn't need to change any of the actual code. Any help on how I do this would be great!
 
Jamie Robertson
Ranch Hand
Posts: 1879
MySQL Database Suse
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
just wondering why you don't use the free Type4 driver for mySQL? You wouldn't have to worry about dsn's and odbc stuff.
Jamie
 
Ben Roy
Ranch Hand
Posts: 70
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Because...I don't know anything about that. ODBC is something I'm familiar with, it's the way I've worked with databases in Java in the past, it give me a consistent interface, and I *shouldn't* need to change drivers when changing databases/platforms.
 
zou xiao fei
Greenhorn
Posts: 9
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
In fact,you do need type4 driver if you wanna your apps run on any platform.when using odbc,you are restricted in windows, if you insist in doing so,you need something else,just check this: www.jetools.com and that's a type3 driver
and, I suggest you to learn more about the jdbc driver types,I 'm sure you'll choose type4 driver.
[This message has been edited by zou xiao fei (edited November 29, 2001).]
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic