OraFAQ Forum: Forms » connecting d2k with msccess

Home » Developer & Programmer » Forms » connecting d2k with msccess

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

connecting d2k with msccess [message #338451]

Tue, 05 August 2008 02:53

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

Report message to a moderator

Re: connecting d2k with msccess [message #338465 is a reply to message #338451]

Tue, 05 August 2008 03:31

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

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

Report message to a moderator

connecting d2k with msccess [message #338810 is a reply to message #338465]

Wed, 06 August 2008 00:31

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

Report message to a moderator

Re: connecting d2k with msccess [message #339611 is a reply to message #338810]

Thu, 07 August 2008 23:23

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS 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

Report message to a moderator

Previous Topic:	Iconic Buttons
Next Topic:	Call report from Form menu

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Mar 12 08:13:42 CDT 2025