Connection to paradox 4 from vb.net application ?

TheMSsForum.com: The Microsoft Software Forum

The MSS Forum ‹ Ado
- Archive
  - Biz
  - MCSE
  - CRM
  - Drivers
  - Framework
  - ADO
  - ASP
  - Compact
  - Forms
  - Dotnet
  - C#
  - VB
  - FontpageGen
  - Excel
  - WorkSheet
  - Exchange
  - Setup
  - Fox
  - Fontpage
  - ASP
  - IIS
  - Entourage
  - Money
  - Messanger
  - PocketPC
  - Powerpoint
  - Project
  - Publisher
  - Excel
  - VB
  - Security
  - Portal
  - Services
  - SQLServerDev
  - SVCS
  - SQLServer
  - VB
  - VC
  - MFC
  - ExcelGen

- Previous
  - 1
    - SqlDataReader advancing on each line of executable code within a loop I have the following code (this is only a small snippet of the code) compiled into a VB.Net exe file. The SqlDataReader (myReader) is populated via an SqlCommand.ExecuteReader() method call where the CommandType is a stored procedure on SQLServer2000. 1: myReader = myCommand.ExecuteReader() 2: Do While myReader.Read() 3: Select Case myReader.GetInt32(0) 4: Case 1 5: ' do one thing 6: Case 2 7: ' do something else 8: Case 3 9: ' do yet another thing 10: End Select 11: ' more processing of the first record Loop According to the SqlDataReader documentation it is supposed to advance through the records on each call of the Read method and it is supposed to be positioned just prior to the first record right after the ExecuteReader method fills it. The issue I am experincing is that the reader is positioned on the first record after the ExecuteReader method (line 1). Consequently, after the Raed method is called on line 2, the value of the Select Case expression is now that of the second record. Also, after each Case evaluation (lines 4,6, and 8) the reader is advancing. Therefore, by the time it loops back to the Read method (Line 2) it is impossible to determine where the reader will be positioned. Line 1 executes: reader positioned on record 1 Line 2 executes: reader positioned on record 2 Line 3 executes: reader positioned on record 3 Line 4 executes: reader positioned on record 4 Line 6 executes: reader positioned on record 5 Line 8 executes: reader positioned on record 6 Line 9 executes: reader positioned on record 7 Line 11 through N executes: the reader advances for each executable line of code. Given that this is an exe file, there is no web.config file, so I'm wondering if there is some other location that a particular setting may be causing this behavior. I know I could put the initial data from the stored procedure int a DataSet and then iterate through the Rows collection, but I'd rather keep it simple with the Reader.Read methodology. Any help or insight into the cause of the observed behavior will be appreciated. Thanks, Tim Tag: Connection to paradox 4 from vb.net application ? Tag: 78994
  - 2
    - Connections Not Closing I am using the data access application block running on Windows server 2003 and accessing SQL 2000 database (on the same box). I have some very simple code that is getting executed from a asp.net page. The code is calling executeNonQuery in a loop 30 times. I notice that after the code executes and I go into SQL Enterprise Manager and look at the open connections there are 30 open connections. Is there something I am missing ? I thought the application block would handle closing the connections. The other interesting thing is if I run the same code on Windows 2000 server accessing the database on the 2003 server everything works ok. Any ideas ??? Tag: Connection to paradox 4 from vb.net application ? Tag: 78991
  - 3
    - Sysntax Error Inserting into a table with an OleDbCommand Hi all, I need another set of eyes to look at a problem I'm having. I'm trying to insert data into a Micrsoft Access 2002 table using the following SQL statement (all fields are Text): "Insert Into Customers (UserName, Password, FirstName, LastName, Address, PostCode, PhoneDay, PhoneEve, PhoneMob) Values ('Jack', 'beanstalk', 'Jack', 'Beanstalk', 'Nowhere', 'Nothing', '00000000', ' ', ' ')" As far as I can tell, there is absolutely nothing wrong with this Insert statement but ADO.Net thinks different and I keep getting a "Syntax error in INSERT INTO statement" error. The code I'm using is as follows: bool AllOk = true; RowsAffected = 0; try { OleDbConnection cn = new OleDbConnection(cnString()); cn.Open(); OleDbCommand cmd = new OleDbCommand(SQLstmt, cn); RowsAffected = cmd.ExecuteNonQuery(); <----THIS DOESN'T WORK cn.Close(); cn.Dispose(); cn = null; cmd.Dispose(); cmd = null; } catch (Exception e) {AllOk = false;} I'm getting desperate, can anyone tell me what I'm doing wrong. Regards. Wole London. -- =============================== Life is not fair, get used to it! God is fair, get Him! Tag: Connection to paradox 4 from vb.net application ? Tag: 78989
  - 4
    - Problem with Odbc and DB2 Hi.. My trouble is the follow I have a connection with System.Data.Odbc to DB Db2 v6.1 I called a storedp rocedure, this retrun 2 resultset, i fill a dataSet with a OdbcDataAdapter created with a OdbcCommand and the name storedprocedure and builded sentences with OdbcCommand Bulider. When i execute the DataAdapter.Fill(dataSet) i got the dataset with a table but this raise a error that is: System.Object "{"Referencia a objeto no establecida como instancia de un objeto." }" Thx by your help. Tag: Connection to paradox 4 from vb.net application ? Tag: 78988
  - 5
    - Microsoft Dotnet, Timestamp, and Char <very odd> Hi there, I am calling a number of Oracle stored procedures via the Microsoft OracleClient and the ODP.Net client (Using OracleDataAdapter.Update and/or Direct OracleCommand.ExecuteNonQuery in both) and I am noticing that any char parameters are over-padded with a full set (eg. 5 for char(5)) of blank characters (even when no padding is necessary or in addition to correct padding) whenever they are located after a timestamp parameter. This, of course, causes an 'Inserted value too large' error on those overpadded columns. The timestamp parameter has a null default, and causes no problems if the parameter is not passed and the default applied. However, if the parameter is passed with a actual value or DBNull.Value then the error occurs. Has anyone experienced anything like this? We are faced with making sure timestamp parameters are always at the bottom of the parameter list or using varchars for all logically fixed string columns. Neither really addresses the root problem. Thanks, Tracy Fletcher Tag: Connection to paradox 4 from vb.net application ? Tag: 78983
  - 6
    - Query string issue with Microsoft access. Hello Everyone, I am having an unusual problem. I have this string that I am using as the Select Command for an Access database: SELECT time.employee, time.timein, time.timeout, time.ichkalt, time.ochkalt, time.realin, time.realout, employees.FName, time.iDate, time.oDate, FROM departments INNER JOIN (employees INNER JOIN [time] ON employees.employeeid=time.employee) ON departments.departmentid=employees.departmentid WHERE ((time.oDate) <= " & o & " ) And ((employees.employeeid)= " & eid & " ) AND ((time.iDate)>= " & i & " ) The i, o, and eid variables have been declared already. The result set works when you remove the 'oDate <=" & o & " )' part of the statement. When you run the query without that criteria, the result set is returned correctly. When you add that criteria to the string, no results are returned, even when I am inserting correct information. Does anyone have a clue as to what to do? Thanks in advance. Tag: Connection to paradox 4 from vb.net application ? Tag: 78982
  - 7
    - Confused about DataRowVersion.Default From MSDN on DataRowVersion.Default: "The row the default version for the current DataRowState. For a DataRowState value of Added, Modified or Current, the default version is Current. For a DataRowState of Deleted, the version is Original. For a DataRowState value of Detached, the version is Proposed." Reading the above, I would assume that this code: ///// ReturnValue = MyDataRow[ "MyFieldName", DataRowVersion.Default ]; ///// Should be equivalent to this code: ///// if ( MyDataRow.RowState == DataRowState.Deleted ) { ReturnValue = MyDataRow[ "MyFieldName", DataRowVersion.Original ]; } else { ReturnValue = MyDataRow[ "MyFieldName", DataRowVersion.Current ]; } ///// However, the first block of code throws DeletedRowInaccessibleException while the second one works just fine. Am I reading the documentation wrong? What am I missing? Thanks, -Steve Tag: Connection to paradox 4 from vb.net application ? Tag: 78981
  - 8
    - Problem with SQL Server I have an asp.net form that works fine with an Access database. Now I want to use Sql Server 2000. It is installed on the same Windows 2003 machine as the aspx code runs. I cannot seem to have a SqlConnection successfully connect. I use the following: string str = "Persist Security Info=False;Integrated Security=SSPI;database="+strDatabase+";server="+strServer+";Connect Timeout=30"; m_SqlConnection = new SqlConnection(str); m_SqlConnection.Open(); I get Login failed for user 'NT AUTHORITY\NETWORK SERVICE' I have also tried to leave out the Persist Security Info and Integrated Security, and replace it with uid=sa;pwd=<my sa password here> but I get the error: Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server connection. The same thing occurs for any user that I add to the Enterprise Manager. At this point I am not sure what I need to do to configure Sql Server. I know that there are many knowledgable Sql Server users out there. Can anyone answer my question? Tag: Connection to paradox 4 from vb.net application ? Tag: 78979
  - 9
    - odd behaviour adding record to sql database i have created a form to submit data to an sql database, and it seems to work, except for one glitch. one of the fields, the "creditcardnumbertxt" text box, when entering a number with more that 7 characters, does not work. sql says it will be truncated. in the asp code, the database, and the sql procedure, the field is correctly set to allow a (sql datablase) char type of 18 characters in size. here is the error it spits back ---------------------------------- String or binary data would be truncated.The statement has been terminated..Net SqlClient Data Provider ----------------------------------- in the code behind the page, these are the relevant lines: ------------------------------------ cmd.Parameters.Add(New SqlParameter("@credit_card_nbr", SqlDbType.Char, 18)) cmd.Parameters.Item("@credit_card_nbr").Value = RegCreditcardnumberTXT.Text ----------------------------------- the relevant lines in the procedure in the sql server is ----------------------------------- @credit_card_nbr char(18), ------------------------------------ any help would be great thanks for the help bryan Tag: Connection to paradox 4 from vb.net application ? Tag: 78977
  - 10
    - Strange ADO.NET/Sybase/Sybase OLEDB problem We've recently run in to a very strange problem with a windows service that we have developed in VB.NET and that accesses a Sybase database using the Sybase OLEDB driver via ADO.NET. Every morning about 5am, the windows service checks a specified directory, looking for data export files. If it finds them then it parses them, uploads the contents to a set of temporary tables and then runs a stored procedure (call it MergeData) to merge the needed data from the temporary tables in to the tables used by our main system. It then fires off another couple of stored procedures to prepare report data and then a set of reports are generated. This has all worked fine for a couple of months now. All of a sudden the MergeData stored proc has started to finish prematurely before it has completed all of the processing it is supposed to do. The strange thing is that it doesn't raise any errors back to the windows service. It just seems to stop doing what it was doing before it has completed all of the processing and returns control to the windows service, which then carries on with the other stored proc calls. The even stranger thing is that if we then run the MergeData stored proc directly on the database it works fine and completes all the processing it was supposed to do. However, it gets even stranger. The same installation of the windows service that was used on our live server was installed on our test server, the same data export files were copied across and it works perfectly. The test server uses the same versions of .NET framework, Sybase OLEDB driver and Sybase database. So from the surface the test server looks to have exactly the same software on it - both the software we developed and the third party software we use. Why would a stored procedure not complete when run from an application (without throwing any errors) but work fine when run interactively from the database (without throwing any errors)? And why would the same version of the application on another environment work perfectly. Both the command and connection timeouts on our OLEDB objects are set to 20mins and this timeout is not being reached. The process finishes prematurely within about 9-10 minutes and then continues with the other stored procs. We've had timeout issues before but they have always thrown errors. Has anyone seen this sort of problem using ADO.NET, Sybase or the Sybase OLEDB driver? As you can see it's proving to be frustrating trying to logically conclude where the problem resides. Our code seems fine on the test server but doesn't seem to work on the live server. Therefore you'd think it would be an environment issue, however the MergeData stored proc works fine on the live server when run interactively from the database. Very confusing! :-) Sorry for the crosspost but I haven't a clue which bit of our system the problem resides in. Thanks for any help you can give, Steve Tag: Connection to paradox 4 from vb.net application ? Tag: 78974
  - 11
    - SOLVED: CaseSensitive and Guid / Find() I just though I would share with the group a small problem i ran into then solved after banging my head on the monitor for a few hours. For my dataset i have an XML schema that i load up. Its not quite a strongly typed dataset, i just look for scheama changes with my data adapter. Anyway.... In my dataset the primary key(s) of tables are uniqueidentifiers. Unfortunately some of the columns coming from the database are coming out as varchar() ..don't ask , i want them all as unique ID's. So looking at the XSD schema i'll see entries like <xs:attribute name="Record_GUID" type="xs:string" msdata:DataType="System.Guid, mscorlib, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" /> Loading up data into the dataset works fine. But, I found that some of the fields defined as above are of type System.Guid others are strings. Whats the difference ? If the field was a varchar in the DB and I forgot to run a Cast(Record_GUID as uniqueidentifier) operation on the column, then it shows up as System.String. Now here's the rub... values in the fields are of type string, but when you run a find on the object the compare seems to be binary ...that means it ignores the Table.CaseSensitive setting. So Table.Rows.Find( "2F79A7BA-9AD9-4D3E-835F-780FB2A9CE13") is different than Table.Rows.Find( "2f79a7ba-9ad9-4d3e-835f-780fb2a9ce13") even though the objects in the column are of type string. Anyway, i'm not sure if this is a bug, or if the data adapter that fills the schema should throw an error. I just hope this helps someone save a few tedious hours of debugging. Regards, -eric Tag: Connection to paradox 4 from vb.net application ? Tag: 78967
  - 12
    - Random SQL Timeouts after Web Win2k3 upgrade. I recently upgraded our web server from windows 2000 to windows 2003. Our SQL server is a SQL 2k, Win 2k machine that has not been modified at all. Both have all of the most recent updates/patches. When I upgraded the web machine to windows 2003, we suddenly started having random timeout problems. Every few hours or so, every sql call from our web server would result in a timeout, or at least take a very long time. Then a few minutes later(anywhere from 5 to 30) everything would be fine again. Although it didn't make any sense that SQL would be causing the problem, I did run through the profiler, and everything seemed to okay there. There were no monster, life draining queries running at the start of every down time. So currently, my best guess is that it has got something to do with ado.net. Currently I'm running a strictly ASP site on the server. I've yet to utilize any of the .net functionality on this site, and we have no objects installed other than our eCommerce credit card verifier. I'm using the following connection string to connect to SQL: DRIVER={SQL Server};SERVER=10.10.10.10;NETWORK=DBMSSOCN;UID=username;PASSWORD=password;DATABASE=dbname Any help you can offer will be GREATLY appreciated. I've been spinning my wheels on this for a while. Thanks. Tag: Connection to paradox 4 from vb.net application ? Tag: 78966
  - 13
    - RollbackTransaction is not working with Oracle .Net Data Provider Hi, Could any one pls tell me how this rollback transaction works. I need to call TestProc stored procedure(it has got its own transaction). I want to rollback in my ASP.net code even if the TestProc executes successfully. The follg is the code part which I'm using. It is executing the Rollback stt in the finally block but still it is not rolling back. I'm using Oracle 8.1.7 client and the server is Oracle 7.3 Pls help me!!! Many thanks. ------------------------------------------------------- Dim cmdXX As OracleCommand Dim conOra As New OracleConnection(ConnString) Dim trnOra As OracleTransaction conOra.Open() trnOra = conOra.BeginTransaction() Try ' Get Oracle Connection. cmdRegisterCandidate = New OracleCommand("TestProc", conOra, trnOra) cmdRegisterCandidate.CommandType = CommandType.StoredProcedure With cmdXX .Parameters.Add(New OracleParameter("UserName", OracleType.VarChar, 20)) .Parameters("UserName").Direction = ParameterDirection.Input .Parameters("UserName").Value = sUsername .Parameters.Add(New OracleParameter("IPAddress", OracleType.VarChar, 15)) .Parameters("IPAddress").Direction = ParameterDirection.Input .Parameters("IPAddress").Value = sIPAddress .Parameters.Add(New OracleParameter("Err", OracleType.VarChar, 100)) .Parameters("Err").Direction = ParameterDirection.Output .ExecuteNonQuery() End With Catch ex As Exception WriteToLog(......) Finally trnOra.Rollback() conOra.Close() End Try ------------------------------------------------------- Tag: Connection to paradox 4 from vb.net application ? Tag: 78961
  - 14
    - connection pooling and commits I am using ado.net connection pooling and am calling stored procedures using ExecuteNonQuery. My manager says the following: "if you are using pooling, and you don't do your commit, then the implied transaction will remain open until the connection closes...if someone else jumps into the connection, then they can actually rollback your updates. Is this true? After calling ExecuteNonQuery do I have to manually commit Tag: Connection to paradox 4 from vb.net application ? Tag: 78959
  - 15
    - How to save image in SQL ? Hi ! I´ve a problem saving images in SQL DB. It acccepts images size>=8k and I can´t figure out why ? This is the code I use to upload the images. It comes from ASP.Alliance. I thought it would work properly but ?? Sub UploadImage(sender as object, e as EventArgs) Dim imgstream As Stream = ImageFile.PostedFile.InputStream Dim imgdata(ImageFile.PostedFile.ContentLength) As Byte imgstream.Read(imgdata, 0, ImageFile.PostedFile.ContentLength) Dim objConn as New SQLClient.SQLConnection("Some connection string") Dim cmdText = "INSERT INTO wm_images(Name, Type, Image) VALUES( @imgtitle, @imgtype, @image)" Dim objcmd As New SqlClient.SqlCommand(cmdText, objConn) Dim titleparam As New SqlClient.SqlParameter("@imgtitle", SqlDbType.NVarChar, 100) Dim typeparam As New SqlClient.SqlParameter("@imgtype", SqlDbType.NVarChar, 100) Dim imgparam As New SqlClient.SqlParameter("@image", SqlDbType.Image) titleparam.Value = ImageTitle.Text typeparam.Value = ImageFile.PostedFile.ContentType imgparam.Value = imgdata objcmd.Parameters.Add(titleparam) objcmd.Parameters.Add(typeparam) objcmd.Parameters.Add(imgparam) objconn.Open() objcmd.ExecuteNonQuery() objconn.close() End Sub Has anyone any ideas I would be most greatful ! Regards OM "Myggan" *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! Tag: Connection to paradox 4 from vb.net application ? Tag: 78958
  - 16
    - ado.net , sql server, and asymptotic time complexity We are new to relational databases in general and sql server in particular. Is a search for a record by indexes O(log n)? Is the insert and delete operation O(n log n)? We are assuming that a record update without changing the primary/foreign key values is also O (log n). Correct? thanks in advance jay widman Tag: Connection to paradox 4 from vb.net application ? Tag: 78954
  - 17
    - Data Import & Source Target DataType mismatch problem Hi All, I'm building app that reads data from the text files and then inserts it into SQL server table. When I read the text file into dataset, sometimes data type is not interpreted correctly. I'm using DataSet.Merge method to merge untyped dataset formed by reading the text file with typed dataset that has the schema of the database table. In the case when ODBC text driver does not interprete DataType correctly I compare the target column datatype with source column datatype in the dataset, if they dont match I try to change it but I'm getting exception stating, "column datatype cannot be changed once column has the data " which is perfectly right. Logically this operation should not be allowed but there has to be a way around. Has anybody got a way around this problem. Following are the alternatives I tried but seem to be inappropriate 1. DTS package to import text data. Doesnot work because text file contains odd number of columns, not all columns are imported. Also user edition is required before importing text file into database. 2. Create Dataset that has matching schema as that of table and clone source dataset row by row. This gets really expensive. I'm dealing with on an average 70MB of text data at a time. Can anybody suggest alternatives to this. Any help is really appreciated. Thanks, -HKM Tag: Connection to paradox 4 from vb.net application ? Tag: 78953
  - 18
    - Matching 2 DataSets Hi all, I have a function that have a dataset in argument. I have an other ds from a particular dataset (dsProduct) Is there any way to match the two dataset ? Example : ds1 : columns are prod_cod_prod_desc, prod_usr dsProduit : prod_cod, prod_usr dsProduit = fct(ds1) Now I can use the right column of my dataset ( no error if column does'nt exist !) Is a such function fct or any way exist ? Thanks, Jeff Tag: Connection to paradox 4 from vb.net application ? Tag: 78949
  - 19
    - MS Access Question Hi, Does MS Access have a valid timestamp data type, or must I use the datatime data type instead? Also how do I autogenerate these values? Thanks, Roshawn Tag: Connection to paradox 4 from vb.net application ? Tag: 78947
  - 20
    - What is the application path for class library assembly? I am trying to create a xml config file for my class library assembly. The problem is that I can't seem to find out where the application will be running. I want to place the xml file in the /bin directory where the assembly would be. I tried Application.StartupPath but it does not work. Any suggestions? Tag: Connection to paradox 4 from vb.net application ? Tag: 78941
  - 21
    - ADOMD? Hi there! Are there any smart ways to read data from olap, lika with ADOMD? Tag: Connection to paradox 4 from vb.net application ? Tag: 78940
  - 22
    - How do I fetch data ? After an insert in my database using a OleDbDataAdapter, how can I fetch data ? I need to fecth data because when I don't have any data in one of my table and I add a new row in my Table, then I update it, it give me a concurrency exception. It don't give me any exception if I had a record before I fill my DataSet. Thank you for your help Tag: Connection to paradox 4 from vb.net application ? Tag: 78934
  - 23
    - passing array to stored procedure hi al can u plz give me an example to passing array to stored procedure for sql serve than Mukunda Tag: Connection to paradox 4 from vb.net application ? Tag: 78923
  - 24
    - Export Access to Excel Hi How to export Access table to Excel sheet programatically Thanks. Tag: Connection to paradox 4 from vb.net application ? Tag: 78919
  - 25
    - Master/Detail relationship using ComboBoxes Hello! I'm wondering how to do Master/Detail relationship using ComboBoxes. I'm using VB (2003). I have DataSet containing tables called as 'State' and 'City' (not really 'State' and 'City' but idea is the same and easier to understand). I want user to select first 'State' of the ComboBox containing states and then the ComboBox containing cities should contain only cities for that selected state. I want to save only ID (.ValueMember) of the state and city to the database table. How to do this when using DataBinding? At the moment code looks like this ... '// *** 'State' ComboBox *** cbState.DataSource = ds.Tables("States") cbState.DisplayMember = "State" cbState.ValueMember = "ID" cbState.DataBindings.Add(New Binding("SelectedValue", myDataTable, "StateID")) '// *** 'City' ComboBox *** cbCity.DataSource = ds.Tables("Cities") cbCity.DisplayMember = "City" cbCity.ValueMember = "ID" cbCity.DataBindings.Add(New Binding("SelectedValue", myDataTable, "CityID")) ... and it's working fine, but I need to implement this selection relationship somehow. It should work also when myDataTable position changes - propably this is possible to do? -- Thank you in advance! Mika Tag: Connection to paradox 4 from vb.net application ? Tag: 78914
- Next
  - 1
    - replacement for SQLDMO?? Hi there, i am trying to find out what is the replacement in .NET for the SQLDMO object which reads system objects and properties from SQL Server databases, eg, stored procedures, tables, views, s/proc parameters,etc...? thanks, Tag: Connection to paradox 4 from vb.net application ? Tag: 78903
  - 2
    - How do I create a table and an Access database using .NET and C#? Tag: Connection to paradox 4 from vb.net application ? Tag: 78900
  - 3
    - Microsoft.Jet.OLEDB.4.0 not registered Hi, I get the errormessage "The Microsoft.Jet.OLEDB.4.0 provider is not registered on the local machine" trying to run a dot.net program. I'm running Windows 2000, English version. By a mistake I first installed MDAC 2.8 Norwegian version. I then installed MDAC 2.8 English version, but get the same error message. I have also tried MDAC 2.6 with no luck. Any suggestions to correct this problem will be appreciated ! Tnx Tag: Connection to paradox 4 from vb.net application ? Tag: 78899
  - 4
    - Property Value Changes Value between calls Property Value Changes Value between calls In frmTopicFromStart I call a procedure in clsDataChor to retrieve the autoincrementing ID for the topic. I place it in a textbox and also put it in a public variable in btnSaveTabGeneral: clsDChor.TransferID(txtID, iTopicID) MsgBox("btn savetabgeneral " & iTopicID.ToString) The message box shows the correct value(according to the access data base, 71, as of the last run. In another tab I select topic test and click the QuickWordButton. The msgbox in quickword event handler also shows 71: Dim frm As New frmQuickWord frm.sQuick = str1 MsgBox("btnquickword " & iTopicID.ToString) frm.KSID = iTopicID frm.ShowDialog() KSID is a property in frmQuickWord and also shows 71, as it should, in the form_load event: Private Sub frmQuickWord_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load txtQuickWord.Text = sQuick.Trim cnQWKS.ConnectionString = gstrConn MsgBox("quickwordload " & KSID.ToString) End Sub Now the problem comes. There's a textbox with the selected text from the quickword button in frmtopicfromstart: This is used to add a row to the keywordsets table, the keywords table, and the searchphrase table. No problem: daQWKS.Fill(DsQWKS1, "KeywordSets") Dim tblKS As New dsQWKS.KeywordSetsDataTable Dim rowKS As dsQWKS.KeywordSetsRow Try rowKS = tblKS.NewKeywordSetsRow() Catch ex As Exception MessageBox.Show("Type = " & ex.GetType.ToString & vbCr & "Message = " & ex.Message) End Try rowKS.Active = True rowKS.KeywordSet = txtQuickWord.Text 'sQuick 'rowKS.ID = -1 Try tblKS.AddKeywordSetsRow(rowKS) daQWKS.InsertCommand = New OleDb.OleDbCommand("INSERT INTO KeywordSets(Active, KeywordSet) values (?,?)", cnQWKS) daQWKS.InsertCommand.Parameters.Add("@Active", OleDb.OleDbType.Boolean, 2, "Active") daQWKS.InsertCommand.Parameters.Add("KeywordSet", OleDb.OleDbType.VarWChar, 16, "KeywordSet") AddHandler daQWKS.RowUpdated, AddressOf OnRowUpDated Catch ex As Exception MessageBox.Show("Type = " & ex.GetType.ToString & vbCr & "Message = " & ex.Message) End Try Try Dim intModified As Integer intModified = daQWKS.Update(tblKS) Dim sOutput As String sOutput = "Modified " & intModified & " KeywordSet(s)" 'MessageBox.Show(sOutput, "Update succeeded!", MessageBoxButtons.OK, MessageBoxIcon.Information) Catch ex As Exception MessageBox.Show("Type = " & ex.GetType.ToString & vbCr & "Message = " & ex.Message) End Try daQWK.Fill(DsQWKS1, "Keywords") Dim tblK As New dsQWKS.KeywordsDataTable Dim rowK As dsQWKS.KeywordsRow Try rowK = tblK.NewKeywordsRow Catch ex As Exception MessageBox.Show("Type = " & ex.GetType.ToString & vbCr & "Message = " & ex.Message) End Try rowK.Active = True rowK.Keyword = txtQuickWord.Text 'sQuick 'rowKS.ID = -1 rowK.KeywordSetID = KSID Try tblK.AddKeywordsRow(rowK) daQWK.InsertCommand = New OleDb.OleDbCommand("INSERT INTO Keywords(Active, Keyword,KeywordSetID) values (?,?,?)", cnQWKS) daQWK.InsertCommand.Parameters.Add("@Active", OleDb.OleDbType.Boolean, 2, "Active") daQWK.InsertCommand.Parameters.Add("Keyword", OleDb.OleDbType.VarWChar, 16, "Keyword") daQWK.InsertCommand.Parameters.Add("KeywordSetID", OleDb.OleDbType.Integer, 4, "KeywordSetID") Catch ex As Exception MessageBox.Show("Type = " & ex.GetType.ToString & vbCr & "Message = " & ex.Message) End Try Try 'Dim intModified As Integer 'intModified = daQWK.Update(tblK) 'Dim sOutput As String 'sOutput = "Modified " & intModified & " Keyword(s)" 'MessageBox.Show(sOutput, "Update succeeded!", MessageBoxButtons.OK, MessageBoxIcon.Information) Catch ex As Exception MessageBox.Show("Type = " & ex.GetType.ToString & vbCr & "Message = " & ex.Message) End Try daQWSP.Fill(DsQWKS1, "SearchPhrase") Dim tblSP As New dsQWKS.SearchPhraseDataTable Dim rowSP As dsQWKS.SearchPhraseRow Try rowSP = tblSP.NewSearchPhraseRow Catch ex As Exception MessageBox.Show("Type = " & ex.GetType.ToString & vbCr & "Message = " & ex.Message) End Try rowSP.Active = True rowSP.SearchPhrase = txtQuickWord.Text 'sQuick 'rowKS.ID = -1 rowSP.KeywordSetID = KSID Try tblSP.AddSearchPhraseRow(rowSP) daQWSP.InsertCommand = New OleDb.OleDbCommand("INSERT INTO SearchPhrase(Active, SearchPhrase,KeywordSetID) values (?,?,?)", cnQWKS) daQWSP.InsertCommand.Parameters.Add("@Active", OleDb.OleDbType.Boolean, 2, "Active") daQWSP.InsertCommand.Parameters.Add("SearchPhrase", OleDb.OleDbType.VarWChar, 16, "SearchPhrase") daQWSP.InsertCommand.Parameters.Add("KeywordSetID", OleDb.OleDbType.Integer, 4, "KeywordSetID") Catch ex As Exception MessageBox.Show("Type = " & ex.GetType.ToString & vbCr & "Message = " & ex.Message) End Try Try 'Dim intModified As Integer 'intModified = daQWSP.Update(tblSP) 'Dim sOutput As String 'sOutput = "Modified " & intModified & " Keyword(s)" 'MessageBox.Show(sOutput, "Update succeeded!", MessageBoxButtons.OK, MessageBoxIcon.Information) Catch ex As Exception MessageBox.Show("Type = " & ex.GetType.ToString & vbCr & "Message = " & ex.Message) End Try There is one more table to update, the KeywordSetAssignments table, which tells me in which table the keywordset and other tables are assigned.(I do an indexing of all tables elsewhere). Here is part of the code for the last table: daKSTA.Fill(DsQWKS1, "KeywordSetAssignments") Dim tblKSTA As New dsQWKS.KeywordSetAssignmentsDataTable Dim rowKSTA As dsQWKS.KeywordSetAssignmentsRow Try rowKSTA = tblKSTA.NewKeywordSetAssignmentsRow Catch ex As Exception MessageBox.Show("Type = " & ex.GetType.ToString & vbCr & "Message = " & ex.Message) End Try rowKSTA.BeginText = 0 Dim frm As New frmTopicFromStart rowKSTA.TopicID = KSID MsgBox("Btn save and close " & " TopicID " & rowKSTA.TopicID.ToString) rowKSTA.KeywordSetID = KSID The msgbox showed 111, and naturally the update for this table failed because there wasn't a corresponding table in topics. This happens every time and it's frustrating. Similar code works in many places elsewhere in the app. Can anybody tell me what's wrong. polynomial5d Tag: Connection to paradox 4 from vb.net application ? Tag: 78898
  - 5
    - How To Make A 'Safe' Flexible Query? I'm just about to make Yet Another Search Form For A DB Application. I'd just like to ask.. if I were able to search based upon a different number of columns, say sometimes firstname, sometimes lastname, sometimes both? what's the best way to create a query? Definetly not strSelect="Select * from Authors where " & QueryCol1 & "=@QueryValue1 and " & QueryCol2 & "=@QueryValue2" Or something to that matter right? Since that's just asking for some sort of sql injection attack to happen.? Thanks. Tag: Connection to paradox 4 from vb.net application ? Tag: 78897
  - 6
    - Distributed Transaction Please give your valuable suggestions on the following: 1. Is it possible to support Distributed Transaction (Two Phase Commit) without COM+ or MTS "using C#"? 2. Can I use the MS DTC sdk to achieve Two phase commit from C# Code? If yes can you tell me where I will get the related materials (MS DTC SDK Reference Manual) Thanks in advance. Tag: Connection to paradox 4 from vb.net application ? Tag: 78893
  - 7
    - Concurrency with DataSet & Command Object Hi Guy's Here Elan, I Want to know about the Concurrency Implimentation in ADO.NET. See Command Object useing Pessimistic Concurrency, and Dataset using(Impliment) Optimistic Concurrency, Why ? Please Reply me ! Thanks and Regards, Elankathir Tag: Connection to paradox 4 from vb.net application ? Tag: 78892
  - 8
    - Very Slow Performance Hi, I used frontPage 2000 to build my websites which is hooked to MS SQL server 2000. Once I create an application from frontpage with the appropriate database settings and save it and finally Click "preview in web Browser", It takes too much time to display. I don't know when it will be displayed. The internet explorer 5's progress bar shows a fast performance intially and at some stage doesn't move and stays static. Once I stayed for over 1 hour to witness the result, but was in vain. It was still staying static. (note: Internet Speed is averagely faster which is using an ADSL connection) When I run my CGI applications, IE gives a "Internal Server Error" at some times or else produces "XML Rowset not found". What might be the problem? Have anyone experianced this problem? note that my CGI applications are made using Borland Delphi 5. Tag: Connection to paradox 4 from vb.net application ? Tag: 78887
  - 9
    - removing items from a combobox Hi I wanted to know if it is possible to remove the items that are in a combobox. I only want to remove those items that are in an array that i have E.g if my combobox contains and my array contains I want the values 2 and 4 removed. Is this possible If it is poss how do i go about doin this Thank u Tag: Connection to paradox 4 from vb.net application ? Tag: 78883
  - 10
    - Date value Hi How can I have the current system date and time in this format "07/01/2004 00:42:59"? Can I store it in a date field in an System.Data.OleDb.OleDbType.Date field? Thanks Regards Tag: Connection to paradox 4 from vb.net application ? Tag: 78882
  - 11
    - Parent/child table addnew() problem in BindingContext. Help hi all I have parent/child tables fields bind to all kind of controls and I have datarelation setup between the parent and child tables, but when I do addnew() on the child bindingContext, ADO.NET won't add the parent foreign key to the newly added child row, what am I missing here? Kevin Tag: Connection to paradox 4 from vb.net application ? Tag: 78880
  - 12
    - Connection pool close timeout It appears that with ADO.NET, an entry is removed from the connection pool after 5 minutes of being not used. At least this is how it appears as we watch the SPIDs on SQL Server. This used to be 1 minute in ADO. Can anyone confirm this 5 minute value? Tag: Connection to paradox 4 from vb.net application ? Tag: 78873
  - 13
    - Please help with this Error: Hi, I have an error when I fill the dataadapter with : Me.OleDbDataAdapter1.Fill(Me.DataSet11) Here is the error: An unhandled exception of type 'System.Data.OleDb.OleDbException' occurred in system.data.dll What is the problem? Tks JFB Tag: Connection to paradox 4 from vb.net application ? Tag: 78866
  - 14
    - test test Tag: Connection to paradox 4 from vb.net application ? Tag: 78865
  - 15
    - Odd connection issue - (yes I'm running in mixed mode authentication) Here is the scenario... - There are two sql servers: "Production" and "Staging". PLEASE READ THIS BEFORE REPLYING --> Both SQL servers are set to "SQL Server and Windows" mixed authentication mode. (I have verified this multiple times). Both Sql Servers have Named pipes and TCP/IP port 1433 installed under network client configuration - There is a development machine: "Development". Any machine we try to connect from using the following has the same behavior however. Problem: Cannot connect from ASP.NET app running on "Development" under the IUSER account to the "Staging" server using SQL Server authentication. Here is the connection string... "Server=Staging; Database=V2Staging; User=sa; Password=development" It throws the exception: System.Data.SqlClient.SqlException: SQL Server does not exist or access denied. at System.Data.SqlClient.ConnectionPool.GetConnection(Boolean& isInTransaction) at System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnec tionString options, Boolean& isInTransaction) at System.Data.SqlClient.SqlConnection.Open() at SqlSecurityTest.WebForm1.Connect(String connectionString) in c:\inetpub\wwwroot\sqlsecuritytest\default.aspx.cs:line 57 at SqlSecurityTest.WebForm1.Page_Load(Object sender, EventArgs e) in c:\inetpub\wwwroot\sqlsecuritytest\default.aspx.cs:line 36 Oddity 1: We CAN establish a connection from the same ASP.NET app on "Development" running under the IUSER account to the "Production" using SQL Server authentication.. Here is that connection string... "Server=Production; Database=V2Production; User=sa; Password=production" Oddity 2: We CAN establish connections from the ASP.NET app on "Development" running under the NT AUTHORITY\NETWORK SERVICE account to BOTH servers using SQL Server authentication.. I have boiled this down to this question... Why should the windows account the application is running under imapct connectivity to a SQL Server at all when using SQL Server authentication and both sql servers are running in mixed authentication mode? This has been a thorn in my side for many days. I want to solve this problem and will set up a web page with screen shots or collect any information you might find useful to help me solve this problem. Thank you for your help, -Thomas Kadlec MY_NOSPAM_EMAIL_IS_tmek_2001@hotmail.com Tag: Connection to paradox 4 from vb.net application ? Tag: 78862
  - 16
    - Going Crazy with this! Hi Again Group, Sorry to trouble you all again but i`ve been looking at this problem for 2 weeks now and just don`t seem to be able to grasp how to create a relationship in VB.NET with ADO.NET. I have the following: Private Sub frmMainMenu_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load Try odaArcirisUsers.Fill(dsArcirisUsers) Dim relArcirisUsers As New DataRelation("dsArcirisUsers", dsArcirisUsers.Tables(0).Columns("SitesID"), dsArcirisUsers.Tables(1).Columns("Sites Name")) dsArcirisUsers.Relations.Add(relArcirisUsers) Catch Ex As Exception Console.WriteLine("Error: " & Ex.Message) MsgBox("Error: " & Ex.Message) End Try dgdArcirisUsers.Expand(-1) dgdArcirisUsers.NavigateTo(0, "ArcirisUsers") End Sub I have 2 Tables: 1 is My ArcirisUsers Table witch has the following Feilds: ArcirisUserID (PrimaryKey) POSID USERNAME BOMID SITEID Table 2 is My Sites IT which has: SitesID(PrimaryKey) SiteName Company Telephone In my project I want to be able to update the feild on my ArcirisUsers Table via Text Box`s. However I would like to have my SITEID on my Arciris Table lookup the SITENAME in my Sites Table via a ComboBox, as it is doing in access by a look up. How do I do this im so confused, i`ve looked everywhere and seem to get confused all the more, do i need 2 Dataadapters, and 2 Datasets of do i have it all in the same Dataset? Please Could someone help me? Many Thanks Regards Merlin Tag: Connection to paradox 4 from vb.net application ? Tag: 78858
  - 17
    - Insert a file into a SQL fields using VB.net Hi all ! I am new in this NewsGroup ! My question is:: I using VB.net and i want to insert into a fields(SQL server) a picture who are on my hard drive! Can someone help me thx ! Tag: Connection to paradox 4 from vb.net application ? Tag: 78854
  - 18
    - Newbie Problems Updating SQL I am having some problems updating an SQL view with a button click. Could someone point me in the right direction? This code runs without any errors, but the sql command never makes it the the SQL server. I'm not using a parameters collection or anything, basically because I am not sure how to map textboxes to SQL Parameters. If there is a better approach, please let me know... Thanks, Aaron Public Sub Button4_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button4.Click 'Dim sqlUpdateCommand1 As New SqlClient.SqlCommand() Dim con con = Me.SqlConnection1.ConnectionString Dim nID As Integer = Me.GetSelectedRecordID(Me.DataGrid1, DataSet11, "Searches_Activity") If nID = 0 Then Return End If Me.SqlUpdateCommand1.CommandText = "UPDATE Searches_Activity SET Activity_Activity_CD = '" & txtACD.Text() & "', Activity_Result_CD = '" & txtRCD.Text() & "', Activi" & _ "ty_Date = '" & txtActDate.Text() & "', Activity_FollowUp = '" & txtFollowUpDate.Text() & "', Activity_Notes = '" & txtNotes.Text() & "', Activity_Notes_Confidential = '" & txtConfNotes.Text() & "'," & _ " App_Name_Full = '" & txtFullname.Text() & "', App_Title_Long = '" & txtTitle.Text() & "', App_Company = '" & txtCompany.Text() & "', App_Phone = '" & txtphone.Text() & "', App_Cell = '" & txtAppCell.Text() & "', App_" & _ "BPhone = '" & txtBPhone.Text() & "', App_Salary = '" & txtAppSalary.Text () & "', App_TotalComp = '" & txtCompensation.Text() & "', App_Resume = '" & txtResume.Text() & "', App_Bphone_Ext = '" & txtWorkExt.Text() & "', App_Reg" & _ "ion_CD = '" & txtRegCode.Text() & "' where activity_ID = " Me.SqlUpdateCommand1.CommandText = Me.SqlUpdateCommand1.CommandText & nID Dim UpdateSQL UpdateSQL = Me.SqlUpdateCommand1.CommandText 'SqlDataAdapter1.Update(DataSet11, "Table") SqlDataAdapter1.Update(DataSet11) End Sub Tag: Connection to paradox 4 from vb.net application ? Tag: 78846
  - 19
    - DataColumn Expression Hi, I have a DataSet with some DataTables. I would like to set the Expression column of on DataTable to the value of another column in anothe DataTable. Is there any way to do it ? Example : I have 3 tables : Bird, Dog, Cat I create a column called Bird_Name in Cat table. Then I want to do somethinf like : DataSet.Table("Cat").Column("Bird_Name").Expression = "Bird.Name" Thank you for your help. Tag: Connection to paradox 4 from vb.net application ? Tag: 78841
  - 20
    - DataGrid and DataSet information Hi, I have 2 parents tables (example : Car and Road). That Car can use n Roads and Road can be use by n Cars. In that case, I need a middle table because it is a n-to-n relation. So we had a Link_Car_Road table with the primary key of Road and Car as foreign key in Link_Car_Road. So if I want to design a form to show the car informations with all the road corresponding to that car, I need to use a DataGrid (I think, because it seems impossible with a ListBox). I am able to show the car ifnromations with the Link_Car_Road information, but I am unable to get the Road with my DataGrid. To do it, I set the DataSource of my DataGrid to my DataSet and my CalueMember to Car.Link_Car_Road_Relation. So when I select a new car record, I get all the child rows of Link_Car_Road that correspond to that car. IS there any way to get the Road information instead the middle table informations when I select a new car row ? Thank you for your help. Tag: Connection to paradox 4 from vb.net application ? Tag: 78826
  - 21
    - Execute a View from ADO.NET:Failed to enable constraints... Hi Everybody I have a Problem getting Data out of a View...I always get: "Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints. " I have no Idea what the error might be... my view: SELECT DISTINCT dbo.tb_Verkaeufer.ver_Nummer, dbo.tb_Verkaeufer.ver_GueltigBis, dbo.tb_Verkaeufer.ver_AenderungDurch, dbo.tb_Verkaeufer.ver_Name1, dbo.tb_Verkaeufer.ver_Postfach, dbo.tb_Verkaeufer.ver_Zusatzangaben, dbo.tb_Verkaeufer.ver_Strasse, dbo.tb_Verkaeufer.ver_PLZ, dbo.tb_Verkaeufer.ver_Ort, dbo.tb_Verkaeufer.ver_Kurzname, dbo.tb_RepositoryCodes.rec_Beschreibung, dbo.tb_Verkaeufer.ver_Telefon, dbo.tb_Verkaeufer.ver_Fax, dbo.tb_Verkaeufer.ver_Email, dbo.tb_Verkaeufer.ver_Sperrcode, dbo.tb_Verkaeufer.ver_ProvisionDirekt, dbo.tb_RepositoryCodes.rec_Sprache FROM dbo.tb_Verkaeufer LEFT OUTER JOIN dbo.tb_RepositoryCodes ON dbo.tb_Verkaeufer.ver_Sprachcode = dbo.tb_RepositoryCodes.rec_Code WHERE (dbo.tb_RepositoryCodes.rec_ObjektTyp = 'tb_Verkaeufer') AND (dbo.tb_RepositoryCodes.rec_Spaltenname = 'knd_Sprachcode') this view gets some rows and every row is in there 3 times with a different languageID called "rec_Sprache". I now want to specifiy the select command when i execute the qury out of ado.net. my code looks as follwo: ... daVerkaeuferDetailsAll.SelectCommand.CommandText += @" WHERE ver_Nummer = @VER_Nummer AND ver_GueltigBis = @VER_GueltigBis AND rec_Sprache = @SprachID"; daVerkaeuferDetailsAll.SelectCommand.Parameters.Add("@VER_Nummer",ver_Nummer); daVerkaeuferDetailsAll.SelectCommand.Parameters.Add("@VER_GueltigBis",ver_GueltigBis); daVerkaeuferDetailsAll.SelectCommand.Parameters.Add("@SprachID",sprachID); daVerkaeuferDetailsAll.Fill(dt); ... what am i doing wrong... If i copy the qury string out of the selectcommand object after it is created an i let it run in the query analyzer...it returns exactly one row with the right languageid... thanks for your help Plunaldo Tag: Connection to paradox 4 from vb.net application ? Tag: 78810
  - 22
    - how to select by a binary column? Hello, I have a binary column in a .NET (C#) in-memory DataTable, and I wish to make a selection based (among others) on this column. It's easy to do such a thing on eg MS-SQL, but I want to do it in .NET's in-memory data. I tried to format the byte array in many ways (including the 0x0001 format of MS-SQL, but also 000-0001, {000-001}, [000-001], with or without quotes, but no way worked. Any idea how to do that? Please don't question why I would want to do that ;O) If I wasn't clear: DataRow[] matches = dsMyDataSet.Select("Column1 = " + value + " and Column2 = " + value2); where value2 is in fact a byte[], and Column2 contains a base64binary in my in-memory table. Thank you, emmanuel Tag: Connection to paradox 4 from vb.net application ? Tag: 78809
  - 23
    - Validating in a datagrid Hi All I'm trying to validate some values in a datagrid so that if the user does not fill in all required fields the focus remains in the row until they complete the requirements or cancel the entry. Presently I'm using the DataRowChangeEventArgs to check the columns for the required values and then ending the edit and rejecting the changes if they fail. However they are not restrained in the record so they can still leave the row uncompleted. Anybody know how I can hold the user in the same row until all requirements are met Thanks Keds Tag: Connection to paradox 4 from vb.net application ? Tag: 78800
  - 24
    - Data View - explanation Couold you please point me to some web sites where I could find more about Data Views and how to use them? Thanks Tag: Connection to paradox 4 from vb.net application ? Tag: 78795
  - 25
    - Insert ASCII string with Oracle client Hi, I want to insert an ASCII string using ODP.NET. Example string sql = "INSERT INTO Employee(id, name) VALUES(1, :name)" // name is VARCHAR2(40) OracleCommand cm = new OracleCommand(); OracleParameter param = cm.CreateParameter(); param.ParameterName = "name"; param.DbType = DbType.AnsiString; param.Size = 40 param.Value = ".Net Framework Unicode string."; // 30 unicode characters cm.Parameters.Add(param); I want to insert only ASCII string, but, because .Net string is Unicode string, ".Net Framework Unicode string." got 30 * 2 = 60 bytes AND Oracle say that my string is too long. How can I fix this ? Thanks -- Vi Tag: Connection to paradox 4 from vb.net application ? Tag: 78793

Hi,

How can I connect to paradox 4.0 from my vb.net application ? Any sample
code ?

Help me !

Re: Connection to paradox 4 from vb.net application ? by ItsMe

ItsMe
Tue Feb 03 21:42:45 CST 2004

This is an answer...

Public sDBString As String = "Driver={Microsoft Paradox Driver (*.db )};" &
_
"DriverID=538;" & _
"Fil=Paradox 4.X;" & _
"DefaultDir=z:\;" & _
"Dbq=z:\;" & _
"CollatingSequence=ASCII"

oCon = New System.Data.Odbc.OdbcConnection(sDBString)
oCon.Open()

"ItsMe" <kkk@yahoo.com> wrote in message
news:%23Bd6LVs6DHA.2760@TK2MSFTNGP09.phx.gbl...
> Hi,
>
> How can I connect to paradox 4.0 from my vb.net application ? Any sample
> code ?
>
> Help me !
>
>

Top