| :: Can't make any reports :: (10) | Post a New Message | Post a Reply |
 Can't make any reports | Post a Reply |
from: Eindhoven Netherlands
I installed de prog. It lookes perfect! We'll consider to buy this one
I have 2 problems;
1. The report wizard seems to work but after pressing finish I got a blank (grey) screen; the proposed report does not appear in the list (Still haven't got a list). What do I do wrong? This one I solved!
2. I tried a several connectionstrings for oracle 8i. They'll all working but I can't see the views I made within de DB.
Can anyone help me?
tnx Jeroen
 Re: Can't make any reports | Post a Reply |
from: Laurel, MD
Oracle connection string samples and let me know if any works.
-------------------------
Master of the Game
| Re: Can't make any reports | Post a Reply |
from: Eindhoven Netherlands
I tried de strings you proposed. They'll work but i 'still can't see the views I made within oracle. Besides I got a message under reports:
if(confirm('Are you sure you want to delete this report?')){window.location='?a=d&id='}x
Do you know what this means?
tnx
 Re: Can't make any reports | Post a Reply |
from: Laurel, MD
Try it out and let me know if it lists the views.
-------------------------
Master of the Game
 Re: Can't make any reports | Post a Reply |
from: Ottawa, Canada
 Re: Can't make any reports | Post a Reply |
from: Washington, DC
ODBC Driver for Oracle - from Microsoft
For the current Oracle ODBC Driver from Microsoft
strConn = "Driver={Microsoft ODBC for Oracle};" & _
"Server=OracleServer.world;" & _
"Uid=myUsername;" & _
"Pwd=myPassword"
For the older Oracle ODBC Driver from Microsoft
strConn = "Driver={Microsoft ODBC Driver for Oracle};" & _
"ConnectString=OracleServer.world;" & _
"Uid=myUsername;" & _
"Pwd=myPassword"
For more information, see:
- Connection String Format and Attributes
- Latest Microsoft KB articles related to Microsoft ODBC for Oracle
ODBC Driver for Oracle - from Oracle
strConn = "Driver={Oracle ODBC Driver};" & _
"Dbq=myDBName;" & _
"Uid=myUsername;" & _
"Pwd=myPassword"
Note: The DBQ name must be defined in the tnsnames.ora file
For more information, see:
- Oracle8 ODBC Driver Help
- Oracle ODBC FAQs
-------------------------
Ghost
| Re: Can't make any reports | Post a Reply |
from: Ottawa, Canada
Access is denied" error
| Re: Can't make any reports | Post a Reply |
from: Washington, DC
1. Make sure that the folder in which your sample asp page is located has read/write permissions.
2. Also make sure that this folder is not Read-Only
The report wizard uses the file
Reason:
The report wizard uses an xml file -reports.xml to save your generated reports - by default this file is always created by the report wizard in the folder in which it resides.
In order to save reports, the report wizard has to be able to write to this xml file. A sample of the file is located at the link below. If this problem persists, just do the following:
1. Create a blank text file
2. Rename it reports.xml
3. Copy the following code into it:
<report_wizard version="2">
<groups>
<group id="" title =" General Reports " />
</groups>
<reports />
</report_wizard>
<groups>
<group id="" title =" General Reports " />
</groups>
<reports />
</report_wizard>
4. Save the file in the same folder location as your ASP file.
5. Run your asp file.
Let me know if this helps.
-------------------------
Ghost
| Re: Can't make any reports | Post a Reply |
from: Ottawa, Canada
| Re: Can't make any reports | Post a Reply |
from: Ottawa, Canada
Still can't see fields in the report creation box. I would really like to buy this if I can get it working.