Home » Open Source » Programming Interfaces » Connection with the server (merged)
Connection with the server (merged) [message #284322] Thu, 29 November 2007 06:36 Go to next message
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
Re: Connection with the server [message #284330 is a reply to message #284322] Thu, 29 November 2007 06:53 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Use ODBC.

Regards
Michel
Re: Connection with the server [message #284878 is a reply to message #284322] Sun, 02 December 2007 05:56 Go to previous messageGo to next message
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
Re: Connection with the server [message #284896 is a reply to message #284878] Sun, 02 December 2007 12:11 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
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
Re: Connection with the server [message #287205 is a reply to message #284322] Tue, 11 December 2007 07:01 Go to previous messageGo to next message
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
tnsnames.ora [message #287488 is a reply to message #284322] Wed, 12 December 2007 06:32 Go to previous messageGo to next message
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
Re: tnsnames.ora [message #287492 is a reply to message #287488] Wed, 12 December 2007 06:36 Go to previous messageGo to next message
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.
Re: tnsnames.ora [message #287495 is a reply to message #287488] Wed, 12 December 2007 06:56 Go to previous message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Don't multiply the topics on the same sibject.

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


Current Time: Thu Mar 28 07:03:29 CDT 2024