VB 6.0 - ODBC Problem - Asked By Prabal Mukherjee on 16-May-01 12:38 AM

I want to set up an ODBC DSN in run time by checking existing drivers after distributing my application.

...If so, I'll try to dig through my old oracle desktop app code and see if I can find this because there is a way to do it.  If not, why not use a DSNless connection.  There's a sample in the Tips & Tricks section in Search Content.
However, a DSNless connection should work as long as the user has SQL Plus installed on the desktop.
Haven't worked on an Oracle desktop app in a little over a year so I'll need to look it up in the Robbe archives.

The rdoRegisterDataSource Method may be used to do this. I am putting some extracts from MSDN Help edition. you can find more about it there. Please see if this suffices ur problem.
rdoRegisterDataSource Method enters connection information for an ODBC data source into the Windows Registry.
The following example illustrates use of the rdoRegisterDataSource method to create a new ODBC data source entry.
Private Sub RegisterDataSource()
Dim en As rdoEnvironment
Dim cnTest As rdoConnection
Dim strAttribs As String
' Build keywords string.
strAttribs = "Description=" _
        & "SQL Server on server SEQUEL" _
  & Chr$(13) & "OemToAnsi=No" _
  & Chr$(13) & "SERVER=SEQUEL" _
  & Chr$(13) & "Network=DBNMPNTW" _
  & Chr$(13) & "Database=WorkDB" _
  & Chr$(13) & "Address=\\SEQUEL\PIPE\SQL\QUERY"
' Create new registered DSN.
rdoEngine.rdoRegisterDataSource "Example", _
         "SQL Server", True, strAttribs
' Open the database.
Set en = rdoEngine.rdoEnvironments(0)
Set cnTest = en.OpenConnection( _
  dsname:="Example", _
  Prompt:=rdDriverNoPrompt, _
  Connect:="UID=;PWD=;")
End Sub

but the matter is I want to get the content of strAttribs
variable if i am using MS Access as backend.
the MSDN refernede fails to give me the right direction
to build the string for Access.

...For a sample DSNLess connection to MS Access.
Screw the DSN.  It's overhead you really don't need and will have a small performance hit over using a DSNLess connection.