OraFAQ Forum: Open Database Interfaces » Connection with the server (merged)

Home » Open Source » Open Database Interfaces » Connection with the server (merged)

Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend

Connection with the server (merged) [message #284322]

Thu, 29 November 2007 06:36

ashraf_al_ani
Messages: 92
Registered: October 2007
Location: Iraq

Member

Dear all

I need (2 tables) (from the server) in my MS ACCESS application(client) and Visual Basic6 application
so how can i do the connection

best regards

Report message to a moderator

Re: Connection with the server [message #284330 is a reply to message #284322]

Thu, 29 November 2007 06:53

Michel Cadot
Messages: 54704
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Use ODBC.

Regards
Michel

Report message to a moderator

Re: Connection with the server [message #284878 is a reply to message #284322]

Sun, 02 December 2007 05:56

ashraf_al_ani
Messages: 92
Registered: October 2007
Location: Iraq

Member

Dear
thanks brother for your answer
but can u tell me in steps how to create an ODBC

best wishes

Report message to a moderator

Re: Connection with the server [message #284896 is a reply to message #284878]

Sun, 02 December 2007 12:11

Michel Cadot
Messages: 54704
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

You don't create ODBC, ODBC means Open DataBase Connectivity, it is a way (and API) to connect and use database. It is known of MS/Access and VB/VBA.

You have to create a DSN using the ODBC administration tool that you'll find in Control Panel.

(Of course I assume you want to connect to an Oracle database as this is an Oracle forum.)

Regards
Michel

Report message to a moderator

Re: Connection with the server [message #287205 is a reply to message #284322]

Tue, 11 December 2007 07:01

ashraf_al_ani
Messages: 92
Registered: October 2007
Location: Iraq

Member

dear all

REPORTING_CDRS =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.100.1.211)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = cdrs)
)
)
how can h get benefit from above to create the ODBC
and another question we use the TNSNAMES.ora in the db or the developer for the odbc because both the db and the developer have tnsnames.ora

best wishes

Report message to a moderator

tnsnames.ora [message #287488 is a reply to message #284322]

Wed, 12 December 2007 06:32

ashraf_al_ani
Messages: 92
Registered: October 2007
Location: Iraq

Member

Report message to a moderator

Re: tnsnames.ora [message #287492 is a reply to message #287488]

Wed, 12 December 2007 06:36

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

Your question is incomplete for me.
what is actual requirement.

>because both the db and the developer have tnsnames.ora
You have to configure both files for tns entry.

Report message to a moderator

Re: tnsnames.ora [message #287495 is a reply to message #287488]

Wed, 12 December 2007 06:56

Michel Cadot
Messages: 54704
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Don't multiply the topics on the same sibject.

Regards
Michel

Report message to a moderator

Previous Topic:	EXECUTE IMMEDIATE - Bind Variable - DB-Link
Next Topic:	Executing a Stored Procedure with visual basic 6

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jun 19 09:19:25 CDT 2013

Total time taken to generate the page: 0.13698 seconds