注册 登录  
 加关注
   显示下一条  |  关闭
温馨提示!由于新浪微博认证机制调整,您的新浪微博帐号绑定已过期,请重新绑定!立即重新绑定新浪微博》  |  关闭

Flex 技术博客

醉里挑灯看剑,梦回吹角连营

 
 
 

日志

 
 

Connect Sybase with Oracle SQL Developer  

2009-05-05 15:03:50|  分类: DataBase |  标签: |举报 |字号 订阅

  下载LOFTER 我的照片书  |

这篇文章是讲述如何利用Oracle SQL Developer1.5.3 来连接Sybase,Mysql和MS SQL Server。

对于用Sybase数据库和Mysql数据库来开发的程序员来说,系统提供的可视化客户端实在是不好用。
实际上Oracle SQL Developer是支持对这些第三方数据库的连接访问的,只不过需要一些驱动的支持。

对于Microsoft Access,不需要任何驱动,本身它就是通过jdbc/odbc桥连接的。

下载地址为:
Sybase和Sql Server:http://sourceforge.net/project/showfiles.php?group_id=33291
Mysql:http://dev.mysql.com/downloads/connector/j/5.0.html
1.驱动下载好后选择菜单Tools -> Preferences -> Database -> Third Party JDBC Drivers,点击Add Entry,然后选择你下载的包里面的jar文件,记住不是下载的压缩文件,而是要解压出来。
对于The jtds-1.2-dist.zip 包解压的是jtds-1.2.jar文件,对于mysql是类似mysql-connector-java-5.0.8-bin.jar的文件。
安装好驱动就可以创建你所需要的连接了。
2. 也可以通过里面的更新程序下载需要的插件(help->check update)在这里你可以看到多个选项,选择你需要的类型就可以了)
下面转载详细的介绍,如何创建连接都有详细介绍。

原文地址http://www.oracle.com/technology/oramag/oracle/08-may/o38sql.html
Connecting to Third-Party Databases
Oracle SQL Developer supports browsing and reviewing data and objects in Microsoft Access, MySQL, Microsoft SQL Server, and Sybase. It also offers a SQL worksheet for ANSI SQL commands to update or create objects for these databases. Users who want to migrate from third-party databases to Oracle Database can use the Oracle SQL Developer Migration Workbench. For any of these situations, you need to create a connection to your third-party database.
Installing third-party drivers. The correct third-party driver must be installed before you can create the connection. You can install third-party drivers either manually or by using Check for Updates (Help->Check for Updates). For manual installation, you can download supported drivers from the following locations:
·    MySQL JDBC driver, version 5.08: dev.mysql.com/downloads/connector/j/5.0.html.
·    jTDS driver, version 1.2 (required by Microsoft SQL Server and Sybase): source forge.net/project/showfiles.php?group_id=33291. (See jtds.sourceforge.net for information about this driver.)
Microsoft Access does not require an additional driver, because it uses a JDBC/ODBC bridge.
After downloading the driver you need, expand the driver binary Java Archive (JAR) file, which is typically inside the downloaded archive file:
·    The mysql-connector-java-5.0.8.tar.gz (or .zip) download for MySQL includes mysql-connector-java-5.0.8-bin.jar.
·    The jtds-1.2-dist.zip file for Microsoft SQL Server and Sybase includes jtds-1.2.jar.
Select Tools -> Preferences -> Database -> Third Party JDBC Drivers. Click Add Entry, and add your specific JAR file. Now you can create a connection for your third-party database.
Creating a Microsoft Access connection. To create a connection for Microsoft Access, follow these steps in the New / Select Database Connection dialog box:
1. Enter a connection name.
2. Click the Access tab.
3. Click Browse to locate the .mdb file you want to work with.
4. Click Connect.
You can now expand and browse the new Microsoft Access connection in the Connections Navigator.
Creating a Microsoft SQL Server, Sybase, or MySQL connection. To create a connection to a Microsoft SQL Server, Sybase, or MySQL database in the New / Select Database Connection dialog box, follow these steps:
1. Enter a connection name, username, and password.
2. Click the SQL Server, Sybase, or MySQL tab. Figure  shows the SQL Server tab. 
 Connect Sybase with Oracle SQL Developer - 阿蔡 - Flex 技术博客
       
Figure : Connecting to Microsoft SQL Server      

3. Choose one of the password authentication options (each of these connections offers you multiple choices).
4. Fill in the Hostname and Port fields. The default port is 1433 for Microsoft SQL Server, 5000 for Sybase, and 3306 for MySQL.
5. Click Choose database to populate the database list, and select the appropriate database from the list.
6. Click Test and Connect as before.
You can now browse your Microsoft SQL Server, Sybase, or MySQL database in the Connections Navigator.

  评论这张
 
阅读(2447)| 评论(0)
推荐 转载

历史上的今天

评论

<#--最新日志,群博日志--> <#--推荐日志--> <#--引用记录--> <#--博主推荐--> <#--随机阅读--> <#--首页推荐--> <#--历史上的今天--> <#--被推荐日志--> <#--上一篇,下一篇--> <#-- 热度 --> <#-- 网易新闻广告 --> <#--右边模块结构--> <#--评论模块结构--> <#--引用模块结构--> <#--博主发起的投票-->
 
 
 
 
 
 
 
 
 
 
 
 
 
 

页脚

网易公司版权所有 ©1997-2017