I have an application with databases in MS Access. I want to migrate that to SSCE. I have converted all the databases. Problem is with datasets. Do I need to make all new datasets or there is a way to convert the existing ones to SSCE datasets?
View 1 RepliesI have an application with databases in MS Access. I want to migrate that to SSCE. I have converted all the databases. Problem is with datasets.Do I need to make all new datasets or there is a way to convert the existing ones to SSCE datasets?
View 6 RepliesI am having problem in opening and viewing data in my SSCE table. There are 3 tables in it, two are working fine but one is causing trouble. I dropped the table and created a new one (same name) but again, the problem is the same.Please see the problem message below:
The select statement:
SELECT [PK], [AdmissionID], [Session], [Medium], [DateEnr], [FeeStatus], GuardianNIC], [FatherOccupation], [FatherIncome], [Cast], [Religion], [MotherName], [Address1],
[code].....
All of those disadvantages of stored procedures (database portability etc.) I am now facing. We are going to migrate our VB.Net/ASP/SQL Server application to something like Mono/Postgresql and fully internationalize.
One of the many issues we face is that we have 800-900 stored procedures. What we are thinking of doing is moving the logic in these SP's in to the application code. I have searched around for how people have done this or how it can be done however I have found very little. Most of the info on stored procedures is about what should be in them etc. So I have come to the conclusion that the best way to approach this is to leave the SQL retrieve/update type queries as stored procedures and move the ones with business logic in to the application.
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.
I need to update a database app written in VB, Visual Studio 2003, using an Access Database.Currently: Customer has 4 users, local network. Access Database is 30MB, about 50 tables.Wanted: Customer is opening new offices, and wants to connect to the database via the internet. There will be 10-15 users.App background: I have all data access via OleDbDataAdapters and one OleDbDataConnection.There are 4 DataSets: Global, Lookup, Reports, FormSpecific.
I have one Private function: FillTable:
Private Function FillTable(ByVal TableToFill As DataTable, _
Optional ByVal OleDbAdpToUse As OleDb.OleDbDataAdapter = Nothing) As Integer
' fills the table by using OleDbDataAdapter.Fill(aTable)
[code]...
All is working well.What I Need to Do:I think I need to migrate the Access Database to MS SQL. What I Have:Visual Studio 2008 Professional. I have started the MS SQL walkthroughs. I did the �Create a Data Connection to the Northwind Database� walkthrough, and connected via MS SQL Server. I cannot find where I can modify the SQL Commands. If I convert my Access Database to a MS SQL Database then can I
1) Just update the OleDbConnection, so it connects to the MS SQL Database (not the Access database).
2) If I cannot do #1, what do I need to start with?
Would like to migrate MS-ACCESS 2003 legacy applications into modern Dot Net, including migration of the MS-ACCESS Database to Sql Server 2008 (with potentially also migration of the MS-ACCESS Reports to Sql Server Reports). The purpose is to move to DotNet application with Sql Server as its database.
[Code]....
I created a program that logs incoming data to a serial device to a text file but the output is not what i really want, the data appends to the text file and looks like:
[Code]...
I just need to edit coloumn 2 of row 0 of SSCE 3.5 database.I am using following code.It generates no error but database is also unchanged.[code]
View 1 RepliesI created a database in SQL server compact 3.5 I have a few fields in that.Later when I tried to delete one column and added so more, change was not saved. I did it all using server explorer of VB.Net. when I make the change, at that moment I can see the newly added columns but when I make dataset for this table
View 1 RepliesWe are currently using Access 97 as our database. This resides on the remote farm server (which is a Windows 2008 R2 server). We are using a front end vb6 exe which accesses the back end data.Occasionally we are getting corruption to our database and we have to make sure everyone exits the software to allow us to repair/compact it. There are 2 physical servers, each running 2 virtual machines. When the user logs onto the farm using RDP, they go to one of these 4 virtual machines.We are getting all kinds of corruption, some where # characters have been inserted into the top of one table, some where the indexes are corrupted, and some where access needs to repair the database.
View 1 RepliesI want to build an application, which can remote access to SQL Server in Server Machine.I used to build one, and it also can access to SQL Server in other pc. But when i promote it to become a Server(to become a Domain Controller). My application has never access to SQL Server. I don't know what to do now?
remember: I want to build an application, which is accessing to SQL Server in Window Server(Client/Server Application).
I want to know how you can export data from a disconnected database that could be access or ms sql to an sql server database.
Here is the scenario:
I have several software in a remote sites on either sql or ms access databases as back-ends...and I have another sql server database that i want to consolidate data from the remote sites.
One solution I have been thinking about is to use email to send incremental backups of the databases to the main database using a separate piece of software and have another one on the main server to pull that data into the database.
Basically am looking at setting up the remote databases as linked servers at the main database and then having incremental backups sent by email to the main database.
I have thought of replication but the internet link at the sites is terrible.
Is that a good implementation? If yes
How do i get to send the incremental backups and get them imported?(the code)
Tools:
Visual basic 2008 standard edition..Net 3.5
SQL Server 2005.
32 bit architecture.
I am going to be taking up a new job as a VB.net developer. I have worked with C# for about 3years. I did mention to the interviewer that I haven't worked with VB.net, but he seemed to think that its easy to migrate from C# to Vb.net.
View 1 RepliesI've done a fair bit with the other languages in Visual Studio, and have some C# code I wrote which I am trying to port to Visual Basic.
I will show it here:
public sealed partial class Dice
{
private sealed partial class MT
[Code].....
My question is one of a fairly simple nature, how do you make a thread safe singleton constructor with Visual Basic?
I tried a similar pattern to the one above, only to find that I had a lot of difficulty declaring the static variable instance as a null, this in turn would ruin my public Instance property, as I would have no way of telling if the class had been instantiated or not...
Anyhow, even a simple explanation as to the correct way of doing this would be nice, I'm sure I can fill in a lot of the grey areas, I just need more information than what I'm finding in MSDN, it seems Singletons are only really described in detail for the other languages...
I want to migrate some code from Vb6 to Vb.Net Here is the code that doesn't work:
UpgradeStubs.MSDataGridLib_DataGrid.getCol(ShowInsur) For UpgradeStubs, I have found an equivalent: Artinsoft.VBUpgrade.Maps, but overall it doesn't work.
I program in vb2008.I am curious about what resources exist:( books, videos, courses) which address how to migrate to 64 bit applications.Right now I have 4 machines with 8 gbyes of memory running XP64.My chief interest is in what I need to do to allow myself to address >4gbytes of ram in a vb application.
View 1 RepliesI program in vb2008. I am curious about what resources exist:( books, videos, courses) which address how to migrate to 64 bit applications. Right now I have 4 machines with 8 gbyes of memory running XP64. My chief interest is in what I need to do to allow myself to address >4gbytes of ram in a vb application.
View 10 RepliesI have made a windows application (running parfectly on my system). Now i want to run it on another computer.
Here's what i tried: I noticed that an exe file of the application is created inside the Debug folder after the application is deployed. So i thought that copying and pasting the .exe on any other system should work fine but trying to run the exe on that system gave an error and it would not run.
P.S. This application did not have a database. Also, i have made another application which interacts with an access database. How will i be able to run that on another system?
We're building an application using VB.net and WPF. Obviously we've found that there are huge differences between the syntax in the two, and we have a few problems trying to do things in Form apps in WPF.If possible, could you pass us some resources on things like switching between WPF windows, we'd use Show() and Close() in WinForms, and referencing variables from other forms, i.e. otherForm.StrVariable references StrVariable from otherForm.
View 2 RepliesI are testing Win7, and I have a ____ trying to just do anything in Win7. Lots of permissions problems. unexpected crashes.
I are no more owner of my code files!
I had no idea that my application was so buggy on Windows 7 :(
I'm migrating some code from VB.NET to C# (3.5).I find structurs like:
Public Event DataLoaded(ByVal sender As Object, ByVal e As EventArgs)
Protected Sub Mag_Button_Load_Click(ByVal sender As Object, ByVal e As EventArgs) Handles Mag_Button_Load.Click
[..]
[code]....
What is the most streight-forward to translate such behavour in C#?
First off I am so VB.NET green it's pitiful. I am a AutoCAD Manager and I need to start migrating my VBA code to VB.NET. That being said, I am very familar with VBA,and some asp.net, and trying to use that knowledge to self-train in .net. The trouble I'm having is communicating between the various objects in .net. That being said, here is the first of many issues.
Currently, I am working on a file processing program that checks a user selected folder for .dwg files. I'm attempting to use FolderBrowserDialog activated using a "Browse" button , and can't seem to, first get the dialog to show a folder structure from the FolderBrowserDialog object and second, get the initial dialog code to take the "SelectedPath" method. Error "SelectedPath is not a member of "folderbrowser"
I can post code, but I'm not sure what snippet would be the most informative of my problem.
I currently had a .Net Remoting Application running on Framework 2 under IIS. I have to upgrade it to Framework 4 in order to use some new components. I have been able to set everything up and running smootly on Framework 2, but as soon as I change to Framework 4, I get the following exception when I try to call one of the function of my remote object.
The input stream is not a valid binary format. The starting contents (in bytes) are: 53-79-73-74-65-6D-2E-52-75-6E-74-69-6D-65-2E-52-65
This bug is not the real bug, it is caused by the fact that the remote object is throwing an exception, and IIS wrap the exception in XML, which throws the BinaryFormatter off.See this for more info on the bug.
This is very unfortunate because I cannot see what is causing the exception, and having never used any Remoting before, I do not have much ideas as to where to start debugging. It seems the Exception is thrown before even stepping in the code because I do a fair amount of logging and none of it seems to be triggering.Basically, I'm looking for some clues or pointer from people that encountered similar problems:
What could be causing the exception when no code has changed besides Compiling from .Net 2 to .Net 4?How can I get the full Exception message that is returned?
[Code]...
I come to programming from a school of functionality rather than theory- writing programs to meet a goal or solve a problem.I haven't had any education in computer science so many aspects of the Visual Studio world are alien to me.Just for fun I wrote a very small program to help with a computer game.It's called the All Lucky Sevens calculator for Final Fantasy 7.If you haven't played the game it won't make much sense to you so I'll eschew the logic of why I wrote it, focusing on what it does.
Basically it performs a series of percentage calculations on a number input by the user, trying to convert the original number into one that ends in 77. So 6104 reduced by 7% is 5677 The question is, how difficult is it to convert VB.NET code to work as a web-based app. I thought .NET was designed to make it easier to do this? Is it relatively simple to convert VB.NET code into something that can be run from a website? If not, the solution is to rewrite it in a different language like Java or Flash.The actual programming of it would not be difficult, but I do not speak those languages and it would require rewriting all the nested loops and ifs.Forcing VB to round down a decimal to an integer was difficult enough, I daren't think how hard it is in a language I've never used before.
We have a small visual basic 6.0 application with an Access DB that we would like to migrate to modern code and architecture. I am not technical, but I am believe this would be something like a .net framework with a SQL Server DB.What I am wondering about, is there any way to covert this code to a modern language/architecture? If so, what is the easist modern language to migrate to?
View 7 RepliesI'm currently trying to interface some Fortran routines into a 3rd party environment by creating a VB.NET DLL. I don't have accessto the Fprtran code because its considered proprietary.
As a starting point, I demonstrated that I could make the call satisfactorily from VBA using the following
Declare Sub INTERFACE_VB Lib "C:FortDirFortFile.dll" _
(ByVal SV As String, ByVal intSV As Long, _
ByRef IV As Long, ByRef RV As Single, ByRef intIERR As Long)
[Code]....
I have to migrate a software from VB6 to a most modern technology.
1) Does has Visual Basic 2010 Migration Wizard to migrate VB6? I have downloaded the free trial of VB 2010 and I can't open a VB6 proyect
2) It is a good idea use VB2010 or is better go with VB2008?
I have to say that I will learn the language also, my guts says that I should code again everything using VB2010 ( so I am learning the lastest language) although I am not sure?
I need to convert my winform VB.NET application to an ASP.NET application.My current application has 4 forms, it reads a remote XML file, and uses a datagrid to collect user input and to create a report.It is a very simple application, and I would like to know where to start to convert it to ASP.NET.
View 3 RepliesIs there a way to include in my solution a copy of my dataset in my solution , so I can use it in another environment without access access to my SQL server database?
View 3 Replies