 |
BorlandTalk.com
Borland discussion newsgroups
|
| View previous topic :: View next topic |
| Author |
Message |
Miguens
Guest
|
 Posted: Fri Mar 18, 2005 10:13 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 believe this is a timeout problem, because it depends on the SQL server we
are connected and on the database size. Watt is missing here?
Thanks in advance,
Joao Miguens.
|
|
| Back to top |
|
 |
Stig Johansen
Guest
|
| Posted: Sat Mar 19, 2005 6:32 pm Post subject: Re: OpenOdbc :ConnectionString |
|
|
Miguens wrote:
| Quote: | ODBC SqlState: 08S01
Native Error Code: 11
[Microsoft][ODBC SQL Server Driver][DBNETLIB]General network error. Check
your network documentation.
|
I have seen this error many times.
3 Reasons:
The MS SQLServer has been restarted.
The WinX server, on which the database resides, has been restarted.
Network error - router, firewall, switch etc..
--
Best regards
Stig Johansen
|
|
| Back to top |
|
|
Ed Blanchard
Guest
|
| Posted: Mon Mar 21, 2005 6:02 am Post subject: Re: OpenOdbc :ConnectionString |
|
|
In article <423aa9cd (AT) newsgroups (DOT) borland.com>, [email]jmiguens (AT) clix (DOT) pt[/email] says...
| Quote: | 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
|
If you check out dbxOpenODBC.pas, you'll see defines for _DEBUG_ and
_TRACE_CALLS_ (see the readme.txt file). You *might* see more detailed
info if you enabled these...
Cheers,
EdB
|
|
| Back to top |
|
|
|
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
