But this simply doesn’t work as advertised. I have a user defined as IDENTIFIED EXTERNALLY but with the following trimmed down SQL.INI
Code: Select all
[win32client.dll]
comdll=sqlora32
[win32client.ora32]
log=c:\temp\sql.log
[oragtwy]
remotedbname=database_name,@tns:database_name (BOTH FAIL)
remotedbname=database_name2,@database_name2 (BOTH FAIL)
longbuffer=3021996
substitute=SYSSQL.,
fetchrow=200
[win32client]
clientname=Win32User

Code: Select all
!!CB!! 134
Function: g_Test
Description:
Returns
Parameters
Static Variables
Local variables
Sql Handle: hSqlConnection
Actions
Set SqlDatabase = 'database_name'
Set SqlUser = 'dummy'
Set SqlPassword = ''
!
Call SqlConnect( hSqlConnection )
If I use the same code with a credentialed oracle user, i.e. proper username and password this code works perfectly.
EVERY OTHER SINGLE PIECE OF SOFTWARE ON MY PC WORKS AS EXPECTED FROM SQLPLUS TO EXCEL