_________________________________________________________________
>Connectivity error: [Microsoft][ODBC Driver Manager] Only SQL_DRIVER_NOPROMPT is allowed when connection pooling is enabled
>_________________________________________________________________
>
>so, I have checked connection pooling option on ODBC Data Sources in Control Pannel.

Issue the following code, before connecting to the database... it 'should' solve your problem.

sqlsetprop(0,'DispLogin',3)

BOb