Problems migrating from VS2008 to VS2010

[Former Member]

I have an application developed with VS2008 that works perfectly.with many CR's. It uses an ADODB connection to an Access database. I tried a conversion to VS2010, but it does not work as any time I try to display a report the followinf dialog appears and there is no way to connect to the database.

Can anyone help me to solve the problem? I looked around in the web, but non of the proposed solutions seems to apply.

[former_member183750 · Accepted solution]

What version of Access? Note that accdb files are only supported via ODBC.

- Ludek

Senior Support Engineer AGS Primary Support, Global Support Center Canada

Follow us on Twitter

Got Enhancement ideas? Try the SAP Idea Place

Share Your Knowledge in SCN Topic Spaces

[Former Member · Accepted solution]

Hi Ludek.

It is an old mdb database. To tell you the whole story, the original application has been developed using VB6 and has been migrated at first to VS2005 and then to VS2008.

In all steps the application work properly, problems arose when I tried to make the last step from VS2008 to VS2010. By the way, the connection is made via ADODB.

Giorgio

[former_member183750 · Accepted solution]

What provider are you using?

Are you able to connect to the database using a UDL?

As a test, if you remove the security from the MDB, does the report run?

- Ludek

[Former Member · Accepted solution]

I tried to move from ADODB to OLEDB with no result. I mean, if make connectionsa to database from code, I can read and modify data and table structures, but when I try to connect i Crystal Report to a databse table, I still have the problem of the login dialog. What is very strange is that I have another application that works properly and the code appears to be IDENTICAL!

[former_member183750 · Accepted solution]

Umm, see my post on Mat 13:

 Note that accdb files are only supported via ODBC.

Not sure why then you converted to OLEDB?

Also, I don't see answers to my questions from May 14(?).

- Ludek

[Former Member · Accepted solution]

The connection string that I use is:

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\ISF\PROGETTI\SOMALILAND\AIMS - VS2008 OLEDB\AIMS\AIMS HARGEISA 09022013 LAST 2012.mdb ;Persist Security Info=True; Mode=Share Deny None; Jet OLEDB:Database Password=Jadilnoi!23

It works with DatSet's and relevant Tables. It works in a different application with the same code but differewnt reports.

By the way there is no security yet in the database that is an old Access 2003 mdb fiile and I can connect with UDL.

- Giorgio

[former_member183750 · Accepted solution]

Something I don't understand; If there is no security yet in the database, why are you using:

Jet OLEDB:Database Password=Jadilnoi!23

- Ludek

[Former Member · Accepted solution]

This is because I inherited the software from the original developer and I'm keeping what seems to work as it is. In details:

I got two different applications:

• One named BIMS, developed using VB of VS2008, OLEDB and Crystal Reports. This work properly.
• The second is named AIMS and was originalli developed using ADODB, VB6 and Crystal Reports. This second I'm trying to upgrade to VS2008 and I moved to OLEDB in order to use exactly the same procedures and the same Report Viewer form that work properly in BIMS.

I am astonished by the fact that two identical softwares behave differently.

One final note: I'm using a PC with Windows 7 64, but I configured the development environment to target only X86 CPU and Framework 2.0

- Giorgio

[former_member183750 · Accepted solution]

Hello Giorgio

I'd have to see the report and the database to help out from here on. Unfortunately, I just don;t have the bandwidth to do it now. Given that phone cases get higher priority, I'd recommend creating a phone case here:

http://store.businessobjects.com/store/bobjamer/en_US/pd/productID.98078100

- Ludek

[former_member198639 · Accepted solution]

is CR for VS2012 free??? Or sth else?Thanks.

[former_member198639 · Accepted solution]

Where can I get SDK Doc?Thanks

[former_member183750 · Accepted solution]

Why are you tagging on to a thread that has nothing to do with what you are looking for? Please create a new Discussion.

- Ludek

Senior Support Engineer AGS Product Support, Global Support Center Canada

Follow us on Twitter

Got Enhancement ideas? Try the SAP Idea Place

Share Your Knowledge in SCN Topic Spaces

[Former Member · Accepted solution]

Hi Ludek,

thanks for your help up to now.

I finally workedt it out and I let you know what was the problem so maybe you can help someone else in a fast way.

The problem was due to VS 2008: in reading a string from a text file, VB (I don't know why) appends a carriage return at the end of the string. When modifying the connection info of the database tables of the report, this extra character causes Crystal Report to ask for login info.

I think that the bahaviour should be different and rise an error, but in any case I'm out of it.

Thanks again and regards

-Giorgio

[former_member183750 · Accepted solution]

Hello Giorgio

Many thanks for sharing the solution.

- Ludek