Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Invalid query on drive information
Message
 
À
04/07/2011 09:31:50
Information générale
Forum:
ASP.NET
Catégorie:
Code, syntaxe and commandes
Versions des environnements
Environment:
VB 9.0
OS:
Windows 7
Network:
Windows 2003 Server
Database:
MS SQL Server
Application:
Web
Divers
Thread ID:
01517251
Message ID:
01517252
Vues:
50
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.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform