Accessing data w/ODBC & MSSQL 7.0 (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 23 AUG 1999 06:56:02PM Ron Hollar wrote:

OpenInsight Specific

Hello,

  I am trying to access data on a newly installed MSSQL 7.0 server from OpenInsight 3.7 using ODBC. (I wanted to access the data natively but tech support said it doesn't work right, use ODBC.) I have gone through the steps in "Seeing 32-bit ODBC Data Sources in OI", set up the DSN in the control panel, and created a connection in the Client/Server workspace. When I try to create a Dataset, I can pick the Data Source, but when I click on the "Use Table..." button I get the message "Functionality not supported". Have I left out a step somewhere? I created the database and tables on the SQL server, and can see them with isql.

Anyone a SQL guru?

View this thread on the forum...