Search results for query: *

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...

...<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...

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...

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

...= &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...

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.

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?

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...

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...

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

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

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

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...

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.

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...

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

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...

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

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...

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