DBA, Databases, & Data New Activity

What is the Best Metal Detector Made? Hi-pe multi-zone metal detector

Posted to MB Topic: DB Other & Misc.

{Too Long!}

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

I develop system for stores still in CLipper 5.3 I will change to Delphi. Is the InterBase the best choice for use in customers that will not pay for traditional products as SQLServer and others ? Is IB faster enough to run in PIII 800Mhz 128 MB RAM as server for 2 to 10 machines in a LAN ? And does it keep fast even when grow about to 200,000 to 300,000 register in two or three tables ? My system handle 20 to 2000 register in terms of sells and 50 to 5000 registers in terms of selled products a day. If IB is not the best choice what should i use ?, Thank You !

Posted to MB Topic: Interbase

{Too Long!}

Posted to MB Topic: Interbase

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

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

{Too Long!}

Posted to MB Topic: Interbase

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

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

{Too Long!}

Posted to MB Topic: DB Other & Misc.

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

= = = = =, 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: DB Other & Misc.

We run a client database using MS SQL., , We can get access to some of the data via ACCESS but there are fields that are "blob" and "long binary data" that we cannot get direct access to via ACCESS., , The vendors will not help us claiming proprietary software issues., , Is there any "simple" way or any third-party products that will give us access to the contents of the blob and logn binary data files?, , We are not extremely MS SQL literate but we'd be willing to try any suggestions., , Thanks, KC

Posted to MB Topic: MS SQL

Being a computer the server with the archive gdb as to make for has access it other stations?

Posted to MB Topic: Interbase

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

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

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.

Posted to MB Topic: Interbase

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

dear all, , i am trying to retrieve data from a progress 9 database via odbc (datadirect 4.0) but get the following message: driver's SQLSetConnectAttr failed, feature not implemented..., can anybody help me with this one?, , greetz, carl

Posted to MB Topic: DB Other & Misc.

i use interbase 6 and delphi, , i try to do a location car program, , i have a table named Location with field, nolocation, km...., , i have another table named vehicule with fied, novehicule, km..., , and i have another table location_vehicule who join Location and vehicule with field, , nolocation and novehicule, , i want to know how to manage a new location..., , when i go to this form should I ask a new nolocation to interbase (generator) and after add car to this location or, , Inser car to the location, and before post the location ask a nolocation to interbase insert this number in nolocation field of location table and after in nolocation field of location_vehicule, , or any other tips to do that?, , database diagram, , [IMG]http://pages.infinit.net/borland/diagramme2.gif[/IMG], , form picture, [IMG]http://pages.infinit.net/borland/testing.png[/IMG]

Posted to MB Topic: Interbase

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'm translating a Microsoft SQLServer database on an Intrebase database. I have some difficulties on fields such as: password, auto, position. These fields name are not allowed in Interbase because you can't use a keyword for name of a fields., How can I do?, , Tankyou for your answers,, Giancarlo

Posted to MB Topic: Interbase