Home » RDBMS Server » Enterprise Manager » connecting Vb and oracle
connecting Vb and oracle [message #68428] Thu, 21 August 2003 02:08 Go to next message
Prem
Messages: 79
Registered: August 1998
Member
hello sir..
i am making a project. in my project a am using VB6.0 and oracle personal. pls suugest me write way to connect. i want to know about oracle provider. can I connect my vbprogram through oledb provider. what is written in provider ,userid,password ,inital catalog and database.pls mail me connection property.
Re: connecting Vb and oracle [message #68693 is a reply to message #68428] Tue, 06 July 2004 23:00 Go to previous messageGo to next message
siddharth
Messages: 16
Registered: May 2001
Junior Member
hello sir..
i am making a project. in my project a am using VB6.0 and oracle personal. pls suugest me write way to connect. i want to know about oracle provider. can I connect my vbprogram through oledb provider. what is written in provider ,userid,password ,inital catalog and database.pls mail me connection property.
Re: connecting Vb and oracle [message #68756 is a reply to message #68428] Fri, 27 August 2004 01:50 Go to previous messageGo to next message
abhishant
Messages: 1
Registered: August 2004
Junior Member
hello sir,
i am making a project. in my project i am using VB 6.0 and oracle 9i. Write the way to connect vb and oracle. I want to know about oracle provider. can I connect my vb program through oledb provider. what is written in provider ,userid,password ,inital catalog,command and database.pls mail me connection property.
Re: connecting Vb and oracle [message #68831 is a reply to message #68756] Fri, 29 October 2004 16:07 Go to previous messageGo to next message
shekhar
Messages: 6
Registered: April 2002
Junior Member
plz...............reply quick
Re: connecting Vb and oracle [message #68836 is a reply to message #68693] Fri, 05 November 2004 23:51 Go to previous messageGo to next message
suyaraj
Messages: 2
Registered: November 2004
Junior Member
Plz send mail me if experts knows the solution for the same problem .
Re: connecting Vb and oracle [message #68873 is a reply to message #68756] Fri, 24 December 2004 19:57 Go to previous messageGo to next message
Vidhya
Messages: 3
Registered: March 2003
Junior Member
The Connection String is avaialble in the DataSource.ini which i am describing below:

Save this string in to a notepad and save it as datasource.ini .You need to have the Oracle Client installed in the PC where you are running the program from.

Provider=OraOLEDB.Oracle.1;Data Source=bhafeez_ORACLESERVER;User Id=lfuser;Password=lfuser;

Dim FileNum
FileNum = FreeFile
Open App.path & "DataSource.INI" For Input As FileNum
Input #FileNum, strConnection
Close #FileNum
conn.Open strConnection
Re: connecting Vb and oracle [message #68876 is a reply to message #68428] Tue, 28 December 2004 03:43 Go to previous messageGo to next message
arpan
Messages: 2
Registered: June 2001
Junior Member
i want business managment project
Re: connecting Vb and oracle [message #68886 is a reply to message #68756] Sun, 09 January 2005 19:11 Go to previous messageGo to next message
manokar livingston
Messages: 1
Registered: January 2005
Junior Member
please send to the oracle to vb connect method in my mail id. thanking you,

your's,
manokar ivingston.j
Re: connecting Vb and oracle [message #68912 is a reply to message #68756] Thu, 03 February 2005 01:47 Go to previous message
Vikash Mehta
Messages: 1
Registered: February 2005
Junior Member
con.ConnectionString = "PROVIDER=MSDASQL;DRIVER=
{Microsoft ODBC for oracle};SERVER={server name};UID={user
id};PWD={password};"

con.Open()
Previous Topic: Oracle Management Server Service not starting (very urgent)
Next Topic: TNS:protocol adapter error
Goto Forum:
  


Current Time: Tue May 17 18:39:32 CDT 2022