ODBC datasource / dataset problem

Hi,
I'm using the Visual Studio designer to create my RS reports. When I
add a new project to the solution, the new project wizard allows me to
choose ODBC as the datasource type I want to use. However, I amn't
given the ODBC option when I try to add a datasource to an existing
project. I work around this by copying and manually editing the ODBC
.rds file that was created by the new project wizard. Does anyone know
"the right way" to add an ODBC datasource to a project without using
the project wizard? I'm a bit concerned about my workaround because I
now have multiple .rds files in the same project with the same
<DataSourceID>.
Also, I don't know if this problem is caused by my workaround, but when
I use the "hacked" .rds file as a report's datasource and open the
"Data" tab I see the message:
"The query could not be loaded. Verify your connection string and query
string"
The report still runs fine, and if I open the "Generic Query Designer"
(in the "Data" tab), the query appears, and returns results if I click
the "!" button.
Thanks in advance,
DonRight click on shared data sources, add new data source. When the data link
properties box comes up it is on the connection tab, click on the Provider
tab where you can now pick ODBC.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Don" <donalmurtagh@.yahoo.co.uk> wrote in message
news:1127296726.880744.15570@.g44g2000cwa.googlegroups.com...
> Hi,
> I'm using the Visual Studio designer to create my RS reports. When I
> add a new project to the solution, the new project wizard allows me to
> choose ODBC as the datasource type I want to use. However, I amn't
> given the ODBC option when I try to add a datasource to an existing
> project. I work around this by copying and manually editing the ODBC
> .rds file that was created by the new project wizard. Does anyone know
> "the right way" to add an ODBC datasource to a project without using
> the project wizard? I'm a bit concerned about my workaround because I
> now have multiple .rds files in the same project with the same
> <DataSourceID>.
>
> Also, I don't know if this problem is caused by my workaround, but when
> I use the "hacked" .rds file as a report's datasource and open the
> "Data" tab I see the message:
> "The query could not be loaded. Verify your connection string and query
> string"
> The report still runs fine, and if I open the "Generic Query Designer"
> (in the "Data" tab), the query appears, and returns results if I click
> the "!" button.
>
> Thanks in advance,
> Don
>

ocx error

when im trying to open some project im getting the error-
CRYSTL32.OXC could not be loaded
i already installed the ocx, so whats the problem?
what to do?
thanks in advancedanyone?|||anyone?:wave: :wave:
Do a search on your system for "CRYSTL32.OCA" and delete all the files you get.
Register the crystl32.ocx again and then try re-opening your project.:thumb:

hope this helps..

PS: In the mean time you could also check the knowledge base for Crytal reports here
support.businessobjects.com|||there is no "CRYSTL32.OCA" on my computer
and i checked the link...
what else can it be?
thanks|||"CRYSTL32.OCX" is for Crystal Reports, right? It's not something you created?

I had a similar problem with controls *I* created a while ago. Was using two seperate projects, one for custom user control and one for program. Would get same err whenever I made changes to usercontrol and recompiled.

Solution was to use vbg and group my controls and program together, to keep 'em in synch.

This is *probably* not your situation, but perhaps someone with a problem like I had will come across this. :)|||yes, its not something i created..so thats not the problem|||Did you used REGSVR32.EXE, I don't know if you need to use it for Crystal Report, but usually, you need to register OCX you want to use in VB.

JeffB|||where is REGSVR32.EXE ? im a little bit new in this...

i just instaled the vb6 and crystl32.inf
what else i need to do?
thanks.|||This is some infos on REGSRV32:

http://support.microsoft.com/kb/q267279/

I'm moving this to CR forum ;)

JeffB|||its working now
thanks for the help|||I have some problems with Crystal Report program.

In my project I use VB 6.0 with SP6 and Crystal Report 10.0
The operating system is: Windows XP SP2

When I open the project, the system gives me this error message:
(Error during load: the Crystl32.ocx file could not be loaded)

Also I can not export my project as .exe because of the above problem.


I tried to replace the file of Crystl32.ocx with new versions but the problem is still being.

Also I tried to register the Crystl32.ocx file by using this command:
(Regxvr32 D:\Windows\System\crystl32.ocx /u) but this command does not work and the problem is still being.

please help me.

Thanks;|||>>Regxvr32 D:\Windows\System\crystl32.ocx /u) but this command does not work and the problem is still being.

What is the error you are getting?
If possible reinstall CR
or check out here
http://support.businessobjects.com/