#DateForumTypeThreadPost
3728 May 2007 @ 09:43 PDTConnectivityTopicTdConnection is not openHi,I have built a working application in vb.net and have installed it on the network.2(including my own development pc) of 5 pcs will connect to the database from the application. The other 3 give ...
3629 Mar 2007 @ 04:10 PDTConnectivityReplyPlease Helpno but the workaround for the update is fine, td will apparently be packaging the fix with the next release. If you are inserting or deleting then the workaround needs quite a bit of modification.
3506 Mar 2007 @ 09:14 PSTUDATopicTeradata on Linux Vs Teradata on WindowsIn general, what has your company got.Teradata on Linux or Teradata on Windows?Someone here decided that we would operate from windows.However, we seem to be having immense problems on restores in ...
3422 Feb 2007 @ 12:21 PSTConnectivityReplyPlease HelpWorkaround as follows: Private Sub btnUpdateDataSet2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnUpdateDataSet2.Click If DataSet11.HasChanges Then ...
3321 Feb 2007 @ 10:54 PSTUDAReplyLinking ServersThanks I appreciate that.I don't mind if we cannot do it in an SQL Stmt. A Utility is probably a better way. I like the uder the covers useage of the Teradata Parallel Transporter. What packages is...
3221 Feb 2007 @ 09:29 PSTUDAReplyTable QueryI've been reading about the Teradata Metadata Services Utility.It seems to have what I'm looking for.Has anyone had much experience with this utility and do you think it could fulfil my requirement...
3121 Feb 2007 @ 09:20 PSTUDATopicLinking ServersIs there any plans to be able to link servers in Teradata. Now or in the future.Does anybody think it would be useful?For example run a query as follows:SEL * FROM Primary_Server.TblA WHERE Col1 = ...
3016 Feb 2007 @ 11:03 PSTUDATopicTable QueryHi, I am new to Teradata.I am looking for a table that holds the text of a Stored Procedure.In essence I am trying to create a query that will show me the dependant objects if I pass the query a ta...
2925 Jan 2007 @ 05:51 PSTConnectivityReplyPlease HelpThis has been logged with Teradata.Global Support Centre have identified it as a true bug and are dealing with it, no pressure guys, we only go live in 2 weeks.
2819 Jan 2007 @ 08:50 PSTUDATopicSource Control for warehouse programsHi,We are designing a process that will generate each object in our warehouse as a text file.We then plan to add these objects to Visual Source Safe.What objects scripting methods and source contro...
2718 Jan 2007 @ 10:45 PSTConnectivityReplyPlease HelpIt seems this is a bug in the Teradata Driver.Has anyone had experience with this?
2618 Jan 2007 @ 07:28 PSTConnectivityTopicPlease HelpPlease help!Visual Studio VB.NET 2005 - DB: Teradata - .NET Data Provider for Teradata. (teradat.client.profile.dll)I have given my dataAdapter this Select command.SELECT * FROM DEV_DATA_T.MISRE_Th...
2518 Jan 2007 @ 06:03 PSTUDATopicparameterized updateHey, I am running the explain(F6) on the below update command and am getting error 3939: There is a mismatch between the number of parameters specified and the number of parameters required.I canno...
2417 Jan 2007 @ 12:53 PSTConnectivityReplyupdate error Error 3939I have now added the parameters as per the columns of the table used in the select. There is no way to quantify what '?' is in the update command so I can only include these.Also, I have just notic...
2317 Jan 2007 @ 11:49 PSTConnectivityReplyupdate error Error 3939Could the problem be that the data Adapter did not create any parameters collection for the Update command!!!!How do i go about fixing that?note: I am migrating this application from VS2003 to VS20...
2217 Jan 2007 @ 07:06 PSTConnectivityReplyVB.NET DataAdapter Configuration Wizard Problempls ignore, fixed. it was a view and the PK was not visible to the view, changed to underlying table.
2117 Jan 2007 @ 07:02 PSTConnectivityTopicupdate error Error 3939Teradata.Client.Provider.tdException: [Teradata Database] [3939] There is a mismatch between the number of parameters specified and the number of parameters required.My update is generated through ...
2016 Jan 2007 @ 12:31 PSTConnectivityTopicVB.NET DataAdapter Configuration Wizard ProblemI have a screen with a dataGrid.I dropped tdDataAdapter1 onto the design screen and configured it to generate a connection tdConnection1 and a dataSet 'DataSet1'. I chose the option to generate the...
1916 Jan 2007 @ 05:44 PSTConnectivityReplyvb.Net call to Teradata stored procedurewhich is fine but the name could and will in my case exceed 30 charaters.I have used the tools-modify user-default database tool instead. I don't think this will have any issue in dev.thanks for th...
1815 Jan 2007 @ 09:48 PSTConnectivityReplyvb.Net call to Teradata stored procedureI've gotten a bit further in that i have the sProc running but the default database it picks up (DEV_DATA_DIMS) when running a sProc is causing issue. The sProc resides on DEV_DATA_V, I have madea ...
1715 Jan 2007 @ 07:57 PSTConnectivityReplyvb.Net call to Teradata stored procedureThanks Shaw, I am still confused though.I tried your suggestion as shown in code at the bottom of this thread by passing 3 parameters as per the code snippet you recommended. However, where exactly...
1610 Jan 2007 @ 12:27 PSTConnectivityReply.Net Data Provider for Tearadata connection problemHey Fred. Whether ODBC or Teradata.Client.Provider, would that make any difference to the deployment on the aspx server though even after initial deployment on desktop worked?
1510 Jan 2007 @ 12:18 PSTConnectivityTopicvb.Net call to Teradata stored procedureHey,The below function won't build for me at the two statements below attempting to add parameters to a dynamic stored procedure call. It doesn't like the 2nd parameter in each statement. I just ca...
1409 Jan 2007 @ 10:29 PSTConnectivityReply.Net Data Provider for Tearadata connection problemthis is what i used for my windows app in vb.net. Hope this helps. I'm not sure what the server problem you are experiencung is though, sorry. '.NET Data Provider for Teradata - Teradata.Client....
1309 Jan 2007 @ 09:08 PSTDatabaseReply.NET Data Provider for TeradataOh and make sure you are Visual Studio.net 2005 or it's incompatible. Something the teradata site will not tell you.

Pages