DBA, Databases, & Data Most Read Threads

= = = = =, 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

{Too Long!}

Posted to MB Topic: Interbase

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.

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

{Too Long!}

Posted to MB Topic: DB Other & Misc.

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

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 ,

Posted to MB Topic: MS SQL

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

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

{Too Long!}

Posted to MB Topic: DB Other & Misc.

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

Posted to MB Topic: Interbase

{Too Long!}

Posted to MB Topic: Interbase

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

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

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

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

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

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

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.

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

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

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

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.

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

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