How connect OI with SQL Server 7 (OpenInsight Specific) [Revelation On-Line Wiki]

Sign up on the Revelation Software website to have access to the most current content, and to be able to ask questions and get answers from the Revelation community

At 19 APR 1999 02:03:46PM Weiwu Zhu wrote:

OpenInsight Specific

 I need convert ARev tables in a Dos Application to OpenInsight and then further convert them to SQL Server 7. Now, I can 'attach'                   these ARev tables into OI, but I meet a connect problem when I want to convert them further to SQL Server 7.

 I created some Data Sources in Windows NT '32bit ODBC Data Sources' in Control Panel, and then wanted to create a new connection                    in OI. But, when I double-click in the DataSource row in the Attribute table, I cannot display a list of available ODBC data sources, and

a Error message showed: 'No ODBC Data Sources were found.'

 Could you please tell me:

 How I can solve the connection problem?

 Any directions on converting Arev tables to SQL Server7.

Thanks!

At 19 APR 1999 04:27PM Stephen Revelation wrote:

This may help you. But the problem most likely lies in the fact that OpenInsight is 16-bit and you probably need to 'Thunk' OI into seeing 32-bit ODBC sources. To do this click here.

Good luck,

Stephen Revelation

At 21 APR 1999 03:16PM Cameron Revelation wrote:

Weiwu,

You can also use the direct connection object to SQL Server if you have the SQL Server 16-bit (a.k.a. "for Windows 3.1") client libraries installed.

Cameron Purdy

Revelation Software

View this thread on the forum...