RE: TNS less Oracle Connection (Posted by Andy Kramek) - www.foxite.com

From: Andy Kramek


	Westminster Circle, Akron Ohio - United States
	Andy Kramek

To: Shehzad Khan


	Mum India
	Shehzad Khan

Tags

TNS less Oracle Connection Andy Kramek TNS Oracle Connection

Subject:	RE: TNS less Oracle Connection
Thread ID:	181442	Message ID:	181461	# Views:	34	# Ratings:	0
Version:	Visual FoxPro 6		Category:	ODBC, ADO and OLEDB
Date:	Thursday, July 03, 2008 12:46:05 PM

> Hello,
> Freinds
>
> I want to create a TNS-Less Oracle Connection from VFP
> i.e without creating orcale ServiceName in User Machine
>
> I have tried but it is not working
>
> ?SQLSTRINGCONNECT("Provider=MSDASQL.1;Data Source=(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.10.10)(PORT = 1527)))(CONNECT_DATA =(SERVICE_NAME = ORADbc)));User Id=username;Password=pass;")

I am not sure you can do that! I think you always need a TNS Name file on the user machine. As I understand it, Oracle runs a listener for remote connections and that is configured to block 'anonymous' requests.

Regards
Andy Kramek
Microsoft MVP (Visual FoxPro)
Tightline Computers Inc, Akron Ohio, USA

COMPLETE THREAD

TNS less Oracle Connection Posted by Shehzad Khan @ 7/3/2008 10:07:19 AM

RE: TNS less Oracle Connection Posted by Anders Altberg @ 7/3/2008 11:28:34 AM

RE: TNS less Oracle Connection Posted by Cetin Basoz @ 7/3/2008 11:30:04 AM

RE: TNS less Oracle Connection Posted by Andy Kramek @ 7/3/2008 12:46:05 PM

RE: TNS less Oracle Connection Posted by Pete Sass @ 7/3/2008 4:47:50 PM

RE: TNS less Oracle Connection Posted by Shehzad Khan @ 7/4/2008 3:25:18 PM

RE: TNS less Oracle Connection Posted by Anders Altberg @ 7/4/2008 6:31:45 PM

RE: TNS less Oracle Connection Posted by Shehzad Khan @ 7/5/2008 9:33:26 AM

RE: TNS less Oracle Connection Posted by Anders Altberg @ 7/3/2008 7:57:20 PM