Information générale
Titre:
Remote Views to SQL Server
When we create our remote views to our SQL Server database, we are unable to use various SQL Server functions. For example: Before we went SQL Server, we had views where we used Foxpros NVL() function. Now that we are creating remote views to a SQL Server database, we need to use SQL Server functions, as expected. So I try to use IsNull(). When I try to save the view, I receive the error message "Connectivity error: [Microsoft][ODBC SQL Server Driver][SQL Server] Invalid column name ... (the expression I created)". This also happens when I try to use SQL Server's CASE(T-SQL) in place of the IIF() we previously used in Fox views. I've verified that the functions I'm using work in SQL Server by trying them first in the Query Analyzer. It's just that Foxpro won't let me put them in the remote view. Has anybody else had problems like this? How did you overcome them?
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement