PRB: English Query Using SQL 7.0 Domain May Fail with SQL 6.5 (216885)

WORKAROUND

• Solution 1

  Set the version for the data connection and rebuild the EQ domain:
  
  Set Global properties/data connection/ version for your EQ project and rebuild the EQ domain application. For example:
  
  
  1. Open the sample pubs EQ project.
  2. On the Edit menu, click the Gobal properties/data connection tab.
  3. Change the version to 6.5 (for example, 06.50.201). If you click Change on the data connection tab and choose a DSN for a SQL 6.5, the version field on the dialog box is updated.
  4. Rebuild the EQ domain application.

• Solution 2

  Use EQ session.SetDBMS method to generate code for SQL Server 6.5.
  
  The SetDBMS Method sets the DBMS type and version for which the query is generated. If the server running Microsoft SQL Server is version 7.0 (or higher, when available), it allows the server to take advantage of the features in that particular version.

  Syntax
  Session.SetDBMS(Type, Version)
  Part	Description
  Session	An object variable  representing an existing domain object.
  Type	A reserved integer  it must be 0 (zero).
  Version	A string  in the form of nn.nn.nnn
  						

  For example:

  objEQSession.SetDBMS(0, "06.50.201")
  						

  You can use this method if you want to deploy on SQL Server 6.5 and can't change the model and rebuild.
  
  To change the MFCEQUI sample to query in SQL Server 6.5, modify the following method in the Nlinter.cpp file by adding the following line:

  (*m_pSession)->SetDBMS((enum NlDBMSType)0,"0.6.50.201");
  						

  bool CNlpSession::Startup(const LPCTSTR szDomainFilename)
  {
  	IMPL_UNICODE_CONVERSION;
  
  	try {
  		m_pSession= new _SessionPtr;
  		m_pSession->CreateInstance(L"Mseq.Session.1");
  		}
  	catch(_com_error &e) {
  		ReportError(e);
  		return(false);
  		}
  	
  	try {
  		(*m_pSession)->InitDomain(A2W(szDomainFilename));
  		(*m_pSession)->PutClarifySpellingErrors(true);
    // **** Add this line to the sample ******
  		(*m_pSession)->SetDBMS((enum NlDBMSType)0,"0.6.50.201");
    // ***************************************
  		}
  	catch(_com_error &e) {
  		delete(m_pSession);
  		m_pSession = NULL;
  		ReportError(e);
  		return(false);
  		}
  
  	return(true);
  	}