SangeethaEdward
Programmer
We are using Crystal 9.0 as a reportinf tool for project in VB with ORACLE. I want to use FILEDSN, for calling the report from VB.
This is the code I am using to call the report.
CRXReport.Database.Tables(1)
.ConnectionProperties.Add "FILEDSN",
App.Path & "\MYDSN.DSN"
This works fine, when the database and server is same as the one I have used while making the report. If I change the database to other ( this is a identical database in the dev env) it giving these Errors:
"Error in Building the Query"
Logon Failed.
Details: (01000) The driver does not support the verson of ODBC behaviour that the application requested. (See SQLSetEnvAttr).
How to solve this problem.
Any help please! Urgent!
This is the code I am using to call the report.
CRXReport.Database.Tables(1)
.ConnectionProperties.Add "FILEDSN",
App.Path & "\MYDSN.DSN"
This works fine, when the database and server is same as the one I have used while making the report. If I change the database to other ( this is a identical database in the dev env) it giving these Errors:
"Error in Building the Query"
Logon Failed.
Details: (01000) The driver does not support the verson of ODBC behaviour that the application requested. (See SQLSetEnvAttr).
How to solve this problem.
Any help please! Urgent!