sqr reports
Forum » Forum / Help » sqr reports
Started by: shyam (guest)
On: 1256055570|%e %b %Y, %H:%M %Z|agohover
Number of posts: 2
rss icon RSS: New posts
Summary:
sqr reports
Unfold All | Fold All | +More options
Fold
sqr reports
shyam (guest) 1256055570|%e %b %Y, %H:%M %Z|agohover

Using SQRW tool I can run sqr reports when database is Oracle and HRMS,but when I want to run the sqr report using Finance and SQL Server I am getting error.

Showing error in Command prompt as

Oracle OCIServerAttach error
Cannot logon to the database.

When running Microsoft SQL Server as databse.why i am getting Oracle error.

IN SQRW i gave
Username = sa
Password = sa
Database = FSCM89

Username and Password are same as of Microsoft SQL Server database.

I think there may be settings to change my database from Oracle to Sql server.Can any one help me in resolving this issue.

Reply  |  Options
Unfold sqr reports by shyam (guest), 1256055570|%e %b %Y, %H:%M %Z|agohover
Fold
Re: sqr reports
PrajPraj 1256249218|%e %b %Y, %H:%M %Z|agohover

Hi, what's the full path to the SQRW application you are using?

There are two different SQR binary paths, one with ORA for Oracle and one with MSS for Microsoft SQL Server.
The path to the SQRW tool is something like this: %PS_HOME%\bin\sqr\ORA\BINW or %PS_HOME%\bin\sqr\MSS\BINW.

Not sure if this makes a difference ?

Reply  |  Options
Unfold Re: sqr reports by PrajPraj, 1256249218|%e %b %Y, %H:%M %Z|agohover
New Post
Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License