calkinsc
01-06-2006, 02:47 PM
I'm probably missing something simple, but I'm having a problem connecting to Oracle 10g with an installer built with IS Pro 11.0 or 11.5.
I've created a database connection to Oracle (I've done it before with SQL Server successfully, so I know the overall process is sound) with scripts to execute. When I run the installer, it prompts for a server name from the Database Server dialog, as expected.
According to the online help under SQL Connection, an Oracle server server name has the form "//host: [port] [/service name]". Using "//localhost:" gives the message "There was an error logging in to Oracle. Error: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified".
If I use ORCL as the server name (as I do in the source code of the project I'm installing), and try to log in as system/oracle (as works in the code, and with clients such as Toad), I get the message: "There was an error logging in to Oracle. Error: [Microsoft][ODBC driver for Oracle][Oracle]ORA-01017: Invalid username/password; logon denied (1017)" so it found the server, but couldn't use it.
Changing the connect information to the OraOLEDB.Oracle provider as per this thread:
http://community.installshield.com/showthread.php?t=153983&page=1&pp=5
matches how the source code actually works (it uses the Oracle OLEDB provider, not ODBC), so it seems that that should be fine, but when I try to log in with it I get the message: "OraOLEDBpus10.dll: The specified module could not be found" which is strange, as that DLL is in the same directory as all of the other Oracle client DLLs: C:\oracle\product\10.2.0\db_1\BIN
Again, that provider works with the application code, so the provider is installed and operating correctly, but through InstallShield it doesn't seem to be able to find all of the relevant pieces.
What is the proper method for connecting to Oracle through InstallShield Pro 11.5? It can't be as hard as it seems to be.
Thanks!
I've created a database connection to Oracle (I've done it before with SQL Server successfully, so I know the overall process is sound) with scripts to execute. When I run the installer, it prompts for a server name from the Database Server dialog, as expected.
According to the online help under SQL Connection, an Oracle server server name has the form "//host: [port] [/service name]". Using "//localhost:" gives the message "There was an error logging in to Oracle. Error: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified".
If I use ORCL as the server name (as I do in the source code of the project I'm installing), and try to log in as system/oracle (as works in the code, and with clients such as Toad), I get the message: "There was an error logging in to Oracle. Error: [Microsoft][ODBC driver for Oracle][Oracle]ORA-01017: Invalid username/password; logon denied (1017)" so it found the server, but couldn't use it.
Changing the connect information to the OraOLEDB.Oracle provider as per this thread:
http://community.installshield.com/showthread.php?t=153983&page=1&pp=5
matches how the source code actually works (it uses the Oracle OLEDB provider, not ODBC), so it seems that that should be fine, but when I try to log in with it I get the message: "OraOLEDBpus10.dll: The specified module could not be found" which is strange, as that DLL is in the same directory as all of the other Oracle client DLLs: C:\oracle\product\10.2.0\db_1\BIN
Again, that provider works with the application code, so the provider is installed and operating correctly, but through InstallShield it doesn't seem to be able to find all of the relevant pieces.
What is the proper method for connecting to Oracle through InstallShield Pro 11.5? It can't be as hard as it seems to be.
Thanks!