DBA, Databases, & Data New Activity

|
|
Thread 25 of 25 | Thread Starter | | |  Suleman | Hi-pe multi zone metal detector |
 121 Hits | |
Thread 24 of 25 | Thread Starter | | |  PS_2233 | Nice Blog. Thanks for Shari {Too Long!} |
 361 Hits | |
Thread 23 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... |
 5107 Hits | |
Thread 22 of 25 | Thread Starter | | |  essystem | Is InterBase The Best Choice ?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 ! |
 2996 Hits | |
Thread 21 of 25 | Thread Starter | | |  JCarlos | Problem trying to insert 10,000 records under Red {Too Long!} |
 4523 Hits | |
Thread 20 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... |
 9426 Hits | |
Thread 19 of 25 | Thread Starter | | |  vinit.s |
|
 1321 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
|
|
 5354 Hits | |
Thread 17 of 25 | Thread Starter | | |  Mike Prestwood | Download InterBase 6.01 and Related Tools{Too Long!} |
 14833 Hits | |
Thread 16 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 ,  |
 5823 Hits | |
Thread 15 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.
|
|
 3936 Hits | |
Thread 14 of 25 | Thread Starter | | |  mebfbi | 92 Compliant // Update Statement{Too Long!} |
 4821 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. |
|
 4256 Hits | |
Thread 12 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. |
|
 16034 Hits | |
Thread 11 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.
|
|
 9230 Hits | |
Thread 10 of 25 | Thread Starter | | |  KCRABBE | SQL and blob and long binary dataWe 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 1 Reply: |  mprestwood | Hi Kathy,, , I think you might be out of luck. If the vendor has put proprietary data in a binary field, then you'll have to rely on them to help you get the data out. By all means, you can use Access, or Paradox, or Delphi (for example) to read the data into a binary variable and then write it to disk and look at it to see if you can make sense of it., , Mike |
|
 3200 Hits | |
Thread 9 of 25 | Thread Starter | | |  Alex Diogo Moreira | Interbase in Internal NetBeing a computer the server with the archive gdb as to make for has access it other stations?  |
 3352 Hits | |
Thread 8 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. |
 3708 Hits | |
Thread 7 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. |
 4048 Hits | |
Thread 6 of 25 | Thread Starter | | |  assure | Interbase 6.0 with Paradox 9.0Hello 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.  1 Reply: |  Scott | The question has been forwarded to this link:, , [URL=http://205.158.230.147/cgi-bin/ubb/ultimatebb.cgi?ubb=get_topic&f=16&t=000544#000003]Object PAL with InterBase[/URL] |
|
 2983 Hits | |
Thread 5 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. |
|
 4538 Hits | |
Thread 4 of 25 | Thread Starter | | |  yeudba | progress troublesdear 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 |
 2584 Hits | |
Thread 3 of 25 | Thread Starter | | |  os2 | how to manadage that...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] 5 replies. Last post: |  Scott | {Too Long!} |
|
 2962 Hits | |
Thread 2 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? |
 4241 Hits | |
Thread 1 of 25 | Thread Starter | | |  Giancarlo | Keyword & fields name in InterbaseI'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 |
 2650 Hits | |
|
|