f



how to connect database and application servers

Hi

anyone can explain me how to connect between database and application
servers.
both are linux servers. as per my knowledge listeners can do.

is there any other tools needed like tcp/ip's.

i know, we need web servrs tools to connect application and web
server.
like this do we need any other tools.

thanks
0
mvrrms (15)
1/24/2009 7:19:58 AM
comp.unix.aix 10963 articles. 1 followers. drkirkby (98) is leader. Post Follow

0 Replies
449 Views

Similar Articles

[PageSpeed] 41

Reply:

Similar Artilces:

Permanent connection between a LINUX server and a UNIX AIX server
Hello, I created, for a customer LAMBDA, a Intranet site with PHP and MySQL technology. This site is on a LINUX server. I wish to connect this LINUX server on a UNIX server to directly access to the FILES present on the disk. I am not the supplier of system IBM of my customer LAMBDA. I am service provider for this customer LAMBDA. Environment of the UNIX server : -------------------------------- - Computer IBM RISC 6000 Under-dimentionned! - SYSTEM UNIX AIX 4.3 - No database engine - No SSH port - No FTP port - Only a Telnet port - 10 clients connected in permanence to th...

Connecting to database from application server?
Hi, I'm newbie to Oracle and need you help. How can I start procedure from application server? i.e. how to register my db in application server or what else is necessary to do? I would be very greatful for any tip. Best regards, k -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 kiwi wrote: > Hi, > > I'm newbie to Oracle and need you help. > > How can I start procedure from application server? > i.e. how to register my db in application server or what else is necessary > to do? > > I would be very greatful for any tip. > > Best regards, > k > > Stop cross-posting, please! Regulars read all oracle ng's. Oracle Stored procedure? If so, try http://vanbortel.blogspot.com/2006/07/authentication-in-modplsql.html - -- Regards, Frank van Bortel Top-posting is one way to shut me up... -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.1 (MingW32) iD8DBQFGm7RYLw8L4IAs830RAsfqAJ0Y/PN4NpnORz8YGHxm2XCEypHi5QCfaiXs Yx3Urt2TffNHBl9DIiTT+3g= =bQf+ -----END PGP SIGNATURE----- -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 kiwi wrote: > Hi, > > I'm newbie to Oracle and need you help. > > How can I start procedure from application server? > i.e. how to register my db in application server or what else is necessary > to do? > > I would be very greatful for any tip. > > Best regards, > k > > Answered in cdo.misc - -- Regards, Frank van...

connect a database in remote server (can connect to the server via SSH)
Hi, All: My perl code need to connect to a database (MySQL) in remote server, and I can login that server via SSH. I am a new to perl, can anyone give me a hint how can I do that. Many thanks. Xiaoyu zhangxiaoyu912@gmail.com wrote: > My perl code need to connect to a database (MySQL) in remote server, > and I can login that server via SSH. You don't need to have ssh access to the remote database server in order to be able to connect to the database (at least if the database server is configured to wait for remote connections). > I am a new to perl, can anyone give me a hint h...

Username of a user connecting to a database via an application server
We have a J2EE application and we use Orion application server to connect to the database. All these connections to the database are made as a single user. Now it becomes difficult to find out what is the SID of a particular user because everyone connects as the same user. It becomes difficult to identify which user is doing what. Is there a way to overcome this. Thanks. picksdba wrote: > We have a J2EE application and we use Orion application server to > connect to the database. All these connections to the database are made > as a single user. Now it becomes difficult to find out what is the SID > of a particular user because everyone connects as the same user. > It becomes difficult to identify which user is doing what. > > Is there a way to overcome this. > > Thanks. See the dbs_application_info package. It is designed to allow the front-end program to post information on itself to the v$session dynamic performance view. It is often used to identify the real end user and application module being executed. HTH -- Mark D Powell -- On 27 Jul 2006, Utpal.Dhar@gmail.com wrote: > We have a J2EE application and we use Orion application server to > connect to the database. All these connections to the database are > made as a single user. Now it becomes difficult to find out what is > the SID of a particular user because everyone connects as the same > user. It becomes difficult to identify which user is doing what. > >...

How to configure application server to connect to a two-node oracle RAC database
We have a java based application which will access the two node RAC database via the Orion Application Server. What should be done so that the Orion Application Server uses both the nodes to make connections? Right now the orion application server accesses the RAC database via the jdbc thin client where you have to specify the ip address of the database server and the listerner port and the instance name. If I do it this way then the application server just connects to the particular instance that I give it. Thanks Can you use the OCI driver? Regards, Steve I can use the OCI driver if it serves the purpose. Could you elaborate a bit more on how to configure it and where to do it? Thanks, Utpal The OCI driver uses the Oracle network configuration file (tnsnames.ora) on the client (application server, in this case) for connectivity definitions. This is where you can configure load balancing and failover options. An example is below... YOUR_DB_NAME = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = vip-node1)(PORT = 2484)) (ADDRESS = (PROTOCOL = TCP)(HOST = vip-node2)(PORT = 2484)) (LOAD_BALANCE = yes) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = your_service_name) (FAILOVER_MODE = (TYPE = SELECT) (METHOD = BASIC) (RETRIES = 90) (DELAY = 5) ) ) ) Read up on the docs at tahiti.oracle.com, as they go into great detail as to the different configuration options. Regards, Steve ...

Windows server, Unix client, connection refused on client connect.
Hi I developed a client-server application. //**************** client(UNIX) **************** // connect with timeout: // 1. set socket NONBLOCKING // 2. connect with timeout using select // 3. set socket to BLOCKING againg int my_connect(int sockremote, long sock_addr, short port, int timeout) { int res; struct sockaddr_in addr; long arg; fd_set myset; struct timeval tv; int valopt; socklen_t lon; addr.sin_family = AF_INET; addr.sin_port = htons(port); addr.sin_addr.s_addr = sock_addr; // Set non-blocking if( (arg = fcntl(sockremote, F_GETFL, NULL)) < 0) { ...

Using the DBI to connect to an Oracle server w/o connecting to a database
I've searched for the answer to this problem and have not seen it (which suggests what the answer might be ;-) ). Is it possible to use DBI (and DBD::Oracle) to connect to an Oracle server without connecting to a database? This would be the DBI equivalent of: sqlplus /nolog SQL> connect user/passwd@database; or, more similarly: sqlplus /nolog @my.sql where my.sql might be: connect user/passwd@database; select ... etc. I'm thinking this is not possible, but I hope it is. Thanks. Quoth Tim <google@hoodfamily.org>: > I've searched for the answer to this problem and...

need to restore old database (database server 4.01 AIX)
hi. i need to restore an old database. The db was backed up using a DLT drive, using 2 volumes. The content for the tapes was copied to file onto Solaris machine using rsh and dd (for backup purposes). Now, the drive is defective and can't read the tapes anymore. Server is AIX 4.3.2 and database is IBM DB2 Server (DB2 for AIX Version 2.1.2) I tried doing an NFS export from solaris machine. and doing restore database ..... from /mnt but i got the following message: SQL2542N No match for a database image file was found based on the source database alias and timestamp ...

connectivity to unix server
I am using SCO OPENSERVER 5.0.0 with 35 users.I am now facing a problem, the number of telnet connections are 25 maximum. If the 26 connection is requested we are getting the message \"ALL PORTS ARE IN USE\" and it is not connected. I would appreciate if you can send me a solution to increase the number of telnet connections from 25 to 35. vijay <vgodavarthy@rediffmail.com> wrote: > I am using SCO OPENSERVER 5.0.0 with 35 users.I am now facing a > problem, the number of telnet connections are 25 maximum. If the 26 > connection is requested we are getting the message \...

US-TX-Austin: Application Developer-AIX, AIX, UNIX; 7M (45304457606)
US-TX-Austin: Application Developer-AIX, AIX, UNIX; 7M (45304457606) ==================================================================== Position: Application Developer-AIX Reference: MKL00780 Location: Austin TX Duration: 7M Skills: AIX UNIX Scope: Unix AIX preferred system admin skills and experience. Experience configuring all types of servers, storage and networks. Excellent written communication skills must be able to clearly describe a problem and resolution status Flexibl...

US-TX-Austin: Application Developer-AIX, AIX, UNIX; 7M (45304432405)
US-TX-Austin: Application Developer-AIX, AIX, UNIX; 7M (45304432405) ==================================================================== Position: Application Developer-AIX Reference: MKL00780 Location: Austin TX Duration: 7M Skills: AIX UNIX Scope: Unix AIX preferred system admin skills and experience. Experience configuring all types of servers, storage and networks. Excellent written communication skills must be able to clearly describe a problem and resolution status Flexibl...

Database server connection
I am trying to using sqlserver as back-end for an application(web) running on the window 2X, one thing I am not sure is that once I establish the connection between database server and application, should I keep this connection open while application is running, or only open it when there is a requet to qury records from database? Thanks for your help. "Leon" <penghao98@hotmail.com> wrote in message news:89a0a7de.0409221926.6c394129@posting.google.com... >I am trying to using sqlserver as back-end for an application(web) running > on the window 2X, one thing I am not sure is that once I establish the > connection between database server and application, should I keep this > connection open while application is running, or only open it when > there is a requet to qury records from database? > > Thanks for your help. I believe the usual approach is to leave the connection open, to avoid the overhead associated with opening and closing the connection again and again. This is one reason for using connection pooling, for example. You might want to post in a forum for your client library (eg ADO, JDBC) or development environment (eg ASP, PHP) to see if there are any specific considerations for your application. Simon penghao98@hotmail.com (Leon) wrote in message news:<89a0a7de.0409221926.6c394129@posting.google.com>... > I am trying to using sqlserver as back-end for an application(web) running > on the window 2X, one t...

US-TX-Austin: Application Developer-AIX, AIX, UNIX; 7M (45303583160)
US-TX-Austin: Application Developer-AIX, AIX, UNIX; 7M (45303583160) ==================================================================== Position: Application Developer-AIX Reference: MKL00780 Location: Austin TX Duration: 7M Skills: AIX UNIX Scope: Unix AIX preferred system admin skills and experience. Experience configuring all types of servers, storage and networks. Excellent written communication skills must be able to clearly describe a problem and resolution status Flexibl...

US-TX-Austin: Application Developer-AIX, AIX, UNIX; 7M (45304132401)
US-TX-Austin: Application Developer-AIX, AIX, UNIX; 7M (45304132401) ==================================================================== Position: Application Developer-AIX Reference: MKL00780 Location: Austin TX Duration: 7M Skills: AIX UNIX Scope: Unix AIX preferred system admin skills and experience. Experience configuring all types of servers, storage and networks. Excellent written communication skills must be able to clearly describe a problem and resolution status Flexibl...

US-TX-Austin: Application Developer-AIX, AIX, UNIX; 7M (45304732416)
US-TX-Austin: Application Developer-AIX, AIX, UNIX; 7M (45304732416) ==================================================================== Position: Application Developer-AIX Reference: MKL00780 Location: Austin TX Duration: 7M Skills: AIX UNIX Scope: Unix AIX preferred system admin skills and experience. Experience configuring all types of servers, storage and networks. Excellent written communication skills must be able to clearly describe a problem and resolution status Flexibl...

US-TX-Austin: Application Developer-AIX, AIX, UNIX; 7M (45304132401)
US-TX-Austin: Application Developer-AIX, AIX, UNIX; 7M (45304132401) ==================================================================== Position: Application Developer-AIX Reference: MKL00780 Location: Austin TX Duration: 7M Skills: AIX UNIX Scope: Unix AIX preferred system admin skills and experience. Experience configuring all types of servers, storage and networks. Excellent written communication skills must be able to clearly describe a problem and resolution status Flexible schedule must be able to work 1st or 2nd shift any day of the week . Self-started no time for OJT. Extra points TCP IP, Oracle, DB2 database admin, complex networks. Please send your current resume in confidence to "Karen Lehman" <klehman@eurosoft-inc.com> ..45304132401. ...

US-TX-Austin: Application Developer-AIX, AIX, UNIX; 7M (45304157603)
US-TX-Austin: Application Developer-AIX, AIX, UNIX; 7M (45304157603) ==================================================================== Position: Application Developer-AIX Reference: MKL00780 Location: Austin TX Duration: 7M Skills: AIX UNIX Scope: Unix AIX preferred system admin skills and experience. Experience configuring all types of servers, storage and networks. Excellent written communication skills must be able to clearly describe a problem and resolution status Flexibl...

US-TX-Austin: Application Developer-AIX, AIX, UNIX; 7M (45303832413)
US-TX-Austin: Application Developer-AIX, AIX, UNIX; 7M (45303832413) ==================================================================== Position: Application Developer-AIX Reference: MKL00780 Location: Austin TX Duration: 7M Skills: AIX UNIX Scope: Unix AIX preferred system admin skills and experience. Experience configuring all types of servers, storage and networks. Excellent written communication skills must be able to clearly describe a problem and resolution status Flexible schedule must be able to work 1st or 2nd shift any day of the week . Self-started no time for OJT. Extra points TCP IP, Oracle, DB2 database admin, complex networks. Please send your current resume in confidence to "Karen Lehman" <klehman@eurosoft-inc.com> ..45303832413. ...

US-TX-Austin: Application Developer-AIX, AIX, UNIX; 7M (45304432405)
US-TX-Austin: Application Developer-AIX, AIX, UNIX; 7M (45304432405) ==================================================================== Position: Application Developer-AIX Reference: MKL00780 Location: Austin TX Duration: 7M Skills: AIX UNIX Scope: Unix AIX preferred system admin skills and experience. Experience configuring all types of servers, storage and networks. Excellent written communication skills must be able to clearly describe a problem and resolution status Flexible schedule must...

US-TX-Austin: Application Developer-AIX, AIX, UNIX; 7M (45304732416)
US-TX-Austin: Application Developer-AIX, AIX, UNIX; 7M (45304732416) ==================================================================== Position: Application Developer-AIX Reference: MKL00780 Location: Austin TX Duration: 7M Skills: AIX UNIX Scope: Unix AIX preferred system admin skills and experience. Experience configuring all types of servers, storage and networks. Excellent written communication skills must be able to clearly describe a problem and resolution status Flexible schedule must be able to work 1st or 2nd shift any day of the week . Self-started no time for OJT. Extra points TCP IP, Oracle, DB2 database admin, complex networks. Please send your current resume in confidence to "Karen Lehman" <klehman@eurosoft-inc.com> ..45304732416. ...

US-TX-Austin: Application Developer-AIX, AIX, UNIX; 7M (45304132401)
US-TX-Austin: Application Developer-AIX, AIX, UNIX; 7M (45304132401) ==================================================================== Position: Application Developer-AIX Reference: MKL00780 Location: Austin TX Duration: 7M Skills: AIX UNIX Scope: Unix AIX preferred system admin skills and experience. Experience configuring all types of servers, storage and networks. Excellent written communication skills must be able to clearly describe a problem and resolution status Flexibl...

Using one single-application connection vs. one connection for every operation to SQL-Server via ADO.NET
Dear members, I'am thinking about the "best" way to connect to my sql-server via ADO.Net (if there is a best way). My application uses the sql-server very intensively. At the moment every database-operation opens a connection, executes and then closes the connection. Another way would be to use only a single connection to the database, which is opened when the application starts. What do you think is the better way to get a high performing sql server: using one single application connection vs. using one connection for every operation? Cheers, Sebastian since ADO.net already does the connection pooling for you, as long as you are using the SQL connection object (and not the more generic oledb connection object), you are best off doing what you are doing. -- --- Nick Malik [Microsoft] MCSD, CFPS, Certified Scrummaster http://blogs.msdn.com/nickmalik Disclaimer: Opinions expressed in this forum are my own, and not representative of my employer. I do not answer questions on behalf of my employer. I'm just a programmer helping programmers. -- "Sebastian" <habukira@yahoo.de> wrote in message news:1123747744.558716.140580@g49g2000cwa.googlegroups.com... > Dear members, > > I'am thinking about the "best" way to connect to my sql-server via > ADO.Net (if there is a best way). > > My application uses the sql-server very intensively. At the moment > every database-operation opens a connectio...

Connection to sql server database
Hi , what are the alternatives for connecting to sql server 2000 using vb 6 locally or remotely ? is it same as connecting to Access using ADO or DAO ? pls advise. Thanks Regards Daniel Yes, It more simillar to establish the connection Using ADO but I haven't tried DAO yet now, it not advisiable too. ...

Connection to a database on an external server
Hi, I have my own database on a server and the same database on local. I want to copy all my database from the main server to my local host (I execute this code from my PC and not my main server) $id_link_ref = mysql_connect('localhost','database_name','password'); $id_link_local = mysql_connect('localhost','root','password'); it doesn't work :( Why ? What is the problem ? ..oO(Tschu�) >I have my own database on a server and the same database on local. >I want to copy all my database from the main server to my local host >(I execute this code from my PC and not my main server) > >$id_link_ref = mysql_connect('localhost','database_name','password'); >$id_link_local = mysql_connect('localhost','root','password'); > >it doesn't work :( "Doesn't work" is not really an error description. But your code above contains several obvious problems: * The parameters in the first call are wrong. The first parameter is the server name or address, which should obviously not be 'localhost' if you want to connect to an external server. * Running your local database as 'root' is a really bad idea. You should consider to create a normal user account with restricted permissions for the daily work. Use 'root' only for maintenance purposes. * After all connecting to an external database server is often not possible at all for...

Web resources about - how to connect database and application servers - comp.unix.aix

Application - Wikipedia, the free encyclopedia
Text is available under the Creative Commons Attribution-ShareAlike License ;additional terms may apply. By using this site, you agree to the ...

Patent application could see the Apple Watch calling 911 when it detects a heart-attack
A patent application describes how the Apple Watch and iPhone could work together to detect medical emergencies like a heart attack, and automatically ...

Webscale offers a fast track to delivering web applications
Running an application or server in the cloud has many advantages, but it doesn't guarantee scalability. It can be hard to predict demand, leading ...

MBA: Mortgage Applications Decreased in Latest Weekly Survey, Purchase Applications up 33% YoY
From the MBA: Refinance Applications Continue to Drop in Latest MBA Weekly Survey Mortgage applications decreased 3.3 percent from one week ...

PDF: Application essays by CPD superintendent finalists
C2E2, meet Kristin Cavallari and 20+ other things to do this weekend Breaking News News Local news Breaking News PDF: Application essays by CPD ...

Mortgage applications fall 3.3%
After weeks of volatile interest rates, markets settled slightly last week, but that didn't help the mortgage business.

Cisco Throws Down $150 Million Challenge To Application Developers
Cisco Throws Down $150 Million Challenge To Application Developers CRN Cisco is driving its application development community to build custom ...

Plimsoll Buys Stake In Magnify Media; BAFTA Scholarship Applications Open – Global Briefs
UK and U.S.-based factual entertainment and wildlife producer Plimsoll Productions has acquired a minority stake in specialist distributor Magnify ...

TSMC, MediaTek to co-develop products for IoT and wearable applications
... their commitment to a long-term partnership to continue developing innovative products for Internet of Things (IoT) and wearable device applications ...

App Annie Acquires Application Analyst AppScotch
With San Francisco-headquartered AppScotch, this marks App Annie's third acquisition in two years following the acquisition of Distimo and Mobidia. ...

Resources last updated: 3/26/2016 6:35:09 PM