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!

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

Search results for query: *

  1. OliverA

    sqlbase not connecting to database, need help

    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
  2. OliverA

    01106 SEC UAR User already has resource authority :remedy none

    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.
  3. OliverA

    SnapShot Backup over 2Go

    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...
  4. OliverA

    View and Connect to SQLBase

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

    Problems connecting to SQLBase using SQLTalk

    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
  6. OliverA

    how to restore DB from a atabase file?

    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.
  7. OliverA

    Table Size

    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 =...
  8. OliverA

    Minimize SQLBASE on restart

    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...
  9. OliverA

    Minimize SQLBASE on restart

    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
  10. OliverA

    if table exists functionality

    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...
  11. OliverA

    COUNTING RECORDS

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

Part and Inventory Search

Back
Top