| Author |
Message
|
| abhyyy |
 Posted: Wed Jul 24, 2013 8:39 am Post subject: |
 |
|
Voyager
Joined: 29 Sep 2011
Posts: 83
|
| Quote: |
We will help you in the future. Let's find a way to expedite the solution.
We can't play twenty questions. You have to be detailed enough to post the needful information at the first. |
Sure , will keep that in mind. Thanks. 
_________________
----------------------
NeVeR StOp LeaRnInG. |
|
| Back to top |
|
 |
| fjb_saper |
| Posted: Wed Jul 24, 2013 9:03 pm Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
So you expected the DSN to resolve magically the DB name without setting it explicitely as default? How were you going to distinguish between multiple databases supported by the same DBEngine?
And if I read your post right you said you set up the DSN but mentioned nowhere that there was no DB selected in the DSN... 
_________________
MQ & Broker admin |
|
| Back to top |
|
|
| abhyyy |
| Posted: Wed Jul 24, 2013 9:16 pm Post subject: |
|
|
Voyager
Joined: 29 Sep 2011
Posts: 83
|
I dint know that magic works in websphere family !! 
Regarding your question ;
When an MS SQL server 2012 instance is created , a default DB is automatically selected.
If we dont change that DB name then it is used as default db but in my case I intended to use a different db and forgot that I had not changed the default db and that was the mistake I wasn't able to figure out.
_________________
----------------------
NeVeR StOp LeaRnInG. |
|
| Back to top |
|
|
| fjb_saper |
| Posted: Wed Jul 24, 2013 9:24 pm Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
| abhyyy wrote: |
I dint know that magic works in websphere family !!
Regarding your question ;
When an MS SQL server 2012 instance is created , a default DB is automatically selected.
If we dont change that DB name then it is used as default db but in my case I intended to use a different db and forgot that I had not changed the default db and that was the mistake I wasn't able to figure out. |
IIRC on a Windows MSSQL DSN creation the default DB is master (which is a system DB you are never supposed to use). So you would have to specify the DB to connect to on the DSN in any case.
_________________
MQ & Broker admin |
|
| Back to top |
|
|
| abhyyy |
| Posted: Wed Jul 24, 2013 9:30 pm Post subject: |
|
|
Voyager
Joined: 29 Sep 2011
Posts: 83
|
Appreciate you response.
But a couple of database had already been created on the MS SQL server 2012 instance but I forgot the point that "default" db is master which is system db and that was the only mistake that led me to troubleshooting headache and finally coming to experts on this forum, but I had to finally figure out the solution myself.
Thanks anyways for all your concerns.
_________________
----------------------
NeVeR StOp LeaRnInG. |
|
| Back to top |
|
|
| fjb_saper |
| Posted: Wed Jul 24, 2013 9:37 pm Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
It's the little points like that, that will kill you and eat up lots of time.
I'm sure having run into this trouble once, that you will remember to check it next time...
I have a few friends that do screen shots with emphasis on the important points. Maybe you should create a set of them on how to create the DSN for the broker for yourself. So next time you just retrieve the set of screen shots and verify you followed known procedure. Saves a lot of time...
_________________
MQ & Broker admin |
|
| Back to top |
|
|
| abhyyy |
| Posted: Wed Jul 24, 2013 9:41 pm Post subject: |
|
|
Voyager
Joined: 29 Sep 2011
Posts: 83
|
As I have mentioned at the very start of my post
| Quote: |
Hi Friends,
I am new to WMB to MS SQL integration. |
gives you an idea that this was my first time with MS SQL. I always keep documentation of such first times(as suggested by u also) and have done the same for this. Thanks. 
_________________
----------------------
NeVeR StOp LeaRnInG. |
|
| Back to top |
|
|
| abhyyy |
| Posted: Thu Oct 17, 2013 9:00 pm Post subject: |
|
|
Voyager
Joined: 29 Sep 2011
Posts: 83
|
Just closing the thread.
The correct way to query from compute node is :
SELECT * FROM "MS SQL DB Schema name"."TableName"
and
Set Data Source property in Compute node to System DSN name (If you are using ODBC to connect to MS SQL server)
_________________
----------------------
NeVeR StOp LeaRnInG. |
|
| Back to top |
|
|
| dogorsy |
| Posted: Thu Oct 17, 2013 9:09 pm Post subject: |
|
|
Knight
Joined: 13 Mar 2013
Posts: 553
Location: Home Office
|
| abhyyy wrote: |
Just closing the thread.
The correct way to query from compute node is :
SELECT * FROM "MS SQL DB Schema name"."TableName"
and
Set Data Source property in Compute node to System DSN name (If you are using ODBC to connect to MS SQL server) |
That is what the documentation says... considering that you opened the thread in July, would it not have been quicker to read the docs ? |
|
| Back to top |
|
|
| abhyyy |
| Posted: Thu Oct 17, 2013 9:15 pm Post subject: |
|
|
Voyager
Joined: 29 Sep 2011
Posts: 83
|
| Quote: |
| That is what the documentation says... considering that you opened the thread in July, would it not have been quicker to read the docs ? |
Do you have the reference of the document which says that ? If so, please share.
_________________
----------------------
NeVeR StOp LeaRnInG. |
|
| Back to top |
|
|
| abhyyy |
| Posted: Thu Oct 17, 2013 9:18 pm Post subject: |
|
|
Voyager
Joined: 29 Sep 2011
Posts: 83
|
ohh .. I forgot.
You are 'all talk and know nothing' kind of breed. Let it be. You go back to the hole where you went to in July.
_________________
----------------------
NeVeR StOp LeaRnInG. |
|
| Back to top |
|
|
|
|
