SMS database

[Christopher]

Hi all,

Is it possible to get records from an SMS VIEW??
Reaching an SMS table is no problem but a view says:

Error # = -2147217900
Description = [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'vdisk'.
Source = Microsoft OLE DB Provider for ODBC Drivers
SQL State = S0002
NativeError = 208

Thx in advance.

Christopher

[John]

Hi Christopher,

We haven't had any experience using the SMS VIEWs. Can pureasp.asp read it?

JC



On 2/10/99 11:21:35 AM, Christopher wrote:
> Hi all,

Is it possible to get records from an SMS VIEW??
Reaching an
> SMS table is no problem but a view says:

Error # =
> -2147217900
Description = [Microsoft][ODBC SQL Server Driver][SQL
> Server]Invalid object name 'vdisk'.
Source = Microsoft OLE DB
> Provider for ODBC Drivers
SQL State = S0002
NativeError = 208

Thx in
> advance.

Christopher

[Christopher]

Hi John,

I found the prob. Apparently the views can be read but it's CASE sensitive....
*bop*



On 2/10/99 11:16:48 PM, John wrote:
> Hi Christopher,

We haven't had any experience using the SMS VIEWs.
> Can pureasp.asp read it?

JC



On 2/10/99 11:21:35 AM, Christopher
> wrote:
> Hi all,

Is it possible to get records from an SMS VIEW??
>
Reaching an
> SMS table is no problem but a view says:

Error # =
>
> -2147217900
Description = [Microsoft][ODBC SQL Server Driver][SQL
>
> Server]Invalid object name 'vdisk'.
Source = Microsoft OLE DB
>
> Provider for ODBC Drivers
SQL State = S0002
NativeError = 208

Thx in
>
> advance.

Christopher