Mega Code Archive

Error connecting to an oracle 7 x server using the oracle 8 client and bde 5

Question: I am trying to use BDE 5.0 and the Oracle 8 client software to connect to my Oracle 7.x server. I created a new alias and when I attempt to retrieve data using it, I am getting the error ORA-12663 "Services requested by client not available on server." All of the Oracle supplied tools connect and let me see data. What is wrong? Answer: First, be sure you are using at least v8.0.4 of the Oracle client. Next be sure that in your Oracle alias for your 7.x server, you set the 'Object Mode' setting to false. When you create new Oracle aliases in BDE adminstrator with BDE v5.0, the Object mode parameter is set to true regardless of what DLL32 (SQLORA8.dll or SQLORA32.dll) you have selected. For aliases that will reference Oracle 7.x servers, Object Mode must be set to false for correct operation.