This website uses cookies. By clicking Accept, you consent to the use of cookies. Click Here to learn more about how we use cookies.
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
- Revenera Community
- :
- InstallShield
- :
- InstallShield Forum
- :
- SQL connection error
Subscribe
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎May 05, 2011
04:12 PM
SQL connection error
I have a Basic MSI project and I'm trying to run a SQL script on an Oracle database. I get an error when the SQL script is supposed to run, saying the "user does not exist". I'm not sure if I'm setting the Server field correctly.
Oracle is on the localhost and the name of the database is ldb. If I enter ldb into both the Server and Database fields, along with the user/password, the dialog seems to validate the connection. But then i get that "user does not exist error" when the SQL script tries to run during the execution.
What is the IS_SQLSERVER_SERVER property that corresponds to the Server field supposed to be? Should it be localhost? Or is the name of the database, like it validated, fine?
Oracle is on the localhost and the name of the database is ldb. If I enter ldb into both the Server and Database fields, along with the user/password, the dialog seems to validate the connection. But then i get that "user does not exist error" when the SQL script tries to run during the execution.
What is the IS_SQLSERVER_SERVER property that corresponds to the Server field supposed to be? Should it be localhost? Or is the name of the database, like it validated, fine?
(2) Replies
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎May 09, 2011
09:32 AM
bump. any ideas anyone?
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎May 11, 2011
10:21 AM
Also, is there a way to pass an argument to the SQL script being passed in?