We are working on an ASP.Net/VB.Net application using Enterprise Library for our data access (DAAB).
We are trying to store DateTime values in an Oracle Date field. However, the precision is being lost. Currently only the year, month, and date are being stored. We need better precision than this.
Oracle Dates are supposed to "includes not just the month, day, and year, but also
the hour, minute, and second. "
Is there a need to explicitly close the connection in this Microsoft Data Access Application Block for .NET? i am encountering timeout expired pooling errors in the sql server 2000. I am wondering if the unclosed connection is the problem
View 2 RepliesI have an error ERROR [22018] [Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression. and I've been trying to solve this but unfortunately I couldn't get the hack of this error. I'm a newbie in dotNet.
Public Sub LogInContinue(ByVal senter As Object, ByVal e As EventArgs)
Dim LibDS As DataSet = New DataSet
Dim LibDA As OdbcDataAdapter = New OdbcDataAdapter("SELECT * FROM tblUserAccount WHERE Uname='" & txtUserName.Text & "'", LibConn)
[code]......
I'v designed a ms access database table with one field having Datetime datatype. I can Insert data into it from vb.net front end by trns_dt DateTime.Now.DateBut when I fetch records from the tableand assign the dataset datasource as da, it shows datatype mismatch error.
daleDbDataAdapter("SelectDaily_Transactiondtp_from_dt.value dtp_To.value con)
dsDataSet
[code].....
I exported xlxs files to sql server using oledb data reader. I'm using visual studio 2005. [code]
View 3 RepliesI have an error "ERROR [22018] [Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression". I am using VBdotNet2005 and MS Access as its database, and I can't really get the hang of this error.
View 8 RepliesI have multiple documents stored in Attachment data type in Access database. UsingDataReader, I need to read multiple attachments along with their file name and store them on the file system
View 1 RepliesI am using logging application block for EL 5.0. I defined listener like below.
<add name="FlatFile TraceListener" type="Microsoft.Practices.EnterpriseLibrary.
Logging.TraceListeners.FlatFileTraceListener,
Microsoft.Practices.EnterpriseLibrary.Logging"
[Code].....
I am building a VB 2008 Express Edition application.I have built a database (with a single table) using SQL Server Compact 3.5 and have connected it to the project. I am able to view and edit the data using a DataGridView on a second form (tutorial made this very easy). I need to work with the data in the table within the application. how to easily load the entire table into an array or even read the table a row or cell at a time so that I can make all of the data available for manipulation within the application (the tutorials only seem to show how to display the data).
View 7 RepliesI have a VB6 application which has been running succesfully for years under XP, however under Vista data loss has been observed.It appears that if the app is run 'as administrator' then it connects to the correct database file, however if the app. is not run as administrator then vista creates a copy of the database (no idea where) - hence I end up with 2 versions of the database.
In fact I can delete the database file entirely and the app. still works fine because vista is using it's own copy - the problem is how do I back up this 'vista copy' when I can't find it (search doesn't find it).
I am currently working on a custom data type, and wanted to implement a = operator.
I data type is a nullable date that returns a string value if date was supplied.
I want to allow the variable to be set like this
Dim nd as New NullableDate nd = Today Does anyone know how this can be done, or can anyone point me in the right direction?
I'm currently trying to convince management of the need to port one of our applications to .NET. The application has grown to be a bit of a monster in Access (backend in SQL), with 700 linked tables, 650 forms/subforms, 130 modules and 850 queries.
I pretty much know all the major benefits of doing this, but now need to look at how this can be achieved technically, so I can put a project plan together.So, my plan was to convert the queries into stored procedures and/or views on the backend and re-write the forms in WPF or WinForms.
Now, the code is where I come unstuck. Is it possible to packaged up the code behind and modules into dlls and consume them whilst it is slowly ported to VB/C#?
What we can't be left with is half an application in VB/C# and half in Access, it must 'appear' to all be one application, even half way through the migration.EDIT: Just some more info about what we do and why we're looking at moving away from Access.We are essentially an ISV and the Access application is our main product. This application has been developed over a period of 15 years, by many, many developers on an ad hoc basis. There is no documentation for this application.
We also have problems with getting branching in SCC to work properly, so we've currently got 4 or 5 code bases for the half a dozen clients we have. On top of that, all the testing we do is completely manual, which you can imagine is very labour intensive, and only scratches the surface of what really needs to be tested.We're currently looking to expand, and have a number of sales leads that are in the final stages. I'm worried that with these new sales, we're going to be swamped with support and testing, and that this application is going to become even more entangled an buggy.
I'll also add to this the fact that we're just about to enter the spec phase of a brand new product, which is almost certainly going to be built in .NET. If we were to rewrite the Access application in .NET, then the people we use for that can go straight on to this new development. If we were to stay in Access, then we'd have to get some new Access people in, whom would have to be retrained once we start the new development.
So essentially it has come down to two choices, major refactoring work in Access to try and 'organise' the code a bit better, and those of you who have suggested culling parts are most probably right; I'm sure there are parts that are no longer used. However, I fear that if we stay in Access we still won't be able to build in effective testing and we still won't have proper SCC branching, which will lead to support continuing to be a nightmare, and any future developments on this product makings things worse. Either way there is a lot of work that we're about to embark on, which is either going to be done in Acces, or .NET.
Error msg - Namespace or type 'Data' for the Imports 'Microsoft.ApplicationBlocks.Data' can't be found. How do I fix this error. I tried adding a reference but it is not listed in the references.
View 2 Replieshow to connect to a database and retrive data in a table using oledb data provider in Microsoft access?
View 2 RepliesRemove a record from a Access database using a VB?I have created a small database in Access,then using VB 2008 Express Edition, created a link between Vb form and Access When I try and Add then Save a record, the information is not in the database.But I can't remember how to:-*Add a record*Save the record*Edit an existing record*Find a record in the databas of interest, is it possible for the add button to be clicked when the VB form loads, and if so how do I achieve this
View 2 RepliesThe backend uses Microsoft SQL Server 2000 runtime engine with an MSDE database engine. The frontend however is built with Microsoft VB.Net and the dotnet framework. I'm not sure how this changes things when trying to extract the tables. I've found the folders where SQL-notepad looking files are contained but am not sure what my next step should be. TBH i dont know what version of Microsoft VB.Net framework is used but the system is quite old and was made in 2001. If you haven't noticed from my poor phrasing i'm a bit of a newb when it comes to programming. If there is a particular programming code i have to put in i wouldn't really know where to put it.
View 3 Repliesi've started work at this small charity and they need me to extract the tables and data from an old buggy system and create a new Access system but i'm having trouble extractig the data.The backend uses Microsoft SQL Server 2000 runtime engine with an MSDE database engine. The frontend however is built with Microsoft VB.Net and the dotnet framework. I'm not sure how this changes things when trying to extract the tables. I've found the folders where SQL-notepad looking files are contained but am not sure what my next step should be. TBH i dont know what version of Microsoft VB.Net framework is used but the system is quite old and was made in 2001.
View 2 RepliesI am working on a VB2008 Express application that makes used of the office interop access. The exact code is:
[Code]...
I am using the publish wizard in VB 2010 Professional for deployment as I tried the InstallShield and the Standard Build and cannot get support. My last resort is this wizard. Please help me I am getting the following 2 warnings. I downloaded MDAC 2.8 SP1 for warning 2 and after I run the program it doesn't upgrade and appear in VB2010. How can I install it in VB2010 Pro. Also How can I get the .Net.Framework.2.0 installed.
Warning 2 The 'SAP Crystal Reports Runtime Engine for .NET Framework 4.0' item selected requires 'Microsoft.Data.Access.Components.2.8'. Select the missing prerequisite in the Prerequisites Dialog Box or create a bootstrapper
package for the missing prerequisite. SendGlobalMobileAdvertisingBlasts
[code]....
Is it possible to use microsoft access database for Windows mobile application and save this mdb file locally in the pocket pc?because im trying to make an application to connect to mdb database but this imports seems to be not working.
HTML
Imports System.Data.oledb
oledb is not a member of system.data. why?
I've got a method which takes some parameters and generates some XML to be sent to an [archaic] web service.
[Code]...
I have a problem regarding to the date and time.im using combobox for the date and i make of variables..this is my code.[code]i dont know what is my error..but my syntax to insert data its correct..
View 3 RepliesI am trying to learn how I can enter data into a Microsoft Visual Basic 2010 TextBox on a form and when I Tab to the next TextBox, the data from the first TextBox is automatically appended to a Microsoft Access 2007 table. For this question, no other controls or objects are necessary.
View 5 RepliesI'm currently doing a project that includes access 2010 My question will be what driver can I use for an access 2010 *.accdb type file? For a *.mdb it works perfectly well with
ConnString ="Driver={Microsoft Access Driver (*.mdb)};Dbq=" & Application.StartupPath & "\CITSDB.mdb;Uid=Admin;Pwd=123;"
But, when I changed the mbd to accdb:
ConnString ="Driver={Microsoft Access Driver (*.accdb)};Dbq=" & Application.StartupPath & "\CITSDB.accdb;Uid=Admin;Pwd=123;"
It resulted in errors:
ERROR[HY000][Microsoft][ODBC Microsoft Access Driver]Could not find file '(unknown)'.
ERROR[IM006][Microsoft][ODBC Driver Manager]SQLSetConnetAttr failed
ERROR[HY000][Microsoft][ODBC Microsoft Access Driver]Could not find file '(unknown)'
And then it shows me that my code for
If dsLogin.Tables(0).Rows.Count = 1 Then
IndexOutOfRangeException was unhandled
Cannot find table 0
I knew it must be the driver but I don't know what accdb driver I can use for the connstring.
I have a table named fec in which i hv column named EndDt having Date/Time Data type.Now i want to display those records in my report which have EndDt less than Date i pick from DateTimePicker and month is current month.Private Sub DtpDefault_ValueChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles DtpDefault.ValueChanged
[Code]...
i'm doing attendance monitoring system. i cant find out how to show datetime in datagrid taht will shows date or time only.
View 10 RepliesI am an Australian user so use date format dd/mm/yyyy...my frmMain has a list box that retrieves a list of date values from the access db and displays them in the correct format (15/12/2000 - dd/mm/yyyy). When I update the DB using that same date the date format becomes reversed (ie interprets as 12/15/2000 - mm/dd/yyyy). [code] I believe the problem is something to do with the fact I am enclosing my date in my code with #'s and that somewhere between visual studio and access, the dates are getting flipped. [code]
View 1 RepliesI now have SQL Parameters set up and I'm using them to save/delete/add my data. This all works well, except when it's trying to save a combobox to the datatable it appears with the error above.Majority of my comboboxes have datasources, and the valuemembers of these are the actual list items, not the ID's of the list items.I'm not sure why this error could be happening, I'm fairly sure I've connected everything to the binding source correctly; I've checked it a few times.Does anybody know what the cause of this could be? I've looked around a bit and I haven't found much
View 7 RepliesI am using attempting to create a connection to an Oracle database via entity framework in Visual Studio 2008. I am running 64 bit Vista Ultimate.At first, I had difficulty even making a connection to the db through Visual Studio, but eventually got things working by installing 10204_ vista_ w2k8_x64_production_db AND ODTwithODAC1110720, but only the minimal parts needed to interface via Visual Studio.I am completely new to this setup, so it's likely I have already made a mistake, but installing both packages is the only way I could create a connection via Visual Studio.I made the connection, and used the wizard to create a . edmx file. The model and associations were created perfectly, and I thought things were going to work well. I used the default name "Entities" as the reference name.[code]How is it that I can connect to the oracle db at every point except when I'm running the application?
View 2 RepliesIs it possible to check the Application Type(Console Application, Windows Forms Application) at run-time.I have been looking for 2 days, most of the happy application info has been made available with my.application.info but where is the application type?
View 1 Replies