RE: TNS less Oracle Connection (Posted by Pete Sass) - www.foxite.com

From: Pete Sass


	Marathon, Ontario Canada
	Pete Sass

To: Shehzad Khan


	Mum India
	Shehzad Khan

Tags

TNS less Oracle Connection Pete Sass TNS Oracle Connection

Subject:	RE: TNS less Oracle Connection
Thread ID:	181442	Message ID:	181496	# Views:	30	# Ratings:	0
Version:	Visual FoxPro 6		Category:	ODBC, ADO and OLEDB
Date:	Thursday, July 03, 2008 4:47:50 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;")
>
> Shehzad Khan

TNS less Oracle Connection
--------------------------------------------

Provider=OraOLEDB.Oracle;Data Source=(DESCRIPTION=(CID=GTU_APP)(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=myHost)(PORT=myPort)))(CONNECT_DATA=(SID=MyOracleSID)(SERVER=DEDICATED)));User Id=myUsername;Password=myPassword;

Pete "the IceMan", from the Great White North of Canada.

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