Stack Overflow
Stack Overflow

Questions tagged [sqlbase]

SQL DBMS Development by Gupta Technologies

SQLBase is a very low TCO embedded and workgroup database offering high performance and scalability. Automated mass deployment, automated installation and automated maintenance make SQLBase the database of choice for environments with limited IT support. Many driver options allow for easy integration with many dev tools. SQLBase is a highly secure database offering powerful encryption for your valuable data and data communication. Go here for more info: SQLBase info

59 questions
1
vote
2 answers

How to open dbs file (SQLBase)

I have a file with an extension ".dbs". All that I know that it's Gupta SQLBase DB version 9.1 I've downloaded and installed SQLBase 11.6 but I don't have any idea how to load it. Google didn't tell me anything intelligible. Can anyone help…
Don Tomato
  • 3,311
  • 3
  • 30
  • 48
0
votes
1 answer

Sqlbase 7 server .uld Files

I have a backup files for Db and ibwant to open them vit unfortunately my license for sqlbase 7 server is not valid so is there is a way to open those files or convert them to any file type to use it . the files have .uld extension
Ahmed Anwar
  • 1
0
votes
1 answer

I need SQLBase documentation

I am using Open Text SQLBase and I need the official documentation. I have the documentation (called "SQLBase Language Reference") for the version 11.7 but I need it for version 12.2. I search for it in https://www.opentext.com but I couldn't find…
Roby Sottini
  • 2,117
  • 6
  • 48
  • 88
0
votes
3 answers

"Error: Too many binds" when executing an INSERT command on SqlBase

I need help with this error on SqlBase, i've never seen it before. This are the table columns: NAME COLNO COLTYPE LENGTH SCALE NULLS UPDATES ==================================== =========== ======== ===========…
JCIsola
  • 110
  • 1
  • 11
0
votes
1 answer

Is it possible to replace text by other text in SqlBase?

Is it possible to replace text in a SqlBase? I found there is a @REPLACE function but I see it just replaces using positions in the string: The following expression returns the value 'RALPH': @REPLACE('RALF', 3, 1, 'PH') What I need is to replace a…
JCIsola
  • 110
  • 1
  • 11
0
votes
1 answer

Error on a query when my Connection is set using Gupta.Sql.Base.dll and some Connection related questions, SQLBase901

I made a project to test using a connection with Gupta.Sql.Base.dll (version 9.0.1.13768), we use version SQLBase901 (that's the SqlBase folder). I added that Gupta.Sql.Base.dll as a project reference, but the execution ends without exception in the…
JCIsola
  • 110
  • 1
  • 11
0
votes
1 answer

LONG VARCHAR - Read from table to Front (C#) then INSERT / UPDATE value to a table

I'm reading table info from a SqlBase DB using a DatAdapter.Fill in C#, it's working perfectly for any variable type except for LONG VARCHAR, in this case it converts to String type in C# and if I add a watch the object variable I see some weird…
JCIsola
  • 110
  • 1
  • 11
0
votes
1 answer

ROWCOUNT field in SYSTABLES table not updated after rows have been deleted

I use the ROWCOUNT field in SYSTABLES to get fast the rowcount of all my tables from a .NET App using Oledb (i don't want to use a query to get it becasue it takes too much time on big tables). The problem is: after deleting rows from the table,…
JCIsola
  • 110
  • 1
  • 11
0
votes
1 answer

Convert/Cast LONG VARCHAR to VARCHAR in Gupta SQLBase 12

I'm trying to convert/cast a SQLBase LONG VARCHAR column into a VARCHAR Column using a temporary table. The source table being used has a comment field column of type "long varchar". I am unable to find the correct syntax to use a convert/cast…
user2427375
  • 39
  • 7
0
votes
2 answers

Gupta SQL Base limit number of rows returned

I've been looking for hours on how to return a limited set of rows similar to SELECT TOP 100 * FROM CUSTOMERor SELECT * FROM CUSTOMER LIMIT 100 or SELECT * FROM CUSTOMER WHERE ROWNUM <= 100 and for the life of me I cannot find a way to do this with…
Daniel Caban
  • 111
  • 1
  • 3
0
votes
2 answers

Connecting SQLBase Server running on Virual Machine

I have a physical Window Server 2008 R2 machine running SQLBase 8.5 and I have no problem connecting to it. Recently I migrated this server to a virtual machine and the problem come up. Sometimes I am able to connect to the Server and sometimes not.…
Sal Kuk
  • 53
  • 4
0
votes
1 answer

Insert from SQL to SQLBase with linked Server

how can i insert from SQL Server to a SQLBase Database using linked Server?
Daniel Kreiner
  • 1
0
votes
1 answer

GROUP BY with 2 table

I can make group by when it is onlyTBRACCD table, when I add the SPRIDEN it doesn't accept for this code? SELECT -- tbraccd_pidm, spriden_pidm, spriden_first_name CASE WHEN SUM (NVL…
user3489870
  • 95
  • 1
  • 2
  • 8
0
votes
1 answer

One PC as server for an SqlBase database

Can any guide me on how (if possible) to set up an PC as a server for e multi user use. I have a 5 user license for SqlBase, an multi user application made under Team delveloper (Gupta). What do I need, if anything in addition? How to set…
kjell vangstein
  • 49
  • 5
0
votes
1 answer

SqlBase Database on One Drive

I have a database on "Microsoft OneDrive", I have 4 valid licenses from Gupta 4 SqlBase. When I try to run from PC 1 I can access the database, but when I try the same from PC 2 I got this Reason: Attempting to open an existing file and a failure…
kjell vangstein
  • 49
  • 5
1
2
3 4