error 37000

I tried to run my application linked to sqlserver DB. Iobtain this message :
Erreur d'exécution 40002
37000 : [Microsoft][ODBC SQL Server Driver] [SQL Server] the log
file for
database "app" si full. Back up the transaction log for the database to free
up some log space
someboy could tell me it there is a possibility to do not write in log file
?
this transaction log is always active ?
thanks
tftHi,
Backup the Transaction log (See BACKUP LOG command in books online) and try
accessing the database. If you do not requite a
transaction log backup then change the recovery model for your database to
'SIMPLE'. After that truncate the transaction log using
BACKUP LOG <DBNAME> WITH TRUNCATE_ONLY
The above strategies will clear your trasnaction log.
Thanks
Hari
SQL Server MVP
"ft" <ft@.discussions.microsoft.com> wrote in message
news:19A68E4F-3C6A-4502-AE07-B4C8C9DBFBA3@.microsoft.com...
>I tried to run my application linked to sqlserver DB. Iobtain this message
>:
> Erreur d'excution 40002
> 37000 : [Microsoft][ODBC SQL Server Driver] [SQL Server] the l
og file for
> database "app" si full. Back up the transaction log for the database to
> free
> up some log space
> someboy could tell me it there is a possibility to do not write in log
> file ?
> this transaction log is always active ?
> thanks
> tft

Error 37000

Hello,
Does anyone know how I can reslove this error message:
VB Error: 40002
Generated by: MSRDO20.DLL
Description: 37000 [Microsoft][ODBC SQL Server Driver] [SQL Serv
er] Cannot
open cursor-refereced object "name" during dynamic fetch.
This error message is being generated in sql server 6.5. Thanks.
--
New SQL Server DBA
New SQL Server DBAIt means what it says: it is having trouble creating the cursor, then it can
not reference it.
It might be helpful to see the VB call as well as the T-SQL you are
attempting to execute.
Sincerely,
Anthony Thomas
"Newbie" <Newbie@.discussions.microsoft.com> wrote in message
news:4BA5DD03-FBC3-422E-8FDD-11D8AFF8227D@.microsoft.com...
Hello,
Does anyone know how I can reslove this error message:
VB Error: 40002
Generated by: MSRDO20.DLL
Description: 37000 [Microsoft][ODBC SQL Server Driver] [SQL Serv
er] Cannot
open cursor-refereced object "name" during dynamic fetch.
This error message is being generated in sql server 6.5. Thanks.
--
New SQL Server DBA
New SQL Server DBA