odbc

I_Server_Whale · Post by **I_Server_Whale** » Wed Dec 27, 2006 1:48 pm

kishoreramachandran wrote:I am able to see a dsn but when I select it I get the message invalid authorization BCI error

Are you seeing same DSN(s) that were created on the server box and were provided to you?

Because there's a difference between "a DSN" and "the DSN".

DSguru2B · Post by **DSguru2B** » Wed Dec 27, 2006 1:50 pm

Copy paste the entire error message.

kishoreramachandran · Post by **kishoreramachandran** » Wed Dec 27, 2006 2:45 pm

I am able to see the same dsn given to me .
dsr.metageta (sql connect} BCI error
Sql state = 28000 code = 201 {datastage} sql client {odbc} invalid authorization specification

I_Server_Whale · Post by **I_Server_Whale** » Wed Dec 27, 2006 3:04 pm

What is the database that you are trying to connect through ODBC?

chulett · Post by **chulett** » Wed Dec 27, 2006 3:04 pm

How about a clue as to what database you are connecting to with this? SQL Server?

I'd also suggest you post the .odbc.ini entry that was created for this so we can see if it was configured correctly or not.

narasimha · Post by **narasimha** » Wed Dec 27, 2006 3:09 pm

narasimha wrote:
kishoreramachandran wrote:yes I mean my Pc when I say machine . And I want to access the data through odbc stage.
What database are you trying to connect?
Sometimes, if you dont have a DSN set up for that database, you might have to create one yourself.

This is the third time you have been asked this question. You are making everybody guess here

kishoreramachandran · Post by **kishoreramachandran** » Wed Dec 27, 2006 3:17 pm

netezza

narasimha · Post by **narasimha** » Wed Dec 27, 2006 3:27 pm

Now the next step, What Craig asked....

chulett wrote:I'd also suggest you post the .odbc.ini entry that was created for this so we can see if it was configured correctly or not.

I_Server_Whale · Post by **I_Server_Whale** » Wed Dec 27, 2006 3:33 pm

What was the ODBC driver used to configure the DSN? Are you using DataDirect drivers? Not sure whether DataDirect provides drivers for Netezza.

kishoreramachandran · Fri Dec 29, 2006 12:52 pm

If i make a change to .odbc.ini file should the server be restarted again, or when exactly the changes will take place

narasimha · Post by **narasimha** » Fri Dec 29, 2006 1:02 pm

A restart is not needed, the change should take place the next time you try to use that ODBC connection.

kishoreramachandran · Post by **kishoreramachandran** » Fri Dec 29, 2006 1:11 pm

now I start opening a new parallel odbc connection and if I give the datasource name,userid and password I am able to connect but If I try starting a new server job it tells me that the datasource name is not configured.Actually I am not able to see that DSN in the pull down box and so I typed it.

ray.wurlod · Post by **ray.wurlod** » Fri Dec 29, 2006 3:00 pm

"Not configured" typically means that there is no entry in the uvodbc.config file in the project directory on the server for that particular DSN.

kishoreramachandran · Post by **kishoreramachandran** » Fri Dec 29, 2006 3:06 pm

but when I go to new parallel job odbc source and give the dsn name userid and password and give a table name and column I am able to view the data in the column. But if I compile it says not configured

kishoreramachandran · Post by **kishoreramachandran** » Fri Dec 29, 2006 3:20 pm

Failed to connect to JobMonApp on port 13403