Top Solutions

I'm having difficulty connecting to an SQLBase database (1-user Licence SQLBase v. 7.5.1). I'm trying to use the latest .NET DataProvider (from Gupta, installed "typically") to no avail. I have referenced the Gupta.SQLBase.Data dll.

The...

I have code that works to retrieve the DBQ from the registry when I use Microsoft Access as my database. I now need to retrieve the database name when using SQL as database.

I changed "DBQ" in lpSubKey to "Database" but that returned blanks....

I have been migrating users over to a new domain and they have been connecting to the Timberline server fine.  But now that I moved the Timberline Server to the new domain the users cannot connect.  I believe it has something to do with the...

I executed the following Proc code:
     EXEC SQL update locomotive
            set
               last_poll = SYSDATE
            where
               locomotive_id = :l_data.locomotive_id;

      lStatus = sqlca.sqlcode;
and got Error...

I'm completely new to SQLBase. How to I find out what data tables are in the database?

Something like (Oracle) "select table_name from user_tables where num_rows>0" ?????

I am using VB6sp5, and ADO 2.7.  I would like to know how to join two SQL tables on two seperate databases with one SQL statement.  Is there a way to do this?

All I have is a .DBS file from an old server that was running SQLBase 6.1.2-PTF11.  The server and the s/w are no longer available.  I just need to get the data from the .DBS file into Excel or csv so I can record the history.  My boss was...

I am having a hell of a time trying to connect to a sqlbase database from a remote machine.  The software is ADP and this is located locally on the machine.  I need to extract some data, but when I setup my ODBC, I am getting the following error...

I have a table with 3 columns as follows:
USERID          Date                                   SurveryScore    
123                01/01/06                             120
123                01/03/06                             200
123     ...

Hi,
I have a number such as 50 what I want to show on the crystal report is 50%

How can I put the percent sign in the formula.
the 50 is a number calculated in a formula.

Thanks,

Updating SQLBase 9.0.0. to  Unify SQLBase  11.6 appeared, that long text field that earlier version was running nicely, they do not function at all  in higher version!
I am building web service that is urgently needing / based on long text...

I have an SQL table that, through my own fault, has untranslated HTML ampersands. These are all in a single column.

How can I, in SQL, replace the HTML ampersands with ASCII ones?

Hello Experts,

I am trying to export only the column names within a table to an excel or .txt file.  Or just being able to display the column names via a SQL query and then copying them to a file. Can someone suggest the best way that this can...

Hi Experts,
I've SQLBase Db but lost my db password.How to recover password?

Hi,

I need to select SQLBase 6.0.1 data into a readable Excel file.  I know I'm travelling back in time a few years here, but anyone know a way?

Thanks,

Jake

I have a Windows 2003 DC with WinXP and 2K Pro clients. What I am trying to do is add an ODBC System DSN entry for our Visual Manufacturing ERP System.

I have exported the Reg Key, reads:
REGEDIT4
...

Ok guys I usually don't ask for help, but this is a tough one, and I've already spent alot of time trying to fix it.  Any help or ideas would be greatly appreciated!

My client uses IBS (goibs.com) point-of-sale system for food & beverage,...

It is saying that: Select statements included within a function cannot return data to a client., but I want to use the Case to determine if specific types of records qualify.  Not all records need the extra criteria in the Where clause, just...

Hi there

Hopefully an easy on for you SQL gurus out there.  I want an SQL statement that will insert if a unique key does not exist, and update the record if it does for multiple records.   I have attached my SQL.   On the final line Ive just...

Hi

I have 2 SQL 2005 Servers which are both Windows Server 2003 and both running MSDTC yet I am having issues getting the MSDTC to work.

When testing the MSDTC connection using dtctester I get the following error.

Executed: dtctester...

I am wondering how I can find the table names I need in Oracle.

I am familiar with SQL but I am having a hard time finding the tables I need within Oracle.  We are using the Service Contracts module and I basically want to find the fields I...

This is a very intermittent issue, started happening just two months ago. Certain machines lose connectivity to the database running on AIX and as soon as the ip address of the client is changed. Connection is established again.

The only thing...

I have three .mdf files that I need to convert to .csv or .xls.  The files are to large to attach or I would link them to this message.  If anyone can do this, I have the .mdf files zipped and ready to email to you.  I really appreciate any help...

Hi everyone. I'm having an issue where I am using an ssh conenction via command line to use sqlcmd on the remote server. The problem is that the path of the sql file on the remote server contains spaces. Normally, sqlcmd would allow me to put the...

When I open Query Designer in SQL Server 2008, I see no tables to add. How do I display all the tables in the Dataset in the Add Table message box? I open this message box in SSMS by clicking on Query at the top and clicking Design Query in...

Good Afternoon
we are currently running a piece of third party software called INVU for document management.  When running locally eg server, it runs fine and does exactly what it should do.

When linking in to the centura sql database it...

confused here and in need of some help. I have 1 work station that comes up with the error sql native client encryption not supported on the client. When I arrived I noticed that the work station was assigned an ip that was already in use by...

Hi,
I have a list of databases that resides on remote computers. I have access to computername/servername, IP-address and database names for each database. And what I want to do is to connect to each of these databases and read a value from a...

I need to install datadirect 4.20 32bit openedge SQL v10.0B drivers to connect to my progress database (ERP Package) from client computers.
Is there a free version of the drivers available which i can use???

I am relatively new to SQL, so this may be a simple answer to some.  Our SQL server has been running slow at odd times of the day, looking at the Process Info screen under SQL Enterprise Manager I'm trying to make sense out of a couple of things....

Hi experts,
How can I read .db files generated using Sqlite.
 Please say a software by which I could view this file in a table format.
Please help.
Any help in this regard will be well appreciated with points.

Regards,
Sreejith

I have been charged with Disaster Recovery design for a company running an iteration of ADP on their server that uses SQLBase Server 7.5.1 S for its databases.  Using Backup Exec 11D, I've been unable to backup the database as just a flat file...

I have a Application in VB.net that is tied to a SQL DB. I can create a view in SQL with various tables which will give me essentially 4 columns. Column 1 is a string data type with "¬" (euro). Column 2 is a money data type let's say with a value...

Hi,

Below query running on Oracle 10G takes about 15 minutes when the incices and table is analyzed and much more when they are not. For me even 14 minutes is a lot!! please advice

Hello Experts,

I'm trying to link a SQLBase database from ADP to my SQL Server so that I can use it with other databases in the SQL Server 2000.  However, I'm having issue trying to create the link.  

When linking, in the General tab, I put...

I have one Server (MS Windows Server 2003, Standard Edition) with SQL 2000.  The other day the servers drive where SQL is hosted ran out of disk space.  I was able to make some room for now to get things up and running again.  I was updating...

I need a query that will look in a complete database (100 tables) with different columnns in each. Some of those tables have a column named "name". (not all of them)

I want every entry with the name = to Richard. No empty.



Full points...

Hi,
I am running "SELECT" statement to output sales order year nad ordered date by quarterly using following statement:

SET DATEFORMAT mdy
SELECT DATEPART(yy, OrderReceivedDate) AS OrderYear,
             'Q' + DATENAME(qq,...

Hi-
I am using the SAS v8
I want to know if I can use poc SQL for date additions i.e. I want to add 365 days to a start date and creat a enddate.  Can I use the normal formart MMDDYYYY + 365 and get the last date as MMDDYYYY?
How would a...

Hi,

I've made a C# program to do some database editing on a SQLBase database. If the database is online then the connection succeeds, not surprisingly. But if the database is offline the connection fails. Is there a method to set the database...

Hasn't anyone else had problems on  installing  SQLBase 9.01 and its ODBC/ drivers on Windows servers 2008 R2 ? I didn´t find any advice? Istallation is in WOW 32

I have a following business requirement where I need to calculate the sum of dollar amount in diffrent dates range:
1. Calculate the sum dollar amount difference b/w yesterday and day before yesterday e.g if today is July 6 2008, I need to...

I am doing a search in a column type CLOB,, i can do a search just like,,,,
where (CLOB_COLUMN) = '%FILTER%'
but i still have problems with the upper and lowercase,,,,,,  
i try to do
where upper(CLOB_COLUMN) = upper('%FILTER%')
its any...

I wasn't sure what software to select.  I'm using Teradata SQL Assistant and trying to build a new column based on values from two other columns.  I'm trying the case statement below but getting the following error:
Illegal expression in WHEN...

Hi,
I created Adobe AIR application and integrated my data with SQLite flat file.
Now I have a new requirement to read data from SQLLite file (.db extension) using
Microsoft Excel. We defined a nice header with the "Update" button in the...

What is the best way to store numbers with commas in MYSQL? I tried integer and it doesn't place the comma. I tried char and it doesn't acend/decend sort correctly. I want to enter numbers in as 100,000 but hold their correct numerical position. ...

I am researching admin tools for SQLite.    I would like  to build the database entirely on a PC or Mac system, then just drop the files into their correct location in the Android file system.  I am wondering what others are using.  Thanks for...

XPSP2 w Office 2K3.  Access 2003 Front End, SQL 2000 SP4 Back End.  I have to know why my fix worked here.  I had a trial balance report that worked fine until yesterday we started getting ODBC call fails.  I isolated the query that ran and the...

Hi There

I have backed up a sql database for one of our clients, when the client wants to restore the database, we receive the following error " Microsoft SQL - DMO (ODBC SQLState: 42000) Too many backup devices specified for backup or...

Hi all.
I have two table below that I have created.

create table medreason
(
      membid int,
      lastnm varchar(50),
      ident int      
)
create table medreason_bak
(
      membid int,
      lastnm varchar(50),
      medr_ident int,
      change_dt  smalldatetime...

Hello ALL

I have a Simple SQL query that I want case insensitive

select * from YEARS where BASE_YEAR IN ('Year 2009')

I have BASE_YEAR value stored as "year 2009", "yEar 2009" and "Year 2009" and I want to select all combinations...

I need to get the total of the column of a database based on a query, and subtract if from itself, and then
display the total.

DESC:
TABLE: bill_accounting
COLUMNS USED: amt_total, due_date, paid_in_full
PARAMETERS:  
one sum query needs...

Hello Experts,

In Crystal XI how would I go about conditionally suppress an outer group if an inner group was suppressed? Is this possible.  Here is the structure of my report:

GH1
GH2
GH3
GH4
 Details
GF4
     This group is...

I have a PHP form that I am using that is sending data to a MySql database.  It has an option for Street Address, Mailing Address, and Billing address.  I have a checkbox that allows the user to check the box to allow the user to have the Mailing...

How can I connect to Pervasive SQL from windows Excel; what drivers do I need, I am looking for ODBC drivers but Pervasive website says it is provided with original sofware, Is there any place I can download these ODBC driver to connect. I was...

Below is the two pieces of code I have for BACKUP and RESTORE

Backup works without a flaw - but when I try to test teh 'RESTORE'  I get:

 The log file 640.LOG could not be found. Use the RESTORE LOGS command

 to restore this log and...

I have installed BCM on my local PC all working fine I have imported and converted my ACT DB into BCM as I cant stand ACT agian all working fine, now I want others to use the BCM so i want to move the BCM DB to a network drive and i want everyone...

I have a currency table where the following fields exist.
Date start
Date end
Curr Rate
A currency value is set for given date ranges.
I want to search this table for:
Curr rate1 at date xx/xx/xx is equal to curr rate(above table) at date...

Hello...Have a test.txt file which may or may not be in the file directory. C:\test.txt.
Have a SSIS package I need to run if it exists and not to run if it does not....how do I do this..

I have an Access database that had the date format mm/dd/yyyy and I need to change it to yyyy/mm/dd (SQL standard).  I need the query on how to do this.  The column is named Date.  I have already changed the Data Type to Text instead of...

say, i have got a query ..

SELECT * as col1 FROM table_name
   WHERE mandt = '78982''
       AND cc_dfnum NOT LIKE '%*%'
       AND cc_dfnum NOT LIKE '%E%'  
       AND SUBSTR(AUDAT,1,4) IN ('2000','2001','2002','2003')
             AND...

The database I'm using contains a table called OPERATION.  Among other fields in that table, it contains ACT_RUN_HRS, RUN_HRS, and WORKORDER_BASE_ID.  What I would like to do is copy the data from ACT_RUN_HRS for one particular workorder and...

Hi,
I have the following error when trying to connect to an admin page that updates a database.  This worked fine for a while and then started to become intermittent to now where it rarely loads.  If you push refresh enough times the page will...

Hi there

Is anyone familiar with room master program ? I have a issues when loading certain reports  from the server in terminal services mode. Certian reports keep asking for login details

I have spoken to RMS  support and they cant assist...

Hi Experts!
I was hoping someone could be abel to assist me with an SQL query for my Sybase database.

The query below gives me the warning
NULL Value eliminated in aggregate function

It seams like the query gives me correct result, but I...

Hello,
I am trying to install MSDE2000a.exe; it unpacks properly, setup launches then immediately pops the an error "the instance name specified is invalid".  This is the first install of msde and the system (XP,Dell) is fairly new and clean.

Hi, I'm new to SSIS and I am in the need of some help. Here's what I would like to do. I have close to 20 reports that are run on Crystal Reports, each one of them saved in a fixed location and in Excel format. I would like to create an SSIS...

I need to know how to list the index name (and their attribute) on a given table of a SQL databases.

show index?    which table name to assign?

thanks

I have SQLBase Version 8.5.0-PTF4. On attempting to make an ODBC connection via MDAC/VBScript I get an error 80004005 on the first sql statement and all attempty to correct this have so far failed. Is there any other way of extracting the data...

I am looking for the best way to shrink my log file of a 12 GB SQL 2000 database.  Our database maintenance plan is set to reorganize the database overnight each night, then do a full backup of .mdf and .ldf files.  Our log file is also backed up...

While Replicating From an SQL Mobile 2005, i receive the errors:
*29006 A call to SQL Server Reconciler failed.Try to resynchronize.
*The Process could not deliver the snapshot to the Subscriber.

@ the SQL Server the log file have the error:...

I am writing a Sybase Stored Procedure and I need to accomplish the following;

1. Convert a Money field to Char or Decimal whatever is best for an Amt and strip the implicit Decimal  point.
    End result would be 25.00 to 0002500, 8.50 to...

I have received this error when I try to approve any more updates....
Windows Server Update Services encounted an error.
Could not allocate space for object 'tbDeadDeployment' in database 'SUSDB' because the 'PRIMARY' filegroup is full.
...

I linked Foxpro database to Sql table and notice that null value in date field changed to "12/30/1889 12:00:00 Am"  
I want to change to null value in datetime field in table in sql table

Hi,
I want to create an sql query that counts the number of orders for each customer from my table db_orders. Column headers for this query are customer_name and count_id (order count for each customer). Since this query is to be used by a...

SQL Server Active Directory Helper will not start. See below for error logged:

Log Name:      Application
Source:        MSSQLServerADHelper
Date:          11/18/2009 2:32:07 PM
Event ID:      100
Task Category: None
Level:         Error...

DECLARE            @BeginDate            DATETIME      = '07/01/2009';
                  @EndDate            DATETIME      = '01/05/2010';
                  @Subsidiary     INT                  = 2;
                  @Contract            VARCHAR(20)      = 'KD228';

SET @BeginDate = '07/01/2009';
      @EndDate = '01/05/2010';
      @Subsidiary = 2;
      @Contract=...

What could you use SSIS for?

With the statment below--I get a error message:

INSERT INTO [SPIResConv5].[dbo].[Transactions]
           ([TRXNO],
            [RESORT_ID]
           ,[TRANSTYPE_ID]
           ,[BILLCODE_ID]
           ,[MAINTENANCE_ID]
          ...

Hi all

I am installing a new server
This server will have windows server 2008 R2 standard edition 64 bit  installed
I will also  be installing windows server 2003 R2 on hyper-V virtual server


I will have IQMS (oracle based...

Hi there!

Sorry that I couldn't write my "Question Title" more detailed! The problem I have is really wired.

I am new to Gupta TeamDeveloper and SQLBase!

I just created a small app which should establish a simple connection to my...

The SQLBase 9.0 Tutorial 2 for ASP.NET sample, says to add the reference to the "Gupta SQLBase .Net Data Provider", I don't have this showing in my "registered references".  I can browse to the .DLL and add the reference manually, but it still...

I tryed to run Maintenance Plan wizard to create a backup job but I get an error.

TITLE: Microsoft SQL Server Management Studio
------------------------------

Cannot show requested dialog.

------------------------------
ADDITIONAL...

Good day everyone,

I am reposting this question with some clarifications and mentioning this in case you're experiencing a déjà vu.



This may be way too simple but it's a case of "not seeing the forest for the trees" with me.

I have...

I'm trying to figure out how to create a database for a small real estate company. I got all the data that needs to go in it but I'm having a hard time getting it to 3NF. For the properties that will be listed I need to know the following:
  ...

Hello,
How can i convert 10 to 010 in sql?

Examples:
1 -> 001
100 --> 100
0 --> 000

thanks in advance.

Hello,

I have a report that is fairly generic in SMS, but i need to add an IP field to the report. I am starting to learn about writing these SQL Statements for the reports. I have changed a few and worked my way through it, but in this case,...

Hello

I have a Delphi program that loops thru a set of data. During each loops it performs an SQL operation where it updates a table. Most of the times things go well and the program run thru the dataset without error.

However, sometimes I...

I would like to have a stored procedure that return tehs erial number of teh hard disk where the SQL 2005 is installed.

I have a program that saves arrays to our database.  The arrays are written to a file, read back into the program as a byte array and then written to the database.  It worked just fine for quite some time but is now having problems.  The arrays...

Hi I am getting the following error stated with the sql event logs
"The SQL error log is showing the following error message "BACKUP failed to complete the command backup log tempdb with no_log"
This happens at random times has anyone seen...

Hello Experts,

I need a select across all columns in the table for a special term.
Example:
SELECT * from Table_Data where * like '%QS%'

So, this does not work, I know but what is the right way?
There are around 60 columns that I have to...

Hello all,
One would think that after reading all availabel documentation, Wikis and Google searches one would find the answer to this simple question, but I have not.

I am editing a data entry form in ooBase.  All I want to do is have a drop...

I've an Too Old gupta DBS file I don't know the user/pass for its databae, I've installed SQLBase 11 and changed he SQL.ini and the database is visible now in the management console.

My problem is that I can't connect to this database and...

I have Firewall COMODO and just got a message I think I never received:

Sqlbrowser.exe is trying to receive a connection from the internet

The only difference I can say its that I am in Dial-up connection and my regular connection is DSL.
...

I'm looking for a custom report in SMS 2003 that will first list all computer names in a collection then allow you to drill down and check the inventoried files for the computer you select.

Also are there are good online resources for SMS...

Hi,

I have approx. 100K records in a SQL database (2005) that was originally created for single-byte records. I now need to support double-byte characters for localization purposes, and am not sure how to extract, and recreate the database to...

Hi
Can anyone help on how to use paypal IPN to update my sql database.
I attach the code that i can't get to work.
can anyone see what i am doing wrong
Thanks
Bud