Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Create Table Timeout Error 1

Status
Not open for further replies.

GoAggies

IS-IT--Management
Sep 10, 2003
2
US
I'm running SQLBase 7.5 and attempting to create a table from SQLTalk. When I do so, it tells me "Error: Time out (transaction rolled back)". Where should I be looking to isolate/correct the problem?

The following is the command that I would really like to execute (though I've tried several variations including the simplest CREATE TABLE possible):

CREATE TABLE RESOURCE_AVAIL
( RESOURCE_ID VARCHAR (25) NOT NULL
,SCHED_DATE DATE NOT NULL
,HRS_REM_SHIFT_1 DECIMAL(10,4)
,HRS_REM_SHIFT_2 DECIMAL(10,4)
,HRS_REM_SHIFT_3 DECIMAL(10,4)
)
IN DATABASE VMFGTEST;

Thanks in advance for your help!

Andy
 
Are there any other processes or cursors open on this database at the time? What happens if you give the following command:

SELECT *
FROM SYSTABLES
WHERE NAME LIKE 'SYS%';

Could this be a networking problem?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top