SQL Native Client - adding "Driver={SQL Native Client}; fails

[joegasper]

Will the web portion of Lansweeper handle using the SQL Native Client driver (SQL 2005) for the database connection? The main Lansweeper page will display but only the top "toolbars", no links to the various dashboard queries.

[joegasper]

I get "Keywork not supported: 'driver'".

Based on some more reading. No reason to use the native client:

http://www.connectionstrings.com/article.aspx?article=whentousesqlnativeclient

[joegasper]

Never mind on the ajax issue. Figured that out. (older web.config, not the one with the ajax toolkit registration.

But still not able to find a way to get an error output when trying the SQL Native Client.

[Hemoco]

inside the aspx page you will also have a debug entry

<MM:DataSet
runat="Server"
...
Debug="false">
</MM:DataSet>

Change this to true in the it-reports.aspx page

[joegasper]

For debug=true or for trace enabled=true, I don't get any compilation output. Looking at the source of the page, it just stops in the middle of building an html table. Without any debug/trace statements and without trying to use the native sql client, I get 3 javascript errors.


Type is no defined on line:
Type.registerNamespace('AjaxControlToolkit');
(this looks to cause the following 2 errors)

Sys is not defined:
Sys.WebForms.PageRequestManager._initialize('ScriptManager1', document.getElementById('formc'));

Sys is not defined:
Sys.Application.initialize();

[Hemoco]

In the web.config file you can set the switch debug="false" to debug="true" to get the exact error in the website