Tell me if I want to run a project that is created in vb.net 2010 and uses a backend SQL Server 2005.........how many changes can be done in a project to run on another computer....?what connection string I can write for it.......?which software do I need to install on the other computer to run a project on it.......
View 1 Replies
i was create the .exe of vb.net project with sql server in backend. when i install it any other computer that time it is not connect to the data base. whta i do for that.
View 1 RepliesI have recently learnt vs '05 and am creating a project in vb.net '05.my question is-During project development, we connect it to MS SqL server 2005 express installed on my system and it works.( I use add datasource wizard,add sqldataadapter,add gridview control,generate dataset,connect dataset to gridview method). But after the project is finished and we create its executable, the project will be run on adiffrent machine with a different server name and hence a new connection string will be required.
How can i make my project detect server details and connect to it, at runtime ? because the user is only expexted to start the server and open my application.the app must connect to the new server on its own. If anybody has an answer or if you know some resource where i can find it, please post here. Any suggestions are welcome.
I have a windows app created in 2005 with sql server backend. There's also a web service that is located on a web server at a hosting facility. In my app, when ever it needs to interact with the data, it calls the web service.Ive been having this issue with several screens that Ive developed in .Net. The user enters a date, and saves to the database. When the datagridview is refreshed, the date that they entered always displays one day earlier. Eg. If they entered 4/18/2012, it displays as: 4/17/2012.
The date is correct in the database. I verified that the problem resides on the web server. The default timezone set on the server is GMT -06.00 Central Time(US and Canada) and it cannot be changed on the shared server. The time zone where I'm at is Pacific Standard time. I'm not sure the best way to deal with this issue. Here's one way I was thinking: Retrieve today's date from the server (don't know how to do this), and compare it to the date on my machine so I know the difference. Then, when I'm looping through the datatable, add this same number to the dates to display correctly. Maybe it's better to retreive it from the database via the sql?
We are thinking about changing our current database system, MS Access 2007 front end and MS SQL Server 2005 backend to using a higher level language such as Visual Basic .Net. I wonder if this is the BEST solution for data management? Currently, among others, we have two big database programs that handle more than two hundred users and it's crashed often. That's the reason we think about changing to something that can handle these database programs effectively preferably using MS technology such as .Net.
View 12 RepliesVB 2005 Express Visual BasicI want to move (part of) projects to different projects/ computer.I used File - export template- and was able to save templates of whole project or item(s).They saved nicely in a subdirectory called "templates" as zip files.How do I import to 1/ other project on same pc?2/ To a different computer?I tried copy zip files into corresponding folder on new system. No luck.
View 5 Replieshow can connect to sql server 2005 or 2008 by vb.net from anther computer ? and this computer donot have sql server.i made search on internet and result was use sql client tools but i made search and try to download sql client tools but i did not get any result.so how can i connect to sql server 2005 or 2008 by vb.net on anther computer or on network LAN.
View 4 RepliesWe have to make a modification on the WPFToolkit.dll to add some watermark text. Now, when we install it on some computers (I can't find what's different about them), I get this
[Code]...
I had made a project in VB.NET 2005 with SQL SERVER 2005 used as database. Now i want to make a setup of this project but i am unable to integrate sqldatabase and .net framework in this setup project. Is there any way to do this. Because it is assumed that the client does not have .NET Framework installed nor he has SQL Server on his system and the worst condition would be he does not have even internet connection from where these two setups can be downloaded if we give the condition for downloading these programs from the net if the client does not have these programs installed on his machine.
View 2 RepliesI'm a bit new to VB.NET and I have a database which I want to connect to an access backend stored on a network drive for multiple users. I can view the Database in the solution explorer and the directory defaults to the project folder. How can I specify the directory to pull from my network drive? VS has copied this datasource and imported it locally which is fine for testing, but i need the file accessible for multiple users. Is this something I do when publishing?
View 3 RepliesI have a problem loading data to a tree view control using SQL SERVER db as my backend...i just found out that sqlserver dont accept multiple SQLDATAREADER
The code below works in SQLCOMPACT EDITION..
CODE:
I have use this code in my applications using SQLCE as my backend, but when i transfered to sqlserver it doesnt work because of the datareader..
Output is like this
Quote2011[January][February]
2010[January][February]
something like that
If i put it in a single query(sqlYear & sqlMonth), the ouput will be like this
Quote2011[february]
2011[january]
I've been using ms access bfore but want to upgrade coz the company im working in is getting bigger. With almost 10,000 new clients added every week. Im afraid access can't handle it anymore. So im planning to create a new database. Im really new to this SQL Express but have knowledge in sql using vb codes. Is it easy to be used as backend database?
View 6 RepliesI have built an application using VB 2005 express edition with backend Ms Access 2000. In main form(which is loaded on startup), I am having 9 datagridviews, each bound with databindingsources. I am refreshing this data every 15 seconds by refilling the table adapters and updating the datagridviews.Now, this access database is shared in the network and is accessed by about 5-6 users concurrently. There are other forms which are used to edit the data.My problem is poor performance of the application. Its very slow in opening up forms, not responding sometimes and using the network resources fully.
View 5 RepliesI have read about Network.Downloadfile and I think I understand it! I want to know if there is an easy way to test a files date modified before downloading it. I have a lot of files in the folder. I really want to "sync" the folder. I don't want to copy every file every time I want to only download the file if I don't have the file in the destination location or if I have an Old copy.
View 4 RepliesHow to convert this to vb.net codes? i want to put it in my project "Computer Rentals"
[VB6 codes]
Public Sub xClock(Optional ByVal xSec As Variant = 1)
Dim iCnt As Variant
[CODE]...
I use this procedure as my own timer, put it in module as public procedure.
Basically back in VB6 days, I created several VB6 apps with Access as the backend database. I'd package my Access db file with the application setup, which copied it on to a shared network drive, and then different computers on the LAN could use the same backend database file, and that worked just fine. With SQL and VB .Net, I've done work with a SQL database hosted on a remote server, so you can basically build your query string easily and anyone can connect to it from anywhere, and it works just fine.However, what I'd like to do is have a local SQL express database as the backend for a VB .Net application and make a setup program that can install it in a way that it could be shared on a Local area network, without the user who is installing the application do anything.
I know about building a connection string with the local machine name, but I don't really have any experience with including an actual MDF file with the application. Does anyone know how it works, and is it a better approach? Does it work similar to placing an access file in a shared unc path?I know that ClickOnce (which is awesome) can install SQL express easily on a user's machine. However, the key is that I want SQL express to be installed only on the machine that is going to be the database server in a LAN enviornment, and not on every machine, unless it is neccesseary. And then how does your VB app know how to build the connection string to access the database from any machine on the local share?
I am trying to dial a computer from another computer using Modem for sending files and messge.Follwoing is the code done in dialing computer
Text1.Text = "Test string from App1 "
Number$ = InputBox$("Enter phone number:", "Number$")
If Number$ = "" Then Exit Sub
Temp$ = Status
[code].....
But after the dial tone, i am getting the exception "CTL_E_GETNOTSUPPORTED " at the line MSComm1.Output = Text1.Text?
I have an ftp routine which gets various files from a server and puts them on a client PC.My problem is it loses the original Last Modified Date on the client PC. I can get the last datetime modified from the server but don't know how to assign this to the file on the client PC. Is there away to alter the last modified datetime?
View 3 RepliesAre there any good tutorials/links I can work through. I want to make my pc a file server or an ftp server through vb.net. How would I go about doing it?
View 5 RepliesMay I ask a question to you all.I have vb.net project that generate sales report from SQL Server Database.I changed SQL Server 2005 Express to SQL Server 2005 Standard Edition.
After that my program can't run properly and every time I got Time Out Expire message.
That program work properly with SQL Server 2005 Express.May I request suggestion how to fix this.
This has to be really simple and I am completely missing the boat. I have a VB2008 express windows forms project with several forms and an access database that I work on here at work. I want to copy it to a thumb drive and take it home and work on it there, then bring it back, etc.
View 1 Repliesi have my project vb.net on my old computer where i have visual studio 2005 Now i have another computer with visual studio 2005 How can i export project on new computer is there a wizard ? utility or simply copy and past ?
View 4 RepliesI made one project in Vb Express 2008 on one computer in my office.I copied the Folder of the same Project on another computer at home. There I also has Vb Express 2008. The problem is that the code of project is opening like Form1.vb but the actual Form in Form1.Designer.vb is not opening in that computer. Please advise how i can open the Designer form of my project on a computer where the copy of Project folder is used.
View 7 RepliesI have developing a program on one computer and when I try to move it to another computer running vb2008 express, I always get an error message saying "the project file (directory path, project name.vbjproj) has been moved, renamed or is not on your computer." The files etc. are in the same folders as other projects that run properly. Can't figure out how to correct the path etc. or figure out why the message as the files are where they should be.Cancel the question. I found my problem and it was me that caused it.
View 2 RepliesI have a project built in VB. As any other developer I want my project to run perfectly on any computers. what I need to run my project on another computer. Like what dlls needed, how can I find them, and other things required.
View 11 RepliesI am writing an application to gather, display and export system information for use with a Support Dept.Is there a performance difference between using WMI and My.Computer.X.X in VS 2005? Is one method better practice than the other?There are more lines with WMI, but am willing to write more if it's considered good practice over using My.Computer.X.X.
View 2 Repliesi am new in visual basic. net programming. i am facing problem that when i made a file in vb.net and run it on same computer than it runs fine, but when i copy it to another computer where vb.net or .net framework is not installed then it doesn't work. can somebody help me how to run that file without install .net framework
View 7 RepliesI will be working with another programmer today. He is just installing VB 2010 Express this morning on his computer. My question is how do I copy some of my projects over to his computer. Will copying the folder(s) under C:Documents and SettingsMy_User_NameMy DocumentsVisual Studio 2010 Projects.. be sufficient or will there be other support files I need to copy as well?
View 3 RepliesI just made my project, I just wanna ask is possible to share your project to the other computer, like file sharing or networking, which you can access your project to the other computer, is that possible? If possible, how should I do that?
View 2 RepliesI have a project in vb.net2008. I use tools of vb6 and excel in it. Now I want to publish my project and use it in other computer that not installed vb6, vb.net2008 and excel programs. What must I do?
View 1 Replies
