Experts … I really need your help!
I have a VB .net 2005 windows app. It has been working on Windows XP (32-bit) environment for a while with no issues and now we are moving to Windows 7 (64-bit). The program runs fine except for the reports which was written using built in crystal report came with VB .net 2005. I get an ERROR Database Login and it asks for Login ID and password. The database is MS access 2002 SP3 and the compiler is set to target X86. Below is a screen print of the error message and the code used to connect to data base and also the code behind the form that calls the report
HELP PLEASE !!!!

I am using the following connection string:

DBconn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & str_data & ";Persist Security Info=true;user ID=Admin;Jet OLEDB:Database Password= mypassword"



And on the REPORT form I have the following code


Private Sub frmExportDiv_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load

        Dim crReportDocument As CrySelectedDivisionSummary
        crReportDocument = New CrySelectedDivisionSummary
        Dim ss As String = Application.StartupPath()
        Dim logOnInfo As New CrystalDecisions.Shared.TableLogOnInfo
        logOnInfo.ConnectionInfo.ServerName = ss & "\\Firm_data.mdb"
        logOnInfo.ConnectionInfo.Password = "mypassword"
        logOnInfo.ConnectionInfo.UserID = "Admin"
       crReportDocument.Database.Tables("qryExportDiv").ApplyLogOnInfo(logOnInfo)
        cryprintandexport.ReportSource = crReportDocument
End Sub

Hi Hilfy,
Thank you so much for your input.
I do have a 32-bit version of the software.
When creating the crystal reports I create using Access/Excel (DAO). It asks me for the database name and
the password. See attached.

To connect to the data I used the connection string I listed above.

How can I “you MUST set up a 32-bit ODBC connection using the 32-bit ODBC Administrator. “??



Edited by vbmaayah - 10 Nov 2014 at 9:42am

If you go to your Start menu and navigate to where the link for Crystal is on that server, you should see in the same folder "32-bit ODBC Data Source Administrator". Or you can just run C:\Windows\SysWOW64\odbcad32.exe.

-Dell

The "regular" ODBC Data Source Administrator on the Administrative Tools menu is 64-bit. You MUST run the 32-bit version of the tool. I explained in my last post where to find it.

You'll create a new "System" DSN, select the correct Access driver, and follow the prompts in the rest of the wizard. You'll then need to use this connection in your report.

-Dell

Edited by hilfy - 11 Nov 2014 at 4:01am

You may need to download and install the MS Access driver.

-Dell