What Is the Command Line Arguments to Compile an Sqr Report Using Postgresql?
I Am Trying to Compile an Sqr Report Using Postgresql. Here Is My Command Line for Oracle: C: \Hyperion\Sqr\Bin\Sqr\Server\Oracle\Bin\Sqr. Exe Logasrun. Sqr...
I am trying to compile an SQR report using PostgreSQL. Here is my command line for Oracle:
C:\hyperion\SQR\bin\SQR\Server\Oracle\bin\sqr.exe LogAsRun.sqr ads/ads@gabdbg -RS -M sqrsize.dat
What would be the connectivity argument for PostgreSQL? I need to replace the ads/ads@gabdbg argument with one that will connect to PostgreSQL.
1 Answer
I found a solution. When installing SQR there is an option to install for different databases. While they don't have PostgreSQL they do have ODBC. So I installed SQR for ODBC.
I then had to go to the PostgreSQL site to download the ODBC drivers:
I downloaded the MSI for 32-bit PostgreSQL. SQR will not use 64-bit. Here is the zip file I downloaded: "psqlodbc_11_01_0000-x86.zip".
I then setup a system ODBC DSN called "SCRIBE_POSTGRESQL". My command line now looks like this:
C:\hyperion\SQR\bin\SQR\Server\ODBC\bin\sqr.exe LogAsRun.sqr SCRIBE_POSTGRESQL -RS -M sqrsize.dat
Note the source of the sqr.exe comes from the ODBC folder. Also the connection parameter is the name of the ODBC DSN "SCRIBE_POSTGRESQL". Everything else stays the same.
Also you can specify the user name and password for the ODBC dsn in the SQR command line: So an alternative command line would be:
C:\hyperion\SQR\bin\SQR\Server\ODBC\bin\sqr.exe LogAsRun.sqr SCRIBE_POSTGRESQL/[username]/[password] -RS -M sqrsize.dat
Robert Thorne covers electric vehicle innovations, autonomous driving systems, global mobility trends, and automotive engineering developments.
