| connecting Vb and oracle [message #68428] |
Thu, 21 August 2003 02:08  |
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  |
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 |
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 #68873 is a reply to message #68756] |
Fri, 24 December 2004 19:57 |
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
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
