Thanks Bob.
I'll Try it~ thanks.
Lee.
Uhm..... more OLE DB is bigger more ODBC is smaller....~!@#$%^& <s>
>_________________________________________________________________
>>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