DBA, Databases, & Data Most Read 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., = = = = = 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. |
|
 16049 Hits | |
Thread 24 of 25 | Thread Starter | | |  Mike Prestwood | Download InterBase 6.01 and Related Tools{Too Long!} |
 14888 Hits | |
Thread 23 of 25 | Thread Starter | | |  kubilayh | Paradox 7 ODBC driverHi,, 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 |
 10220 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... |
 9446 Hits | |
Thread 21 of 25 | Thread Starter | | |  Wes Peterson | ElevateDB - A Compelling Choice{Too Long!} 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.
|
|
 9248 Hits | |
Thread 20 of 25 | Thread Starter | | |  laurent | Run Time error 40002. ORA-01013I 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 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 |
|
 8297 Hits | |
Thread 19 of 25 | Thread Starter | | |  Johnc | paradox 9 tables to mysqlDoes 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 ,  |
 5861 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 1 Reply: |  Anonymous | wow 13 years and nobody help you, I have the same problem, I´m fresh on delphi programming.
Regards!
---
Dulce
|
|
 5371 Hits | |
Thread 17 of 25 | Thread Starter | | |  Marine1 | Homework helpHello,, , 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... |
 5127 Hits | |
Thread 16 of 25 | Thread Starter | | |  mebfbi | 92 Compliant // Update Statement{Too Long!} |
 4840 Hits | |
Thread 15 of 25 | Thread Starter | | |  assure | FIELD NUMERIC WITH PARADOXI 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]](graemlins/help.gif) 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. |
|
 4553 Hits | |
Thread 14 of 25 | Thread Starter | | |  JCarlos | Problem trying to insert 10,000 records under Red {Too Long!} |
 4535 Hits | |
Thread 13 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. 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. |
|
 4280 Hits | |
Thread 12 of 25 | Thread Starter | | |  Brex | interbase Vs AccessI 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? |
 4259 Hits | |
Thread 11 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... 3 replies. Last post: |  southland | It will work, It will work. I try it before. |
|
 4132 Hits | |
Thread 10 of 25 | Thread Starter | | |  rrs | Linking to OracleI 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. |
 4071 Hits | |
Thread 9 of 25 | Thread Starter | | |  simd01 | Cannot see fields in MS SQL tables in ParadoxI 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?
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.
|
|
 3972 Hits | |
Thread 8 of 25 | Thread Starter | | |  andreK | Interbase MetadataIn 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? 5 replies. Last post: |  Scott | {Too Long!} |
|
 3953 Hits | |
Thread 7 of 25 | Thread Starter | | |  PMartins | Database Pros and ConsWe 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 7 replies. Last post: |  Scott | {Too Long!} |
|
 3921 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. |
 3721 Hits | |
Thread 5 of 25 | Thread Starter | | |  andreK | Export a Fixed Length AScii file from OracleApart 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 |
 3589 Hits | |
Thread 4 of 25 | Thread Starter | | |  nzayas | problems with interbase-gbak-restoreI 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? 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. |
|
 3514 Hits | |
Thread 3 of 25 | Thread Starter | | |  andyhud | Memory leak!! Delphi-BDE-ODBC-AccessHaving 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? |
 3458 Hits | |
Thread 2 of 25 | Thread Starter | | |  Mike Prestwood | Interbase Security Leak - Back door problemThere 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] |
 3451 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 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 ? |
|
 3438 Hits | |
|
|