Search results for query: *

Hello, which connectivity dll is used by the server ?? When you define a socket ip communication the sever also must set up with thic protocol. That means eg: [dbnt1sv] servername=Server1,SQLWS32 .... DBNAME=ISLAND,SQLWS32

I think the load process tries to do a 'GRANT RECOURCE... ' to an user which already has this authority. If the unload file is not an compressed unload please open it with an editor in text mode an try to find out the line where this happens.

As soon as you database file has a size over 2 GB you have to do a segmented backup of your database. To perform segmented backups you must create a backup control file. How to do this read chapter 'Backing Up and Restoring Databases' in the SqlBase Online book SQLBase Database Administrator's...

Try to use SQLEngineer. It's written in GuptaTeamDeveloper. You can download this tool from www.iceteagroup.com

The setting password= in the sql.ini is not the password for your database user connect. It represents the global password for the server connect. So, if you want to do a 'SET SERVER.... ' you need to do it with this password. e.g. in your case: SET SERVER START/OURPASSWORD

As far as I know, it is not possible to bring this dbs file to a 9.0 server. The database structure has to be converted to the new server.

Hello, try this good tool: http://www.iceteagroup.com/Products/SqlEngineer.htt In the app. there is a funtionality to calculate the table size or do it with the sql statement: SELECT NAME, CREATOR, @ROUND(PAGECOUNT/1024,2) As Size FROM SYSADM.SYSTABLES WHERE SYSTEM = 'N' AND TYPE =...

Try to use the SILENTMODE keyword in sql.ini: silentmode Turns the display for a multi-user server on and off. Warning: If you turn off the server display, there will be no visible window and you cannot shut down the server with Windows Task Manager. The only way you can shut down the server is...

If you use sqlbase 8.x you can find in the server sql.ini file a section [dbnt1sv.gui] in the entry MAINWIN=MIN,267,208,757,560 you can set with MAINWIN=MIN ( minimized window ) MAINWIN=MAX ( maximized window ) or do you mean that the sqlbase window should be hidden ( no console )? Oliver

You can implement a stored procedure on the splbase which contains the functionality to drop a table or receatea table. To decide wether drop or create you can have a look into the syscatalog ( sysadm.systables ). Now it's very simple to execute the procedure with table name and DDL script as...

Hello, are you want to do the select within an application or direct on the sqlbase database ??