Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. cDevX99

    SECURITY QUESTION

    I have had responsibility thrust upon me for three apps which will all use sql server ..... One will exist partially outside of our private network in a DMZ the other two will be on our private network. All three will access databases on the same machine inside of the private network. I am...
  2. cDevX99

    Oracle C OCI Question

    ...<ctype.h> #include <oratypes.h> #include <ocidfn.h> #ifdef __STDC__ #include <ociapr.h> #else #include <ocikpr.h> #endif #include <ocidem.h> /* Define an LDA, a HDA, and a cursor. */ Lda_Def lda; ub4 hda[HDA_SIZE/sizeof(ub4)]; Cda_Def cda1; text *szUID = &quot;UPLOAD&quot; ; text *szPWD...
    • cDevX99
    • Thread
    • Replies: 0
    • Forum: C
  3. cDevX99

    c and oracle

    Ok, found the libs headers and such ( part of the oracle server installation ) even found a bunch of samples, but there doesn't seem to be any kind of docs on how to use these libs. I am figuring it out based on the samples, but it would be quicker if I had some basic documentation. Does this...
  4. cDevX99

    c and oracle

    BTW, I am using the Microsoft Visual C++ compiler.
  5. cDevX99

    c and oracle

    ...= &quot;THEUSER&quot; ; char szPWD[] = &quot;THEPWD&quot; ; char szMyQuery[] = &quot;select something from somwhere&quot; ; ora_connection_var * oraCONN ; ora_row_var * oraROW int main( int argc, char * argv[] ) { oraCONN = ora_connect( szSID, szUID, szPWD ) ; ora_query( &oraCONN...
    • cDevX99
    • Thread
    • Replies: 2
    • Forum: C
  6. cDevX99

    ORACLE 9i error codes

    Does anyone know the meaning of an error 1242, or 204. More importantly, is there a command ( either sqlplus or cmd line ) to describe an error based on it's number.
  7. cDevX99

    Setting Up A Management Server

    My bad, they do exist, one question though ... to put these into a specific tablespace I need to create a user who's default is the desired space and then use that user to do the import....correct?
  8. cDevX99

    I think I know what I DID!!!!

    Oh, i get it, there are two files, ( i think i have the structure right...if not I am clos) /etc/hosts.allow & /etc/hosts.deny. deny should be empty, and I think you are correct allow should either be empty or contain a wild char.... in anyevent... adding localhost to that file should certainly...
  9. cDevX99

    OK, did I just destroy my database?

    I am not certain how to un-do it, but the mysql file structure is pretty straight forward, so you could probably copy all the db and table files to another location, reinstall mysql, then copy back the table files, ommiting the user files. There is probably an easier way to do this, but I don't...
  10. cDevX99

    Setting Up A Management Server

    Quite sure ... if they did.....would have a problem at all
  11. cDevX99

    Supplied argument is not a valid -- please help.

    Can you post the relevant code......in particular where you fetch the row.
  12. cDevX99

    returning the results of the previous insert

    Nope, real easy....use this function immediately after doing the insert, it will return the last value that was alotted in the auto increment column... int mysql_insert_id (resource [link_identifier]) You can read the details here... http://www.php.net/manual/en/function.mysql-insert-id.php
  13. cDevX99

    Setting Up A Management Server

    I managed to export the structures and data from one tablespace in my Oracle 8 database and I want to bring it into an Oracle 9i database.....I open up the Enterprise Management Tool ( IMP & EXP do not work in the Win 2K distribution ) but it tells me, when I get to the import and export menus...
  14. cDevX99

    Need to dump large amount of data

    Is there a command line way to do that? I have not found it. There does not seem to be a management server installed and I wish to make as few changes as possible on that dying production server.
  15. cDevX99

    Need to dump large amount of data

    Here is what I think I can, and hope to do.... I would like to dump all of the data in a tablespace as well as the table structures and key structures to a script file that I can then run on a 9i database in another tablespace where the tables would be recreated as well as primary and foreign...
  16. cDevX99

    Primary Key Index

    If the index is precisely the same as the key, it serves no purpose at all. If, however, you were to index on the key in combination with another field(s) upon which you frequently search your table then it is certainly a good idea. Jim
  17. cDevX99

    If you are going to work with MySQL...

    If you are going to work with MySQL the book &quot;MySQL&quot; by Paul DuBois is, in my humble opinion, indispensable. It is written in a bare bones way that is easy to understand and extremely informative. This is not MySQL for dummies so some basic knowledge of at least standard SQL syntax...
  18. cDevX99

    Where and which file should i download( mysql program) for a windows98

    Got to the following url and you will find it under the heading &quot;Windows downloads&quot;: http://www.mysql.com/downloads/mysql-3.23.html
  19. cDevX99

    How Do I Create And Run Scripts

    i am not certain that mysql has a &quot;read from file X&quot; command, however, you can run MySQL with a file as its input source as follows: c:\sqldir> c:\mysql\bin\mysql < c:\scripts\myscript.txt That will open mysql using c:\scripts\myscript.txt for input and mysql will exit at the end of...
  20. cDevX99

    DISTINCT list from two columns

    oh, ic, never mind ... disregard my last post.

Part and Inventory Search

Back
Top