Miguens
Guest
|
 Posted: Fri Mar 18, 2005 10:11 am Post subject: OpenOdbc :ConnectionString |
 |
|
Hi, I'm using OpenOdbc to acces MS SQL.
It works fine, but some times we gett an error:
---------------------------
Debugger Exception Notification
---------------------------
Project S3Vending.exe raised exception class EDbxOdbcError with message
'Error returned from ODBC function SQLExecute
ODBC Return Code: -1: SQL_ERROR
ODBC SqlState: 01000
Native Error Code: 258
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionRead (WrapperRead()).
ODBC SqlState: 08S01
Native Error Code: 11
[Microsoft][ODBC SQL Server Driver][DBNETLIB]General network error. Check
your network documentation.
DBMS: "Microsoft SQL Server", version: 08.00.0194, ODBC Driver:
"SQLSRV32.DLL", version: 03.85.1025
SQL:
Update cl Set
nome = replace(nome, "'", '´'),
morada = replace(morada, "'", '´'),
Local = replace(Local, "'", '´'),
codpost = replace(codpost, "'", '´')
Connection string:
DSN=IMPOREXPOR_L;Database=SBB_16_11_2004;LANG=English;UID=sa;PWD=***
'. Process stopped. Use Step or Run to continue.
Note: The params I'm using in dbexpress are defined:
DriverName=OpenOdbc
Database=DSN=SAMPLE;Database=master;LANG=English;UID=user;PWD=secret
User_Name=name
Password=secret
BlobSize=-1
RowsetSize=20
Trim Char=True
Custom String=coNetPacketSize=8192;coLockMode=17;coBlobChunkSize=40960
I beleave this is a timeout problem, because it depends on the SQL server we
are conected and the database size. Watt am i missing here?
Thanks in advance,
Joao Miguens.
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
