cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
anom217
Level 8

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?
Labels (1)
0 Kudos
(2) Replies
anom217
Level 8

bump. any ideas anyone?
0 Kudos
anom217
Level 8

Also, is there a way to pass an argument to the SQL script being passed in?
0 Kudos