如果是Oracle Provider for OLE DB,可以把你的connect string设置成这样的,也就是加上mts=F StrConnectionstring = "Provider=OraOLEDB.Oracle.1;Password=" & strLogName & ";Persist Security Info=True;User ID=" & strLogName & ";Data Source=BCSD;MTS=F" 在odbc里 Upgrade to the latest ODBC driver and enable the option 'Disable MTS support' in the DSN configuration. To do this, perform the following steps: 1. Click Start -> Settings -> Control Panel -> ODBC Administrator 2. Select the DSN you are using, then click the Configure button. 3. You should see the 'Disable MTS support 'option listed in the 'Workarounds' section. If you do not see this option, you are probably not on the latest version.
delphi 6 +ADOStoredProc
StrConnectionstring = "Provider=OraOLEDB.Oracle.1;Password=" & strLogName & ";Persist Security Info=True;User ID=" & strLogName & ";Data Source=BCSD;MTS=F"
在odbc里
Upgrade to the latest ODBC driver and enable the option 'Disable MTS support' in the DSN configuration. To do this, perform the following steps:
1. Click Start -> Settings -> Control Panel -> ODBC Administrator
2. Select the DSN you are using, then click the Configure button.
3. You should see the 'Disable MTS support 'option listed in the 'Workarounds' section. If you do not see this option, you are probably not on the latest version.
但还是不太理解其中的原因。
谢谢各位。