I.T. Discussion Community!
-Collapse +Expand
DBA
Search DBA Group:

Advanced
-Collapse +Expand DBA Store
PRESTWOODSTORE

Prestwood eMagazine

August Edition
Subscribe now! It's Free!
Enter your email:

   ► MB LobbyDBA, Databases, & Data Board   Print This    All Groups  

DBA, Databases, & Data Most Read Threads

  


25 Threads:


Thread 25 of 25
Thread Starter  

brian p kim
Abnormal error - MS SQL board
= = = = =, Sorry, UBB has encountered an unexpected, fatal error. This error is extremely abnormal. Please contact the board administration. The error text is:, , Can't open 'NonCGIPath/cache-(cache_pw)/ubb_files/forums/Forum39/000018.cgi'. , , I was unable to find that file or directory. Please check the paths., , The exact error returned by the operating system is:, No such file or directory, , ╗ Please use your browser's back button to return., = = = = =
Posted to MB Topic: MS SQL
16 years ago
1 Reply:

adamlum
Thanks for the notice. Another error produced by the old boards system, which is why we created our own at Prestwood.  Hopefully no more errors or headaches.
12 years ago
Nothing New Since Your Last Visit
15860
Hits

Thread 24 of 25
Thread Starter  

Mike Prestwood
Download InterBase 6.01 and Related Tools
{Too Long!}
Posted to MB Topic: Interbase
19 years ago
1 Reply:

Anonymous
--- KOUAME
5 years ago
Nothing New Since Your Last Visit
14276
Hits

Thread 23 of 25
Thread Starter  

kubilayh
Paradox 7 ODBC driver
Hi,, I am looking for the Paradox 7 ODBC driver., , Do you know the link to download the Paradox 7 ODBC driver?, , Thanks in advance, , Kubilay
Posted to MB Topic: DB Other & Misc.
18 years ago
1 Reply:

mprestwood
{Too Long!}
18 years ago
Nothing New Since Your Last Visit
10018
Hits

Thread 22 of 25
Thread Starter  

Ritche M
Unknown Function: substring?
i don't know why SUBSTRING is an unknown function when i make a select statement in SQL Explorer., , ex: select SUBSTRING("borland" from 4 to 4) from TABLE1, , error is either: unknown function or, invalid token "from", , Please help...
Posted to MB Topic: Interbase
16 years ago
Nothing New Since Your Last Visit
9281
Hits

Thread 21 of 25
Thread Starter  

Wes Peterson
ElevateDB - A Compelling Choice
{Too Long!}
Posted to MB Topic: DB Other & Misc.
12 years ago
2 replies. Last post:

adamlum
Wes has always had nothing but praise for DBISAM but it has only been available for Borland products such as Delphi and C++ Builder, IDE's I don't use, so I haven't had the opportunity to try it out first hand.  I am definitely looking forward to trying out ElevateDB with Visual Studio 2005.
12 years ago
Nothing New Since Your Last Visit
9058
Hits

Thread 20 of 25
Thread Starter  

laurent
Run Time error 40002. ORA-01013
I have a run-time error 40002 when running an application (VB5). This is the following message I have when a selection query (with 9 joins):S1T00:[Oracle][ODBC]ORA-01013: user requested cancel of current operation., The query takes, wheter with ODBC test or Sql+, 5 minutes to be executed. This is too long for a user who is waiting for a result. was wondering if there are otpions to set, or optimization rules or paramters to set., Thanks for any answer., Laurent
Posted to MB Topic: Oracle
18 years ago
2 replies. Last post:

sgeorges
Thanks Pedro! I have found a solution. I have just added after the SELECT /+ * ALL_ROWS */ and the query works fine
18 years ago
Nothing New Since Your Last Visit
8012
Hits

Thread 19 of 25
Thread Starter  

Johnc
paradox 9 tables to mysql
Does anyone know how to convert paradox 9 tables into mysql? If so is the conversion simple and does paradox have a built in function or script that can be run to do this? Which tables are more stable for alot of users and records being accessed per day Paradox or SQL , Big Grin!
Posted to MB Topic: MS SQL
18 years ago
3 replies. Last post:

eric_felleiter
Thanks kwmillican I can use it.
9 years ago
Nothing New Since Your Last Visit
5582
Hits

Thread 18 of 25
Thread Starter  

snow_boy
Delphi 6 and Toraclequery.
hi.. I am still a beginner in the delphi programming. so I am just wondering if anyone can help me with a problem that I have. I am current using DOA(Direct Oracle Access), by using that I want to get a procedure that are in the oracle server and use it in my program. I have use the TOraclePackage and in it there is a component "callprocedure" and "callFunction" well I know how to use them and all.. but I am having great trouble of declaring them. , I also have use the TOracleQuery, but it is the declara in the SQL editor that annoying me. coz it gave me error message and etc. so if u can help me with the SQL declare and that will be great., , , thx in advance, Billy
Posted to MB Topic: Oracle
17 years ago
1 Reply:

Anonymous
wow 13 years and nobody help you, I have the same problem, I´m fresh on delphi programming.  Regards! --- Dulce
51 months ago
Nothing New Since Your Last Visit
5216
Hits

Thread 17 of 25
Thread Starter  

mebfbi
92 Compliant // Update Statement
{Too Long!}
Posted to MB Topic: DB Other & Misc.
10 years ago
Nothing New Since Your Last Visit
4670
Hits

Thread 16 of 25
Thread Starter  

assure
FIELD NUMERIC WITH PARADOX
I recently tried to create a new table using Corel Paradox 9. I chose INTERBASE for the table type. I don't get to type in the form the field type NUMERIC. How to do ?, , Thanks [Help]
Posted to MB Topic: Interbase
17 years ago
2 replies. Last post:

assure
Hello for all! , , I am not getting to have success using Paradox 9.0 developers edition with Interbase 6.0. I am not getting to type the characters τ and π, and nor to record in the table. It would be possible an example of as best uses Interbase with Paradox. , , Thank you very much.
17 years ago
Nothing New Since Your Last Visit
4456
Hits

Thread 15 of 25
Thread Starter  

Marine1
Homework help
Hello,, , Need some homework help on databases such as, creating an ERD, data sets and so on. This stuff is bit over my head just need to survive at this point. I just don't the brain at this time for Oracle SQL. Thanks., , Until that time...
Posted to MB Topic: Oracle
15 years ago
Nothing New Since Your Last Visit
4421
Hits

Thread 14 of 25
Thread Starter  

JCarlos
Problem trying to insert 10,000 records under Red
{Too Long!}
Posted to MB Topic: Interbase
15 years ago
Nothing New Since Your Last Visit
4401
Hits

Thread 13 of 25
Thread Starter  

Brex
interbase Vs Access
I need convert a database access, in a database interbase bvut I can't make it ? what is the solution exist one free program in internet?
Posted to MB Topic: Interbase
17 years ago
1 Reply:

Scott
{Too Long!}
17 years ago
Nothing New Since Your Last Visit
4137
Hits

Thread 12 of 25
Thread Starter  

STRUCTURED2000
Oracle Management server (OMS)
Please, help. I'm new to Oracle 9i. I pracyice on my XP homet home trying to log in to enterprise OMS. I installed Oracle 9i, login to Enterprise OMS. When I logged off and turned off and on the computer, my login effort is unsuccesful and if I reinstalled my XP OS again and reintall oracle 9i, I will be able to login to enterprise OMS but once I turned off and restart my computer, I'm out. Do you have a clue what's going on., Thank you.
Posted to MB Topic: Oracle
16 years ago
1 Reply:

adamlum
Have you made sure the Oracle service is starting when you reboot and log into Windows? It should be set to automatic so that it will start up on it's own.
12 years ago
Nothing New Since Your Last Visit
4125
Hits

Thread 11 of 25
Thread Starter  

rrs
Linking to Oracle
I have problems when I try to link to Oracle table. I get an error message "Invalid field definition 'Field Name ' in defnition of index or relationship"., The table I am trying to link to is really big. It has around 260 columns Could that cause a problem ? , Thanks for your help.
Posted to MB Topic: Oracle
16 years ago
1 Reply:

Scott
{Too Long!}
16 years ago
Nothing New Since Your Last Visit
3927
Hits

Thread 10 of 25
Thread Starter  

andyhud
Calling SQL Server 7 Stored Procedures from C++
I am having trouble calling a SQL Server 7.0 Stored Procedure from C++ that returns a recordset and an output parameter., , Here's the criteria - I wish to bind parameters at run time and I need to return an output parameter. Presumably, I need to use rs.Open not execute in order to get the recordset - the problem is that I don't get the output parameters if I am opening the recordset., The stored procedure may change so I don't really want to implement a static wrapper for it., I have tried to implement this with ADO, MFC DAO and MFC ODBC support classes., , A sample piece of code that does exactly what I need would be ideal...
Posted to MB Topic: MS SQL
18 years ago
3 replies. Last post:

southland
It will work, It will work. I try it before.
17 years ago
Nothing New Since Your Last Visit
3915
Hits

Thread 9 of 25
Thread Starter  

andreK
Interbase Metadata
In the Isql tool the user is able to get metadata on an object that resides in the databse. How is this done. Is this stored in a file somewhere?
Posted to MB Topic: Interbase
18 years ago
5 replies. Last post:

Scott
{Too Long!}
18 years ago
Nothing New Since Your Last Visit
3844
Hits

Thread 8 of 25
Thread Starter  

PMartins
Database Pros and Cons
We have hit problems using Access 97 as a front end to our contacts database. The limitations are in the functionality within the constructed interface, not an issue such as too many records (Although speed is also an issue here). We are therefore looking to other types of front-ends to replace Access. , Could anyone provide any relative Pros and Cons to using... , , Access 2000 , FoxPro , Oracle Forms , VB6 , HTML + ASP , C++ , J++ , Delphi , , .. to construct the front-end interface. Any pointers would be gratefully received! , , Thanks, , Paul
Posted to MB Topic: DB Other & Misc.
19 years ago
7 replies. Last post:

Scott
{Too Long!}
18 years ago
Nothing New Since Your Last Visit
3768
Hits

Thread 7 of 25
Thread Starter  

simd01
Cannot see fields in MS SQL tables in Paradox
I am attempting to convert a Paradox database into MS SQL back end using Paradox 10 as a front end. I can now connect to MS SQL 2008 Server Express and see tables in the Paradox data model but when I double click them I just get the SQL hourglass and that is it - none of the fields appear for selection (my dummy tables contain char(10) fields).  Has anyone else seen this?
Posted to MB Topic: MS SQL
9 years ago
1 Reply:

Anonymous
I replied to your other post so I am curious. How are you connecting to the SQL server? Did you use the BDE native driver? Does that work? Did you use ODBC? --- Robert M.
9 years ago
Nothing New Since Your Last Visit
3747
Hits

Thread 6 of 25
Thread Starter  

Ritche M
substring in stored proc?
how do we use substring is stored proc using variables. substring will only work with table columns., ex. variable1 = 'borland', how do we get 'land' from borland?, , need help... thanks.
Posted to MB Topic: Interbase
16 years ago
1 Reply:

Scott
{Too Long!}
16 years ago
Nothing New Since Your Last Visit
3601
Hits

Thread 5 of 25
Thread Starter  

andreK
Export a Fixed Length AScii file from Oracle
Apart from using an export utility, is there a way to export a file to ascii format, fixed length using sql. I would like to wrap this in a stored procedure., , , Thanks, , Lans
Posted to MB Topic: Oracle
18 years ago
1 Reply:

Scott
{Too Long!}
18 years ago
Nothing New Since Your Last Visit
3506
Hits

Thread 4 of 25
Thread Starter  

nzayas
problems with interbase-gbak-restore
I have a problema with a GDB., I execute a query into this gdb and the perfomance of this query is good, bat I make a, backup and restore to my gdb and I try to execute the same query and now the time to execute this query is very long., The plan that ibserver uses to execute the query in both database is different. Why?, Is there any problem with gbak restore GDB's?
Posted to MB Topic: Interbase
17 years ago
2 replies. Last post:

nzayas
Firstly, thank you for you repply., The setting deactive indexes was off when I made the restore and de size page was the same than the original GDB. I tried with a bigger size page but the result was worst.
17 years ago
Nothing New Since Your Last Visit
3407
Hits

Thread 3 of 25
Thread Starter  

andyhud
Memory leak!! Delphi-BDE-ODBC-Access
Having a memory leak problem when creating and opening a table, going to first record, getting a field, closing and freeing the table on a 1 second timer endlessly. I appear to loose about 20K each iteration., I'm using BDE 5.01, Delphi V4, ODBC Access drivers 4.00.3711.08 and Access 97 (SR1). , Has anyone experienced this problem and does anyone have any solutions for it?
Posted to MB Topic: DB Other & Misc.
18 years ago
Nothing New Since Your Last Visit
3364
Hits

Thread 2 of 25
Thread Starter  

Mike Prestwood
Interbase Security Leak - Back door problem
There is a backdoor userid/password, built into Interbase. This includes Intebase 4, 5, and 6. Borland has already addressed this issue, [URL=http://www.borland.com/interbase/downloads/patches.html]click here[/URL] to get more info on the patch., , For more info on the security problem, check out the following links:, , [URL=http://www.kb.cert.org/vuls/id/247371]www.kb.cert.org/vuls/id/247371[/URL], , [URL=http://www.interbase2000.org]www.interbase2000.org[/URL], , [URL=http://slashdot.org/articles/01/01/11/1318207.shtml]slashdot.org/articles/01/01/11/1318207.shtml[/URL], , , ------------------, Michael A. Prestwood, Author, Corel Paradox 9 Power Programming: The Official Guide, , , President & CEO, Prestwood Software & Consulting, 7525 Auburn Blvd., #8, Citrus Heights, CA 95610, , , [URL=http://www.prestwood.com]www.prestwood.com[/URL], , , [b][i]Serving your IT needs since 1984![/b][/i]
Posted to MB Topic: Interbase
18 years ago
Nothing New Since Your Last Visit
3344
Hits

Thread 1 of 25
Thread Starter  

PANTLORD
Cannot insert into triggered interbase field.
Hi there,, , I'm having trouble inserting a value into one of my interbase tables. The table in question has 5 fields, the primary key Operator_ID has a trigger set on it to autoincrement. It is a NOT NULL field as it is the primary key, so I don't enter a value via my Delphi front end. I have also set the required property for this field in Delphi to false., , I consistently am getting the message 'Field XXX requires a value however'., , Should interbase not handle this itself the trigger type is BEFORE INSERT. Within delphi I am using a DataModule with a an IBdatabase/IBTransaction/IBTable and a standard datasource as components and am attempting o do the insert via a navigation component and dbgrid. , , Any suggestions this thing is driving me crazy slowly but surely., , Thanks in advance, PL
Posted to MB Topic: Interbase
17 years ago
1 Reply:

Simon Wood
I use this technique all over the place in my apps and don't see the problem that you have. I am using ObjectPAL and pass-through SQL., , Have you tried inserting a record using an INSERT statement in Windows iSQL ? If this fails then you have an InterBase problem otherwise it is something in your Delphi App, , Have you tried doing a simple hard-coded insert using a TQuery component under a button in your Delphi App ?
17 years ago
Nothing New Since Your Last Visit
3333
Hits
Follow PrestwoodBoards on: 


©1995-2019 PrestwoodBoards  [Security & Privacy]
Professional IT Services: Coding | Websites | Computer Tech