What does the "SRVR" parameter used for?
From: George Smythe <DingaGun_at_yahoo.com>
Date: 2000/06/20
Message-ID: <8io1td011qi_at_enews1.newsguy.com>#1/1
Date: 2000/06/20
Message-ID: <8io1td011qi_at_enews1.newsguy.com>#1/1
In the following snippet, I'm not sure what the SRVR does. I thought if you are trying to connect to Oracle via ODBC, the DSN will specify the TNS service name. No matter what value fServer is, the following always connects to the same data source. If I want to use the SRVR parameter, do I need to create a more generic DSN?
MyConnect = "ODBC;DSN=" & fDSN & ";SRVR=" & fServer & ";UID=" & fUID & ";PWD=" & fPWD
Set MySourceDB = MySourceWorkSpace.OpenDatabase("", False, False, MyConnect)
Thanks Received on Tue Jun 20 2000 - 00:00:00 CEST