[VB 2010] Use A Database In A Distributed Environment?
Jun 13, 2011
I just created my first VB.net project using Microsoft Visual Studio 2010 that has database(.mdf) and some forms?I want my project to be remote/network using lan environment, in what way i can do this?i keep goggling i can't find the answer so i end up in your site, I already install SQL Server 2008 R2 in my PC, and i already set up 2 computer here in my house 1 act as a server and the other is client using Lan.
i made this thread and faraz zone made a guide for me, I keep doing the guide but i keep getting this error: url...untill now, now i end up reformatting my notebook and i try to do again Faraz Zone guide and i still keep getting that error, now I decided to make this new Question/ Thread.I already made my vb.net project using Microsoft Visual Studio 2010 that has database and multiple forms, and I already installed SQL Server 2008 R2. I want my project to be remote/network using lan environment, in what way i can do this?
for my vb project, i have to develop a system for a network environment. it means a central database to the application. i don't know how to do that. i am hoping to do a sql database. guyz please help me to do this.if you have any tutorials or any of your advices, will help me a lot.
Why would database drivers work in the development environment of VB.Net and not once the project is built and installed on the same pc? I've tried the MS ODBC Oracle driver. I've tried various ODBC datasources. All work when I am in the development environment but none once I build and install. No matter whether the configuration is Debug or Release. This is the only project having this problem. I have other apps (VB.Net) that access the same database (Oracle 9.2) with no problem.The environment variables are the same during both types of runs. The error messages vary depending upon the driver being used.
I already made a project using Visual Studio 2010 (Visual Basic) and my database connected to SQL Server 2008 R2, also set up a PC 1 act as a server and the other is client i set this up for beta test.
I'm having issue about putting an IP Address to the server pc, actually if the IP setting of the server pc "Obtain IP Address automatically", i can open my application in the client pc, but once i put IP Address on the server PC i cannot open/run my application to the client pc, i cant figure it out how can i fixed this issue.
I developed an VB.NET application in VS2010. For the database I use SQLite V3.In VS2010 all is working fine, but when I build my application and run it under windows I got a message that I use a mixed .NET envionment.An error occurred creating the form. See Inner Exception Exception for details. The error was: Assembly with mixed mode was created with the runtime version v2.0.50727 and can not without additional configuration information loaded into the runtime version 4.0.In my program I use .NET4 tools (charts and dattimepicker dropdownboxes) but SQLite is compiled in .NET2.So additional in VS2010 I added the "app.config" with the famous lines:[code]
I have VB6 Dll which I am referencing in vb.net ,I am calling the following function in it. It working fine in developemnt environment but not in deployement environment.
Error Method not found: 'Boolean MyUtils._MyUtils.LoadMyObjectRecords(ADODB.Stream ByRef, System.Array ByRef)'.
I am using SQL EXPRESS EDITION 2005 and Created mdf data file using vb.net 2008. now i want to use this datafile in lan. i modified connection string "Data Source=.SQLEXPRESS;AttachDbFilename=ServerDataData1.mdf;Integrated Security=True;User Instance=True;Connect Timeout=60"it is showing security info error i want to use single database file for my application please help me with connection string. thank you
I am using LINQ to SQL and a third party SDK that supports distributed transactions. When I realize that a pending update will be updating both SQL records and records in the third party SDK, I am creating a TransactionScope with a 0 (presumably infinite) timeout (although I've also tried 12 hours as a timespan parameter). Then I use GetDtcTransaction on the ambient transaction (created by transactionscope) to get a DTC transaction to link to the third party SDK. Things work nicely for about 10 minutes, but after 10 minutes, the transaction disappears and an error occurs. How do I determine why the transaction is disappearing. I suspect it's a timeout because it regularly occurs after 10 minutes even though slightly varying degrees of work have been done at that point. But I'm at a loss about how to determine what terminated the transaction, why, and how to extend its life.
I'm wondering, is there a way to update databases of a windows application that is distributed on several computers all at the same time? is it done by using sql server? because I'm developing an examination system that will be distributed on several computers for students to take exams and I'm just wondering if an admin updates a questions database will the changes be applied to all other computers as well or should it be done manually? sorry if I sound stupid but I can't seem to understand this part of my work, I was thinking about switching to a web app since it seems easier, but again this data updating issue is giving me hard time. by the way I might link the application to an internal network, will this have anything to do with updating the databases?
I need to write a program that can be distributed over a network of 400 computers and that can be updated if necessary. How do i do that with VB if i can at all? What should i learn?
We've recently moved to Team System and now a remote team needs access to our source. However, they use a different IP address to access the Team System server, and whenever they try to open a project, they are prompted to check out and change the project. It seems to be the 'SccAuxPath' property which is the problem.
how to work with distributed application in vb.net that automatically stored data into server? How to configure to ensure the consistency of data being stored.
I have an app that I'm debugging and I need to pause it by clicking on a "pause" button in the development environment. I don't want to stop it programmatically, just manually to check what it is doing. I know this should be simple but I can't find a pause button anywhere on the toolbar.
We have a couple of applications at work that need a reference to the license server set in the User Variables under the Enviroment Variables on the windows xp client machines(system properties, Advanced, Enviroment Variables). The problem is that both applications needs a reference to the same variable name and you can't have two with the same name. What i intend to do is to create a simple windows application with a button for each application that deletes the variable item present, adds a new variable item with the value needed for that application to be able to run and then run the application itself. This is just a temporary fix until we get a more permanent solution. The 'GetEnvironmentVariable' class in vb is not able to add or delete a item, maybe the WIN32 API could do the job.
I was trying to learn how to do openGL within a VB .NET environment and it seems that the Tao framework or OpenTK is recommended with OpenTK having a higher recommendation so that is what I chose to try using. Since I am brand new to this, I am trying to just draw a simple box, triangle, or anything really so that I can understand it all before making more complex things. I have been unsuccessful at this so far so I will list in order what I have done so far and hopefully someone here can help me correct it or provide a new example just so I can draw a simple shape.
1) I installed OpenTK using opentk-2010-10-06.exe
2) In a new project I added the references to OpenTK.dll and OpenTK.Compatibility.dll
3) I added the control (opentk.glcontrol.dll)
4) I added the actual control to my form.Using some examples online I added the rest:
Outside of the environment after running the setup program I can tell that the setup is failing miserably. The all important file "cakecreationdb.accdb" cannot be found. I have been beating my brains out against a brick wall on this one.
I'm trying to use LINQ to SQL in Visual Basic 2010 Express.
It allows me to create the .dbml file, but in order to drag items from the Database Explorer window to the design surface, I first have to get my database listed in the Database Explorer!(this is a remote SQL Server database - not a local .mdf)
I already have a good, working connection string to the remote SQL Server database, but that doesn't help me when I'm trying to generate the DBML at design time.
Can anyone tell me how to get my remote SQL Server database identified in the Database Explorere window? When I try the "Add Connection", I am limited to Access, SQL Server Compact, or SQL Server Database File. If I try to enter the IP address & port of my DB Host I get a 'database file does not exist' message. Doesn't seem to want to let me point to a remote DB server...
I use Environment.NewLine, my colleagues use vbCrLf.When I'm doing a code review for them I want something that I can point to to say "use Environment.NewLine instead of vbCrLf"
Or, am I just peeing in the wind, and it doesn't really matter ?
I am trying to change the way my aspx pages load when I double-click on them in my development environment. I wish for the markup to show instead of the design. So, I go into "Tools" -> "Options" -> "HTML Designer" and make my changes. However, I have to do this every time I get into VS. How do I make those changes stick?
Is one able to compile VB 6 code in Visual Studio.NET ? In other words, is it backwards compatible with older VB code?Since I know there is a difference between managed code (.NET) and unmanaged code, I am wondering if Visual Studio.NET is able to compile unmanaged code as well?
Ok, I am needing to capture the username of the user who is logged into a third party software (similar to citrix) which then will launch compiled vb.net applications from the 'Cloud'. If the user logs into their windows active directory machine as Smith123, and then logs into this third party software as SmithS, and launch a compiled program which runs on the remote server, and executes a button that displays the environment .username results, what will return? Smith123 or SmithS?
I am trying to figure this out, and I would just create a program and try it out myself but going through all of the hoops, bells and whistles of where I work just to get a simple compiled piece of code up on the server can be a pain sometimes..
Environnent.NewLine seems to be resolving to two spaces " " (as are vbCrLf and ControlChars.CrLF). Using StringBuilder, AppendLine is doing the same.I've been racking my brain and searching the Internet trying to figure out why this the way it is, but am coming up empty.
I am trying to generate .bat file based on user interface decisions. I need to have separation between lines. I'm trying:
I successfully converted a VB6 program to .net 2008. Phew. Thats the fast way to learn a new language I'd like to get an exe that I can try running out of the design environment. Is that the "Publish" menu selection?