Home » Developer & Programmer » Forms » connecting d2k with msccess
connecting d2k with msccess [message #338451] Tue, 05 August 2008 02:53 Go to next message
sabbi.sandhu
Messages: 5
Registered: August 2008
Location: ludhiana
Junior Member
what changes i need to make in TNS file to connect d2k with Ms -Access
Re: connecting d2k with msccess [message #338465 is a reply to message #338451] Tue, 05 August 2008 03:31 Go to previous messageGo to next message
misragopal
Messages: 125
Registered: June 2005
Location: New Delhi, india
Senior Member

1. You need to install OCA (oracle client adapter) from d2k installer.
2. Create DSN Entry (in ODBC Data Source Administrator).
3. In connect string, you need to specify "ODBC:DSN NAME".


[Updated on: Tue, 05 August 2008 05:55]

Report message to a moderator

Re: connecting d2k with msccess [message #338586 is a reply to message #338465] Tue, 05 August 2008 07:10 Go to previous messageGo to next message
sabbi.sandhu
Messages: 5
Registered: August 2008
Location: ludhiana
Junior Member
Dear Still i m unable to connect
i create a system dns with name "emp"
through obdc in control panel
and set my user name and password as abc/abc

in d2k while connecting i wrote
abc/abc@odbc:emp

i m getting some message in unreadable form


please Suggest
connecting d2k with msccess [message #338810 is a reply to message #338465] Wed, 06 August 2008 00:31 Go to previous messageGo to next message
sabbi.sandhu
Messages: 5
Registered: August 2008
Location: ludhiana
Junior Member
Dear Sir,

Still i m unable to connect
i created a system dns with name "emp"
through obdc in control panel
and set my user name and password as abc/abc

in d2k while connecting i wrote
abc/abc@odbc:emp

i m getting some message in unreadable form


please Suggest
Re: connecting d2k with msccess [message #339611 is a reply to message #338810] Thu, 07 August 2008 23:23 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Search this forum for 'odbc' and you will find:
ODBC
http://www.orafaq.com/forum/t/88308/67467/
look at bottom of http://www.orafaq.com/forum/t/91999/67467/
Also http://www.orafaq.com/forum/t/93840/67467/
By Maaher
http://www.orafaq.com/forum/m/286342/72104/?srch=heterogeneous#msg_286342

connect Forms 6i with MS Access
http://www.orafaq.com/forum/m/172737/67467/?srch=odbc+tnsnames#msg_172737

David
Previous Topic: Iconic Buttons
Next Topic: Call report from Form menu
Goto Forum:
  


Current Time: Sat Dec 10 16:18:59 CST 2016

Total time taken to generate the page: 0.24322 seconds