944,168 Members | Top Members by Rank

Web Development > Databases > MS SQL > MSSQL connection strings
Ad:
  • MS SQL Discussion Thread
  • Unsolved
  • Views: 10011
  • MS SQL RSS
Permalink
Jul 24th, 2006
0

MSSQL connection strings

Expand Post »
Hi,
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('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.
Similar Threads
Reputation Points: 10
Solved Threads: 0
Newbie Poster
hanifa is offline Offline
22 posts
since Jul 2006
Permalink
Jul 24th, 2006
0

Re: MSSQL connection strings

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 synonymouse 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.
Reputation Points: 262
Solved Threads: 68
Veteran Poster
hollystyles is offline Offline
1,181 posts
since Feb 2005
Permalink
Jul 24th, 2006
0

Re: MSSQL connection strings

Thanks a million...It finally werks... After a shit whole of week, sumtin to cherish..

Kudos to U guys at daniWeb...
Reputation Points: 10
Solved Threads: 0
Newbie Poster
hanifa is offline Offline
22 posts
since Jul 2006
Permalink
Aug 15th, 2006
0

Re: MSSQL connection strings

Quote originally posted by hollystyles ...
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 synonymouse 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 collegue 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 gratefull if anyone knoes what the problem is...Or is that Linux doesnt support the anyting else other than the default instance.

Thanks in advance.
Reputation Points: 10
Solved Threads: 0
Newbie Poster
hanifa is offline Offline
22 posts
since Jul 2006
Permalink
Aug 17th, 2006
0

Re: MSSQL connection strings

Hi it is solved.. the linux problem...
I never knew MSSQL uses different port for every instance...dats it...
Bottom line: U must specify ur port number in ur connectionstring..

Cheers
Reputation Points: 10
Solved Threads: 0
Newbie Poster
hanifa is offline Offline
22 posts
since Jul 2006

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Message:
Previous Thread in MS SQL Forum Timeline: UpdateCommand does not work
Next Thread in MS SQL Forum Timeline: Min function





About Us | Contact Us | Advertise | Acceptable Use Policy
Forum Index | Build Custom RSS Feed


Follow us on Twitter


© 2011 DaniWeb® LLC