connecting with SQL Server

You are welcome. :)

Usually I will place the INI file in the same folder as my EXE. While creating the setup package you need to make sure that the INI file is included in it. You will have to manually add it in the PDW Wizard.

Hey guys,
I need to know how to setup a control when clicked will setup ODBC DSN for the user (Oracle database not Sql Server)
I saw Sql server example on MSDN but I need it for Oracle.
Your help will be greatly appreciated.
Thanks,
Christine

i have create two pros^ In module for connection the data base first getconnection and get
connection1_for difrent datbase __________________________________________________ ____
Public Sub getConnection()
'On Error GoTo Trap
Set con = New ADODB.Connection
With con
.ConnectionString = "DSN=DSN1"
.Open
End With
Exit Sub
'Trap:
' MsgBox Err.Description, vbInformation, "Connection is Failed"
' Exit Sub_______________________________________
Public Sub getConnection1()
'On Error GoTo Trap
Set con = New ADODB.Connection
With con1
.ConnectionString = "DSN=DSN2"
.Open
End With
Exit Sub
'Trap:
' MsgBox Err.Description, vbInformation, "Connection is Failed"
' Exit Sub_______________________________________

when i want to use second data base then
i write then these comment in the form
set con=nothing
getConnection1
After the complete the work
set con1=nothing
getConnection1
then you get privi^ database connection


Shahid