使用 u2 Toolkit 将 UniVerse 数据移动到 SQL Server 2014 [英] Move UniVerse data into SQL Server 2014 using u2 Toolkit

查看:43
本文介绍了使用 u2 Toolkit 将 UniVerse 数据移动到 SQL Server 2014的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

我正在尝试将 UniVerse 数据库迁移到 SQL Server 2014.我已经从 Rocket 软件下载并安装了适用于 .net 的 U2 工具包.U2 提供程序显示在下拉列表中,我已经在连接管理器窗口中输入了所有必需的信息.输入信息后,我测试连接并成功连接.但是,当我尝试访问下拉列表以查看 UniVerse 数据库中的可用表时,这些表无法加载.此外,当我尝试改用 SQL 命令时,我收到错误消息,指出我在查询中选择的表不存在.除了这些错误之外,我还对备用开发服务器应用了相同的配置,并且收到了 IBM Informix 错误.我在下面提供了屏幕截图和操作系统信息.

I am attempting to migrate a UniVerse database into SQL Server 2014. I have downloaded and installed the U2 toolkit for .net from Rocket software. The U2 provider is displayed in the dropdown list and I have entered all the required info in the Connection Manager window. Once I have entered the info, I test the connection and it connects successfully. But when I try to access the dropdown to view the available tables within the UniVerse database, the tables fail to load. Also when I try to use an SQL command instead, I receive and error that states that the table I selected in my query does not exist. In addition to those errors, I have applied the same configuration to an alternate development server and I receive an IBM Informix error. I have provided screenshots and OS information below.

我登录到我的 UniVerse 数据库上的 HS.ADMIN 以配置 odbc 访问,但我仍然没有任何成功.我是 UniVerse/UniData 数据库的新手,所以可能我只是在做一些完全错误的事情.任何指导/资源将不胜感激.

I logged to HS.ADMIN on my UniVerse database to configure for odbc access, but I still have not had any success. I am new to UniVerse/UniData databases so it could be that I am just doing something flat out wrong. Any guidance/resources would be greatly appreciated.

有没有人能够使用 SSIS 连接到 U2 提供程序源?

Has anyone out there been able to connect to a U2 provider source with SSIS?

Windows 操作系统微软 SQL Server 2014Visual Studios 2013 Ultimate (BIDS)Windows Server 2012 R2

Windows OS Microsoft SQL Server 2014 Visual Studios 2013 Ultimate (BIDS) Windows Server 2012 R2

火箭 u2UniVerse DBMS 版本 11.2.4.0用于 .NET 版本 2.2 的 u2 工具包

Rocket u2 UniVerse DBMS ver 11.2.4.0 u2 ToolKit for .NET ver 2.2

表不存在

IBM Informix 错误

推荐答案

我没有直接将 SSIS 与 U2 提供程序源一起使用.但是,我在 C# 中使用了 U2.NET 工具包提供程序源.

I have not used SSIS directly with U2 provider source. However, I have used a U2.NET toolkit provider source with C#.

根据我的经验,U2 .NET 工具包的核心查询机制与 ODBC 提供程序共享.因此,我建议首先关注让 ODBC 运行.尽管听起来您已经看过它,但请确保您根据 Rocket 的 ODBC 文档(特别是第 2-4 和 2-5 页).我经常使用 Excel 的外部数据访问工具来验证我的 ODBC 设置.尝试从小处着手,允许几个文件/表,然后检查是否可以在 ODBC 中查询它们.

In my experience, the core query mechanism for the U2 .NET toolkit is shared with the ODBC provider. Therefore, I recommend focusing on getting ODBC running first. Although it sounds like you've already seen it, make sure you check out how to configure your UniVerse account for ODBC per Rocket's ODBC documentation (specifically pages 2-4 and 2-5). I have often verified my ODBC setup using Excel's external data access tools. Try starting small, allowing a couple files/table and then checking if you can query them in ODBC.

这篇关于使用 u2 Toolkit 将 UniVerse 数据移动到 SQL Server 2014的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!

查看全文
登录 关闭
扫码关注1秒登录
发送“验证码”获取 | 15天全站免登陆