I am trying to connect my reports with VB6 using SETLOGONINFO function. The reports are originally using File DSN ODBC connection to a bunch of text files . Here is my line of code:
m_objCRReport.Database.Tables(1).SetLogOnInfo "", "", "", ""
I did not specify any server name, because the reports look at the same ODBC. so, I don't need to change the server during runtime. Basically, I want my viewer open the reports and being able to refresh, nothing complicated.
When I use this line of code, I get an "Logon Failed. Details: HY000: General Error: Invalid File dsn "DSN name"
Then when i change the code to m_objCRReport.Database.Tables(1).SetLogOnInfo "Location and name of File DSN.dsn", "", "", ""
Then I do get blank reports. Static stuff is in the report (such as logos, text files etc) but the data is blank.
The ODBC File DSN sits in the server.
The text files that File DSN looks sit on the server.
I am told that I have administrative privileges, so I don't think network connection is a problem.
The computer has crystal, can't be DLL issue.
Crystal is version 8.5
What is my problem? Please help .