Hi, I am using MSSQL (Microsoft SQL)to lease 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 local host...
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('193.168.1.111','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('193.168.1.111') 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.
db=MSSQL.connect('INTEL\FR6EnterpriseDB','sa','','SecondDBase') try this, I'm an ADO user so not sure about Python, but the theory should be the same. You see both databases are listening on that IP address 193.168.1.111, which is synonymous with 'INTEL', the only way to differentiate is that the server with no name is the default and the other is called 'FR6EnterpriseDB' so when connecting if you don’t differentiate in your string it will try to find 'SecondDBase' in the default server and of course it's not there so it fails.
Hi man, Your above solution werks..I am hosting to the database and my colleague running on Linux has prob connecting. He can connect to the 193.168.1.111 but not to the one with the '193.168.1.111\FR6Enterprise' .
I am grateful if anyone knows what the problem is...Or is that Linux doesn’t support the anything else other than the default instance.