|
|
|
Junior Member
 
Group: Forum Members
Last Login: 10/23/2008 5:48:15 PM
Posts: 10,
Visits: 48
|
|
i am trying to connect to Teradata but not sure which one i should connect through. i dontloaded the .NET provider but i also downloaded the ODBC driver. i created a connection string for each type. but in the code behind (C#) on my web application, im not sure what my connection code should look like. Here is what i have so far, can anyone tell me what im doing wrong?
Thanks:
public static DataSet getTDSOCList() {
string TDCnnString = "Provider=Teradata; DBCName=prdbi; Database=PROTO_VAS; Uid=username; Pwd=pw";
string TDQuery = "select * from CLEV_TRN.sma_SocGroup";
OdbcConnection Conn = new OdbcConnection(TDCnnString);
OdbcCommand cmd = new OdbcCommand(TDQuery, TDCnnString);
Conn.Open();
OdbcDataReader TDReader = cmd.ExecuteReader();
Conn.Close();
|
|
|
|
|
Supreme Being
Group: Forum Members
Last Login: Yesterday @ 6:06:39 PM
Posts: 125,
Visits: 271
|
|
Use .NET Data Provider for Teradata.
Sample Code:
using (TdConnection cn = new TdConnection())
{
TdConnectionStringBuilder conStrBuilder = new TdConnectionStringBuilder();
conStrBuilder.DataSource = "prdbi";
conStrBuilder.Database = "PROTO_VAS";
conStrBuilder.UserId = "userName";
conStrBuilder.Password = "pass";
cn.ConnectionString = conStrBuilder.ConnectionString;
cn.Open();
TdCommand cmd = cn.CreateCommand();
cmd.CommandText = "select * from CLEV_TRN.sma_SocGroup";
DataSet dataSet = new DataSet();
TdDataAdapter dataAdapter = new TdDataAdapter(cmd);
dataAdapter.Fill(dataSet);
return (dataSet);
}
Shaw
|
|
|
|
|
Junior Member
Group: Forum Members
Last Login: 10/23/2008 5:48:15 PM
Posts: 10,
Visits: 48
|
|
so here is what my code behind looks like now:
using (TdConnection cn = new TdConnection())
{
TdConnectionStringBuilder conStrBuilder = new TdConnectionStringBuilder();
conStrBuilder.DataSource = "prdbi";
conStrBuilder.Database = "PROTO_VAS";
conStrBuilder.UserId = "USER_User";
conStrBuilder.Password = "psswrd";
cn.ConnectionString = conStrBuilder.ConnectionString;
cn.Open();
TdCommand cmd = cn.CreateCommand();
cmd.CommandText = "select * from PROTO_VAS.sma_SocGroup";
DataSet ds = new DataSet();
TdDataAdapter da = new TdDataAdapter(cmd);
da.Fill(ds);
return(ds);
}
its saying invalid token "using" in class, struct or interface member declaration
also invalid token "=" for all the conStrBuilder. am i missing something? shouldnt there be like a
private static DataSet getSOCList() or something to start it off?
|
|
|
|
|
Junior Member
Group: Forum Members
Last Login: 10/23/2008 5:48:15 PM
Posts: 10,
Visits: 48
|
|
|
i figured it out. thank youfor your help
|
|
|
|