| Connection string [message #371577] |
Thu, 09 November 2000 07:46  |
Martin
Messages: 83
Registered: February 2000
|
Member |
|
|
hi,
could you send me connection string for connection with Visual Basic through ADO & OLE DB provider to Oracle.
Kind regards Martin
|
|
|
|
| Re: Connection string [message #371889 is a reply to message #371577] |
Mon, 18 December 2000 07:52  |
Sagar Pradhan
Messages: 6
Registered: December 2000
|
Junior Member |
|
|
There are many ways by which you can establish a connection.This is the simplest one.
create a DSN using ODBC32 bit in control panel
Use Microsoft Oracle driver.
Before creating DSN you have to select a Provider name or driver name.
Option Explicit
dim Mycnn as adodb.connection
dim MyRst as adodb.recordset
sub form_load ()
set MyCnn = new adodb.connection
set MyRst = new adodb.recordset
'Only this two are actually sufficient
'Rest of the things has to specify while creating
'DSN.
MyCnn.open "DSN=; PWD="
'Here your connections is opened
MyRst.open("select * from abc",MyCnn,.....,.....)
'Here you recordset is open
msgbox"Connection Done."
End Sub
While opening recordset there are other parameter to set like cursor type etc.
This will help you.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
