Odbc connection error

[Anonymous]

Hi All

while creating odbc connection after giving data source name db server and ntname authentication

it is giving error as

connection failed

sqlstate:'01000'

sqlserver error:2

any one please help me how to create

thanks in advanse

[manojkulkarni]

It is nothing to do with Qlikview. Please check the below link

https://support.microsoft.com/en-us/kb/818047

[simospa]

Hi,

in ODBC management (in Windows, not QlikView) you might have a Test Connection button.

Does it work?

S.

[HirisH_V7]

Hi ,

Do check this,

Loading ODBC and OLE DB Data (video)

-Hirish

[Peter_Cammaert]

Does your SQL Server allow for connections over tcp/ip?

[awhitfield]

Have you actually created the ODBC connection in Windows first? And actually tested it?

Andy