Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Invalid query on drive information
Message
 
To
04/07/2011 09:31:50
General information
Forum:
ASP.NET
Category:
Coding, syntax and commands
Environment versions
Environment:
VB 9.0
OS:
Windows 7
Network:
Windows 2003 Server
Database:
MS SQL Server
Application:
Web
Miscellaneous
Thread ID:
01517251
Message ID:
01517252
Views:
49
This message has been marked as the solution to the initial question of the thread.
>I use this query to get some information on a drive:
>
>
>SELECT FreeSpace,QuotasDisabled,VolumeName,VolumeSerialNumber
> FROM Win32_LogicalDisk WHERE ProviderName="\\10.20.1.10\Data"
>
>
>I obtain: "Invalid query".
>
>This IP is valid. Basically, it is the IP of the server I am running the program on. Data is the share drive name. I always used this formula. What am I missing?

Maybe you should escape "\"?
ProviderName="\\\\10.20.1.10\\Data"
(not sure though :-))
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform