I am using MSSQL (Microsoft SQL)to liase with python via third party driver.
Well here goes...
I have created two instances of SQL registration in my Enterprise manager. It is under
i)Console Root->Microsoft SQL Servers->SQL Server Group->(LOCAL)(Windows NT) and
ii)Console Root->Microsoft SQL Servers->SQL Server Group-> INTEL\FR6EnterpriseDB (Windows NT)
Btw INTEL is the name of my computer..
So in fact both of them are in localhost...
Here's the problem...
db=MSSQL.connect('localhost','sa','','FirstDBase') ..there's no problem and the database access is successful in the first case.
but I am not sure on how to access the database in the second instance
db=MSSQL.connect('22.214.171.124','sa','','SecondDbase') and in this case the used IP is the one I got when ipconfig at the cmd prompt.
The error occurs and dbopen('126.96.36.199') fails. I have tried other names like 'localhost' and '127.0.0.1'.
A million thanks to anyone who can guide me in the right direction.