0

I'm trying to find out ways for calling a stored procedure in Teradata from .Net.

I looked at the question below: TD connection setup

But I do not want to put my password in the web.config. I can encrypt it but the web.config needs to be encrypted for each server with MSA key created on that particular server in the cluster to make it work.

Are there any other ways to make it work like using only DSN? Or any other way where I can create an app pool with the service account and pass it to the Teradata for authentication?

Thanks in advance.

Community
  • 1
  • 1
Archana
  • 84
  • 9

1 Answers1

1
<%@ Page LANGUAGE="VB" Debug="true" %>
<%@ Import Namespace="System.Data.ODBC" %>

<script runat="server">
sub Page_Load
dim dbconn

dbconn=New OdbcConnection("Dsn=TDD32;")

dbconn.Open()
dbconn.Close()
end sub
</script>
access_granted
  • 1,807
  • 20
  • 25
  • Thanks. It works in my local, but on the server I get following error: ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified – Archana Mar 24 '16 at 20:52
  • You have to set the same DSN on the server as well. – access_granted Mar 24 '16 at 21:01
  • Somehow it worked for 32-bit DSN but was not working for 64-bit one. – Archana Apr 01 '16 at 23:55
  • You need to pick a correct ODBC Manager for the correct target. For 32-bit DSNs use c:\Windows\SysWOW64\odbcad32.exe, and for 64-bit DSNs c:\Windows\System32\odbcad32.exe. – access_granted Apr 04 '16 at 04:36