Strange activity CRBasic VS 2008 x64 on Win2008 x64

[Former Member]

Hi All,

First, I apologize for my English:)

I have a strange problem with CR VB2008 x64 runtime on W2008R2 x64. Problem is similiar to others on this forums, but I didn't find the solution.

Background:

On W2008 x64 I installed asp.net applicationmssqlserver2008 x64 CRx64. Version CR is Basic 10.5. Installation process of CR runtime was sucessfull. Application was compile in mode "AnyCPU".

Asp application and SQLServer cooperate correcty as long as CR is called. But when I want to create report, Crystal show unexpectedly note:

"The report you request requires further information" and shows text boxes:

- server name: localhost

- database: empty field

- username: sa

- passwd: empty field

Strange this is that:

a) the fields appear

b) fields: server name, database, user are 'read only'. Is not possible write text into this fields.

b) in 32bits environment on win2008x32 (app+ sqlserver x32+ CR x86) the same application works perfectly and stable.

I know, that CR VB2008 x64 works native in 64 bits. Because has not the need of the installation CR x32 and set 32 bits mode on IIS.

Advise me please, what I do wrong.

Best regards

Wojciech

[former_member11696 · Accepted solution]

Hi Wojciech,

The problem is the database client is not set up correctly. If you are using ODBC then create your System DSN in the 64 bit ODBC Administrator. If you are using the OLE DB Provider then you need the 64 bit client installed also.

Also, the VB2008 itself only runs in 32 bit mode. So when you are debugging the IDE is 32 bit. Only way to truely run in 64 bit mode it to compile the app and run it from the release directory. Or in the case of a WEB app make sure the App Pool is set to run in 64 bit mode.

Don

[Former Member · Accepted solution]

Don,

Thank you for answer.

I'm not SQLServer programmer. I have (maybe stupid) question: how I can set the SQL Client to configure 64bit ODBC and OLE DB connection? And how to call this connection from appplication?

I use OLE DB (ADO) in my application.

Maybe install MsSQLServer 2008 32 bits? (we use Express version, so is practically no difference- x86 or x64)

regards

Wojciech

[former_member11696 · Accepted solution]

Hi Wojciech,

No problem. Never a stupid question if you don't know the answer...

Search MSDN ( microsoft.com ) for the client or how to install the 64 bit version for SQL Express. For higher versions of SQL Server the installer has an option to install the Client Tools. Not sure about SQL Express if it include a Tools option.

Bottom line is if you run in 64 bit mode the DB client either has to support 64 to 32 bit or it must have a 64 bit version.

Go into Control Panel, Admin Console and you should see a 64 bit ODBC Administrator. If you can create a System DSN using the MS SQL Native 10 Client then you have it installed. If you don't see it then check with MS on how to, MS doesn't support any other driver for SQL 2008.

Don

[Former Member · Accepted solution]

Don,

I installed MsSQLServer x86, compile Application to x86, installed CRBasicVS2008x86.

No progress. All time CR asked me about base, user, server and passwd.

All time I have message "The report you request requires further information".

My raports use OLE DB (ADO) technology to connect with SQLServer. Maybe here is any problem.

I have no idea.

Regards

Wojciech

[former_member11696 · Accepted solution]

Hello,

Try using ODBC System DSN with the Native 10 driver to see if that will work for you.

Don

[Former Member · Accepted solution]

Hi Don,

I made so as you advised to me. It works. Thx.

Regards

Wojciech