I am having problems linking to SQL Server 7.0 from a third party application. The error message tells me that the data source name was not found and that no default driver has been specified.<br>
<br>
I have noticed that there is a odbc.ini in the Winnt directory. Is this where you are suppose to specify the data source name and default driver.<br>
<br>
I have a data source defined and am able to use this to connect to SQL Server 7.0 from Microsoft Access and Visual FoxPro with no problems. However ever trying to use the same data source via a non-Microsoft application (Omnis Studio 2.0 - used for creating applications for Macintosh and PC platform) results in the following error message:<br>
<br>
I have asked my third party application vendor for advice and they tell me that I do not have my client ware configured to allow third party applications to link into SQL Server 7.0. I have also gone through the basic OLAP tutorial and created a cube, however, I am not able to process the cube I created and receive the same ODBC error message. Has anyone tried the OLAP basic tutorial and received the same error. After encountering this problem, I am led to believe that I have not configured the ODBC properly. Is it something to do with the ODBC.ini file?<br>
<br>
Is there a guru out there who knows what I am talking about and how to resolve this problem?<br>
<br>
I have noticed that there is a odbc.ini in the Winnt directory. Is this where you are suppose to specify the data source name and default driver.<br>
<br>
I have a data source defined and am able to use this to connect to SQL Server 7.0 from Microsoft Access and Visual FoxPro with no problems. However ever trying to use the same data source via a non-Microsoft application (Omnis Studio 2.0 - used for creating applications for Macintosh and PC platform) results in the following error message:<br>
<br>
I have asked my third party application vendor for advice and they tell me that I do not have my client ware configured to allow third party applications to link into SQL Server 7.0. I have also gone through the basic OLAP tutorial and created a cube, however, I am not able to process the cube I created and receive the same ODBC error message. Has anyone tried the OLAP basic tutorial and received the same error. After encountering this problem, I am led to believe that I have not configured the ODBC properly. Is it something to do with the ODBC.ini file?<br>
<br>
Is there a guru out there who knows what I am talking about and how to resolve this problem?<br>
