|
|
|
Junior Member
 
Group: Forum Members
Last Login: 10/23/2008 5:48:15 PM
Posts: 10,
Visits: 48
|
|
i am wondering if anyone has built an application and connected to Teradata through the application?
if so, i am wondering what the connection string should look like in the code behind. also, is there a namespace that i should use in order to get Teradata options in asp.net?
Thanks
|
|
|
|
|
Supreme Being
Group: Forum Members
Last Login: Today @ 7:30:07 AM
Posts: 197,
Visits: 611
|
|
Hello,
You can use:
- .NET Data Provider for Teradata
- ODBC Data Provider
Both can be downloaded from "http://www.teradata.com/DownloadCenter/".
Following sample queries can be used (www.connectionstrings.com):
- Data Source=myServerAddress;User ID=myUsername;Password=myPassword; (.NET Data provider)
- Provider=Teradata;DBCName=MyDbcName;Database=myDataBase;Uid=myUsername;Pwd=myPassword; (ODBC)
HTH.
Regards,
Adeel
|
|
|
|
|
Supreme Being
Group: Forum Members
Last Login: Today @ 7:30:07 AM
Posts: 197,
Visits: 611
|
|
Additionally, in case of .NET Data Provider after installing and adding reference, you can use "Teradata.Client.Provider" namespace.
Regards,
Adeel
|
|
|
|
|
Junior Member
Group: Forum Members
Last Login: 10/23/2008 5:48:15 PM
Posts: 10,
Visits: 48
|
|
|
when i try using the Teradata.Client.Provider namespace, it doesnt recognize it. does the .Net Provider have to be in a certain location for .Net to see it?
|
|
|
|
|
Junior Member
Group: Forum Members
Last Login: 10/23/2008 5:48:15 PM
Posts: 10,
Visits: 48
|
|
|
nevermind. i forgot to add the reference to the .net provider. got it. thank you very much
|
|
|
|