|
ShaggyDogg
Starting Member
3 Posts |
 Posted - 06/11/2012 : 11:53:47
|
Does anyone else use SQL MS08 to connect to and query Spiceworks?
I'm extending a website built in ASP.NET to display Spiceworks reports - basic SQL queries. The easist way (with my knowledge) is to use Management Studio and Visual Studio. I have therefore followed this 'how to' (http://community.spiceworks.com/how_to/show/2271), plus a few others, to create the ODBC SQLite3 driver, and set it all up in both applications.
Though the connection test is successful in both, and the open connection appears in the database explorer views, I cannot see any tables within.
In Visual Studio 2010 there is an open connection to the db, but all I can see is the connection name and under it the empty containers; Tables, Views; Procedures.
In Server Management Studio 2008, under the open Spicework connection I get; Catalogs > System Catalogs (empty)
If it's any use, the connection string is:
Dsn=Spiceworks;database=\\MyServer\db\spiceworks_prod.db;stepapi=0;notxn=0;shortnames=0;longnames=0;nocreat=0;nowchar=0;fksupport=0;oemcp=0
I've also tested the connection through MS Excel > Get External Data >... and, again the connection works (with the expected warning "This data source contains no visible table"), but continuing with the instruction of clicking OK & checkboxing only 'tables' - the wizard still shows NO tables.
And before anyone asks; yes, I have posted on the Spiceworks forum but nobody has replied, and the Spiceworks installation is definitely fine and happily operational ;-)
I'm eager for some experienced advice on this, I can't believe this isn't possible.
Any suggestions welcome.
Thanks |
Edited by - ShaggyDogg on 06/11/2012 11:55:03
|
|
|
robvolk
Most Valuable Yak
USA
15559 Posts |
Posted - 06/11/2012 : 12:14:30
|
| It's more likely that SQLite (or the Spiceworks interface) doesn't provide browseable metadata, i.e. tables, views, etc. You'll have to write SQL queries manually and know the table names ahead of time. |
 |
|
SQL Server management Studio & Spiceworks
