Data Source Expressions

Hi,

Is there anyone out there who has succesfully used Data Source Expressions? I've tried the way MS describes inhttp://msdn2.microsoft.com/en-us/library/ms156450.aspx.
I even tried using no parameters at all, so my datasource was: ="Data Source=VOYAGER;Initial Catalog=MaxCC". When I remove the =" and the last " everything works fine (since it isn't an expression anymore but just a connectionstring).
With any expression I keep getting the error:

rsUnexpectedCompilerError] An unexpected error occurred while compiling expressions. Native compiler return value: ‘[BC32017] Comma, ')', or a valid expression continuation expected.’.

Thanx in advance!

Ferry

Ok, found it. It works perfectly, but I named the datasource "Test DS". The space in the name of the datasource is the killer. Changing the name to "Test_DS" did the trick!sql

Data recovery service!

I've been asked to find a data recovery service who can help restore a sql
server database that has become corrupt or is on a hard drive that has
become non-functional. Does anyone have suggestions of a company who
specializes in this sort of work?
Since most drives (disk arrays) are multiple spindles in a RAID configuration
could you be a bit more specific? Do you mean, for example, an internal set
of drives?
--DatabaseAdmins.com
Remote DBA Services
"Beth In Alaska" wrote:

> I've been asked to find a data recovery service who can help restore a sql
> server database that has become corrupt or is on a hard drive that has
> become non-functional. Does anyone have suggestions of a company who
> specializes in this sort of work?
>
>
|||Hello,
If you hard drive is totally unusable, only option is restore from a good
backup and restore transaction log backups.
Take a look into various hugh availability options using:-
1. Replication
2. Logshipping
3. Database mirroring
or
Clustering
Thanks
Hari
"Beth In Alaska" <bethinak@.spamfreeclearwire.net> wrote in message
news:12up0hbf4hgf94b@.corp.supernews.com...
> I've been asked to find a data recovery service who can help restore a sql
> server database that has become corrupt or is on a hard drive that has
> become non-functional. Does anyone have suggestions of a company who
> specializes in this sort of work?
>
|||"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:%23MgK8%235XHHA.2640@.TK2MSFTNGP06.phx.gbl...
> Hello,
> If you hard drive is totally unusable, only option is restore from a good
> backup and restore transaction log backups.
>
In the meantime, see what a company like Ontrack.com can do.
And there's one or two software packages that claim to be able to help
recover data from a corrupt db.
Take a look at those.

> Take a look into various hugh availability options using:-
> 1. Replication
> 2. Logshipping
> 3. Database mirroring
> or
> Clustering
> Thanks
> Hari
> "Beth In Alaska" <bethinak@.spamfreeclearwire.net> wrote in message
> news:12up0hbf4hgf94b@.corp.supernews.com...
>
Greg Moore
SQL Server DBA Consulting
sql (at) greenms.com http://www.greenms.com