Search results for query: *

Hello, I'm trying to decide which control will be most useful for this situation (several maintenance forms). I need to display a list of options and show the user which options are already selected by the current customer. They need to be able to unselect an option also. Would a checked...

V$session layout jcard, Thanks for the reply. I think I had a problem in a subroutine returning a datareader. I put in the SQL you suggested. I've been searching for the layout of what's being returned, but no luck. I see I get 47 fields, but I don't know what they are! Thanks again for...

More info According to the Oracle DBA, he can max out the connections at 300 (it's about 250 now). With about 10 copies of my app running, we hit the max. I'm still going through the code looking for open connections. What would be REALLY useful is some code I can insert into the VB app to...

Connection open? I might be leaving connections open. Is there a way to monitor how many connections are open in my VB code? Thanks, Carl

Hello, I have a Visual Studio 2005 project, using VB 2005 and Oracle as my database. After rolling out the program to several user machines, they are getting the "ORA - 00020 Maximum number of processes (%s) exceeded." error. It seems, 3 users are okay but when a 4th tries to use it, the...

How would I check for the "TNS_ADMIN env variable"? Unfortunately, I had to remove Oracle 10 so I could make changes to my project and have the clients be able to run it. I will try again in about a week because I really like the Oracle explorer in VS 2005 that you suggested. Many Thanks, Carl

cjard, That sqlnet.ora file was in my 10 directory. I made some progress understanding why I had to specify the domain name. During installation of 10, I couldn't usefully run a "test" on the connection. I kept trying different server names until this worked. Someone here told me not to...

Another clue When I rename SLQNet.ora to something else, so it's not recognized, and only have tnsnames.ora present, it works. That is to say, I can connect with Oracle Explorer and Server Explorer in VS 2005. My tnsnames.ora is: # TNSNAMES.ORA Network Configuration File...

More info I have obviously changed something. When I use Oracle Explorer in Visual Studio 2005, I can't connect to my database. I get the same error - "ORA 12154 -TNS could not resolve..." I get the same result connecting or adding a Data Connection through VS 2005 Server Explorer. Any...

Not yet Ah, cjard, we meet again! Thanks for the reply. I did as you suggested with no success. I hope I haven't messed thing up with the Net Manager and Net Configuration Assistant. MANY THANKS for your help, Carl

Hello All, I have a VS 2005 VB project. I was using Microsoft's Oracle driver (All worked), and then installed Oracle Developer Tools for Visual Studio .NET with ODAC 10.2.0.2.21. After doing so, I received this error when trying to open a dataset in the designer. "Failed to open a connection...

Last Thanks cjard; You've cleared up a few problems I was having by thinking I had a Primary Key. Thanks for explaining how you created your Primary Key. Thanks Again, Carl

Primary Key Question I noticed your example has "PRIMARY KEY ("PREF_APP", "PREF_GROUP", "PREF_NAME") " and my code has CONSTRAINT "TBLUSERPK" PRIMARY KEY ("LOGINNAME") The only place I found to enter a Primary Key was in the Constraint Tab, not the Index Tab as I would expect. In the Index...

Found that too - and GOOD NEWS! I now have: CREATE TABLE "RTRACK_DATA"."TBLUSER" ( "LOGINNAME" VARCHAR2(20) NOT NULL ENABLE, "INITIALS" VARCHAR2(4), "STATUS" VARCHAR2(1) DEFAULT 'A' NOT NULL ENABLE, "FULLNAME" VARCHAR2(50), "FIRSTNAME" VARCHAR2(20), "LASTNAME" VARCHAR2(30)...

Back up... Finally, back up. If you could point me to the right area to manage the Primary Key, I would appreciate it. Thanks, Carl

Now what? I installed Oracle Developer Tools for Visual Studio .NET with ODAC 10.2.0.2.21. Now I can't connect to the Oracle DB at all! ORA-12154: TNS Could not resolve the connect Identifier specified. Help, Carl

Version Question I am using Oracle 9, will the Oracle Developer Tools for Visual Studio .NET with ODAC 10.2.0.2.21 work? Thanks, Carl

SQLTools I downloaded SQLTools and pasted in the command you sent, and got: CREATE TABLE "RTRACK_DATA"."TBLUSER" ( "LOGINNAME" VARCHAR2(20) NOT NULL ENABLE, "INITIALS" VARCHAR2(4), "STATUS" VARCHAR2(1) DEFAULT 'A' NOT NULL ENABLE, "FULLNAME" VARCHAR2(50), "FIRSTNAME" VARCHAR2(20)...

2nd try I did it agian with SQL*Plus and received: DBMS_METADATA.GET_DDL('TABLE','TBLUSER') -------------------------------------------------------------------------------- CREATE TABLE "RTRACK_DATA"."TBLUSER" ( "LOGINNAME" VARCHAR2(20) NOT NULL 1 row selected. Carl

select dbms_metadata. Is this it? SQL> select dbms_metadata.get_ddl('TABLE', 'TB DBMS_METADATA.GET_DDL('TABLE','TBLUSER') ----------------------------------------------- CREATE TABLE "RTRACK_DATA"."TBLUSER" ( "LOGINNAME" VARCHAR2(20) NOT NULL Carl