DBLint for SQL Server database

May 12, 2012 at 4:29 AM

The DBLINT is an excellent tool for analysis but as of now I tried it does not support the SQL Server database.

How can I use it with SQL Server databases?

Please advice.

Coordinator
May 17, 2012 at 3:13 PM

Hi,

It should support SQL Server. For now we have only tested it on SQL Server 2008, and on databases where identifier names are not case sensitive.

The types of connections that have been tested are; windows authorization, remote connections and named connections, so if you connect in another way it might be the problem. Otherwise can you tell what error you get, if you get any?

Jun 1, 2012 at 5:56 PM
Edited Jun 1, 2012 at 5:59 PM

Hello,

I downloaded your tool to a Win7, 64-bit computer that has SQL Server 2008 Express R2 on it.  I launched dblintgui.exe as an administrator, and tried to create a connection to our database, but it fails with "Unknown error, or timeout: An unknown error occurred when trying to connect to the database."  The settings for this connection are the following:

Database System: MS SQL

Authentication Method: Windows Authentication

Host: localhost or 192.168.1.44 (both failed)

Port: 1433

Max connections: 4

Database: TestDB

I can successfully access this database using Windows Authentication in Microsoft SQL Server Manager on the same computer where DBLint is installed, so I don't know what is wrong.  Can you please advise?  I am very interested in using your new tool! :)

Thanks,

Mike

 

Here is the content of the nvelocity.log file...  It is the only log file that I could find in your folder:

2012-06-01 10:41:50,896 - SimpleLog4NetLogSystem initialized using logfile 'nvelocity.log'
2012-06-01 10:41:50,896 - **************************************************************
2012-06-01 10:41:50,896 - Starting NVelocity v0.4.1
2012-06-01 10:41:50,896 - RuntimeInstance initializing.
2012-06-01 10:41:50,896 - Default Properties File: NVelocity.Runtime.Defaults.nvelocity.properties
2012-06-01 10:41:50,896 - Trying to use logger class NVelocity.Runtime.Log.SimpleLog4NetLogSystem,NVelocity
2012-06-01 10:41:50,896 - Using logger class NVelocity.Runtime.Log.SimpleLog4NetLogSystem,NVelocity
2012-06-01 10:41:50,896 - Default ResourceManager initializing. (NVelocity.Runtime.Resource.ResourceManagerImpl)
2012-06-01 10:41:50,896 - Resource Loader Instantiated: NVelocity.Runtime.Resource.Loader.FileResourceLoader
2012-06-01 10:41:50,911 - FileResourceLoader : initialization starting.
2012-06-01 10:41:50,911 - FileResourceLoader : adding path '.'
2012-06-01 10:41:50,911 - FileResourceLoader : initialization complete.
2012-06-01 10:41:50,911 - ResourceCache : initialized. (NVelocity.Runtime.Resource.ResourceCacheImpl)
2012-06-01 10:41:50,911 - Default ResourceManager initialization complete.
2012-06-01 10:41:50,927 - Loaded System Directive: NVelocity.Runtime.Directive.Include,NVelocity
2012-06-01 10:41:50,927 - Loaded System Directive: NVelocity.Runtime.Directive.Parse,NVelocity
2012-06-01 10:41:50,927 - Loaded System Directive: NVelocity.Runtime.Directive.Literal,NVelocity
2012-06-01 10:41:50,927 - Loaded System Directive: NVelocity.Runtime.Directive.Macro,NVelocity
2012-06-01 10:41:50,927 - Loaded System Directive: NVelocity.Runtime.Directive.Foreach,NVelocity
2012-06-01 10:41:50,927 - Created: 20 parsers.
2012-06-01 10:41:50,943 - Velocimacro : initialization starting.
2012-06-01 10:41:50,943 - Velocimacro : adding VMs from VM library template : VM_global_library.vm
2012-06-01 10:41:50,958 - ResourceManager : unable to find resource 'VM_global_library.vm' in any resource loader.
2012-06-01 10:41:50,958 - Velocimacro : error using  VM library template VM_global_library.vm : NVelocity.Exception.ResourceNotFoundException: Unable to find resource 'VM_global_library.vm'
   at NVelocity.Runtime.Resource.ResourceManagerImpl.getResource(String resourceName, Int32 resourceType, String encoding)
   at NVelocity.Runtime.RuntimeInstance.getTemplate(String name, String encoding)
   at NVelocity.Runtime.RuntimeInstance.getTemplate(String name)
   at NVelocity.Runtime.VelocimacroFactory.initVelocimacro()
2012-06-01 10:41:50,958 - Velocimacro :  VM library template macro registration complete.
2012-06-01 10:41:50,958 - Velocimacro : allowInline = true : VMs can be defined inline in templates
2012-06-01 10:41:50,958 - Velocimacro : allowInlineToOverride = false : VMs defined inline may NOT replace previous VM definitions
2012-06-01 10:41:50,958 - Velocimacro : allowInlineLocal = false : VMs defined inline will be  global in scope if allowed.
2012-06-01 10:41:50,958 - Velocimacro : messages on  : VM system will output logging messages
2012-06-01 10:41:50,958 - Velocimacro : autoload off  : VM system will not automatically reload global library macros
2012-06-01 10:41:50,958 - Velocimacro : initialization complete.
2012-06-01 10:41:50,958 - NVelocity successfully started.
2012-06-01 10:44:12,757 - SimpleLog4NetLogSystem initialized using logfile 'nvelocity.log'
2012-06-01 10:44:12,757 - **************************************************************
2012-06-01 10:44:12,757 - Starting NVelocity v0.4.1
2012-06-01 10:44:12,757 - RuntimeInstance initializing.
2012-06-01 10:44:12,757 - Default Properties File: NVelocity.Runtime.Defaults.nvelocity.properties
2012-06-01 10:44:12,757 - Trying to use logger class NVelocity.Runtime.Log.SimpleLog4NetLogSystem,NVelocity
2012-06-01 10:44:12,757 - Using logger class NVelocity.Runtime.Log.SimpleLog4NetLogSystem,NVelocity
2012-06-01 10:44:12,757 - Default ResourceManager initializing. (NVelocity.Runtime.Resource.ResourceManagerImpl)
2012-06-01 10:44:12,757 - Resource Loader Instantiated: NVelocity.Runtime.Resource.Loader.FileResourceLoader
2012-06-01 10:44:12,772 - FileResourceLoader : initialization starting.
2012-06-01 10:44:12,772 - FileResourceLoader : adding path '.'
2012-06-01 10:44:12,772 - FileResourceLoader : initialization complete.
2012-06-01 10:44:12,772 - ResourceCache : initialized. (NVelocity.Runtime.Resource.ResourceCacheImpl)
2012-06-01 10:44:12,772 - Default ResourceManager initialization complete.
2012-06-01 10:44:12,788 - Loaded System Directive: NVelocity.Runtime.Directive.Include,NVelocity
2012-06-01 10:44:12,788 - Loaded System Directive: NVelocity.Runtime.Directive.Parse,NVelocity
2012-06-01 10:44:12,788 - Loaded System Directive: NVelocity.Runtime.Directive.Literal,NVelocity
2012-06-01 10:44:12,788 - Loaded System Directive: NVelocity.Runtime.Directive.Macro,NVelocity
2012-06-01 10:44:12,788 - Loaded System Directive: NVelocity.Runtime.Directive.Foreach,NVelocity
2012-06-01 10:44:12,788 - Created: 20 parsers.
2012-06-01 10:44:12,788 - Velocimacro : initialization starting.
2012-06-01 10:44:12,788 - Velocimacro : adding VMs from VM library template : VM_global_library.vm
2012-06-01 10:44:12,819 - ResourceManager : unable to find resource 'VM_global_library.vm' in any resource loader.
2012-06-01 10:44:12,819 - Velocimacro : error using  VM library template VM_global_library.vm : NVelocity.Exception.ResourceNotFoundException: Unable to find resource 'VM_global_library.vm'
   at NVelocity.Runtime.Resource.ResourceManagerImpl.getResource(String resourceName, Int32 resourceType, String encoding)
   at NVelocity.Runtime.RuntimeInstance.getTemplate(String name, String encoding)
   at NVelocity.Runtime.RuntimeInstance.getTemplate(String name)
   at NVelocity.Runtime.VelocimacroFactory.initVelocimacro()
2012-06-01 10:44:12,819 - Velocimacro :  VM library template macro registration complete.
2012-06-01 10:44:12,819 - Velocimacro : allowInline = true : VMs can be defined inline in templates
2012-06-01 10:44:12,819 - Velocimacro : allowInlineToOverride = false : VMs defined inline may NOT replace previous VM definitions
2012-06-01 10:44:12,819 - Velocimacro : allowInlineLocal = false : VMs defined inline will be  global in scope if allowed.
2012-06-01 10:44:12,819 - Velocimacro : messages on  : VM system will output logging messages
2012-06-01 10:44:12,819 - Velocimacro : autoload off  : VM system will not automatically reload global library macros
2012-06-01 10:44:12,819 - Velocimacro : initialization complete.
2012-06-01 10:44:12,819 - NVelocity successfully started.
2012-06-01 10:51:31,247 - SimpleLog4NetLogSystem initialized using logfile 'nvelocity.log'
2012-06-01 10:51:31,262 - **************************************************************
2012-06-01 10:51:31,262 - Starting NVelocity v0.4.1
2012-06-01 10:51:31,262 - RuntimeInstance initializing.
2012-06-01 10:51:31,262 - Default Properties File: NVelocity.Runtime.Defaults.nvelocity.properties
2012-06-01 10:51:31,262 - Trying to use logger class NVelocity.Runtime.Log.SimpleLog4NetLogSystem,NVelocity
2012-06-01 10:51:31,262 - Using logger class NVelocity.Runtime.Log.SimpleLog4NetLogSystem,NVelocity
2012-06-01 10:51:31,262 - Default ResourceManager initializing. (NVelocity.Runtime.Resource.ResourceManagerImpl)
2012-06-01 10:51:31,262 - Resource Loader Instantiated: NVelocity.Runtime.Resource.Loader.FileResourceLoader
2012-06-01 10:51:31,262 - FileResourceLoader : initialization starting.
2012-06-01 10:51:31,262 - FileResourceLoader : adding path '.'
2012-06-01 10:51:31,262 - FileResourceLoader : initialization complete.
2012-06-01 10:51:31,262 - ResourceCache : initialized. (NVelocity.Runtime.Resource.ResourceCacheImpl)
2012-06-01 10:51:31,262 - Default ResourceManager initialization complete.
2012-06-01 10:51:31,278 - Loaded System Directive: NVelocity.Runtime.Directive.Include,NVelocity
2012-06-01 10:51:31,278 - Loaded System Directive: NVelocity.Runtime.Directive.Parse,NVelocity
2012-06-01 10:51:31,278 - Loaded System Directive: NVelocity.Runtime.Directive.Literal,NVelocity
2012-06-01 10:51:31,278 - Loaded System Directive: NVelocity.Runtime.Directive.Macro,NVelocity
2012-06-01 10:51:31,278 - Loaded System Directive: NVelocity.Runtime.Directive.Foreach,NVelocity
2012-06-01 10:51:31,294 - Created: 20 parsers.
2012-06-01 10:51:31,294 - Velocimacro : initialization starting.
2012-06-01 10:51:31,294 - Velocimacro : adding VMs from VM library template : VM_global_library.vm
2012-06-01 10:51:31,309 - ResourceManager : unable to find resource 'VM_global_library.vm' in any resource loader.
2012-06-01 10:51:31,325 - Velocimacro : error using  VM library template VM_global_library.vm : NVelocity.Exception.ResourceNotFoundException: Unable to find resource 'VM_global_library.vm'
   at NVelocity.Runtime.Resource.ResourceManagerImpl.getResource(String resourceName, Int32 resourceType, String encoding)
   at NVelocity.Runtime.RuntimeInstance.getTemplate(String name, String encoding)
   at NVelocity.Runtime.RuntimeInstance.getTemplate(String name)
   at NVelocity.Runtime.VelocimacroFactory.initVelocimacro()
2012-06-01 10:51:31,325 - Velocimacro :  VM library template macro registration complete.
2012-06-01 10:51:31,325 - Velocimacro : allowInline = true : VMs can be defined inline in templates
2012-06-01 10:51:31,325 - Velocimacro : allowInlineToOverride = false : VMs defined inline may NOT replace previous VM definitions
2012-06-01 10:51:31,325 - Velocimacro : allowInlineLocal = false : VMs defined inline will be  global in scope if allowed.
2012-06-01 10:51:31,325 - Velocimacro : messages on  : VM system will output logging messages
2012-06-01 10:51:31,325 - Velocimacro : autoload off  : VM system will not automatically reload global library macros
2012-06-01 10:51:31,325 - Velocimacro : initialization complete.
2012-06-01 10:51:31,325 - NVelocity successfully started.

Jul 14 at 12:09 AM
Edited Jul 14 at 12:20 AM
Mike, et al,

I know this thread is very old but I wanted to share my solution for those who come along later.

I had the SAME problem while trying to run DbLint on a LOCAL Sql Server 2012 database. What fixed it for me was to remove the port number all together. Just delete whatever value is in the form. I emphasize "local" because most local installations are configured to use the default Sql port. This fix may not be much help to those running with a custom port number assigned.

Hope this helps others in the future.

~ Garth

By the way, DbLint works just fine when reporting against a MSSQL 2012 db.