Can't Find Server Explorer In 2010 Express
Dec 2, 2011Can't find Server Explorer in vb2010 express?
View 2 Replies
ADVERTISEMENT
Table Created In VB 2010 Express Database Explorer Does Not Appear In Underlying Server?
May 10, 2010The above is more or less the complete question. I have created a table in the VB 2010 Database Explorer but I cannot for the life of me work out how I can get this copied or created into the underlying server. It is not appearing in the underyling serverand when I run the code of course I ge "invalid object <tablename>" I have data as well in the table that appears in Database Explorer. I think I have missed something fundamental in my overall conception of using VB 2010 Express with SQL Server Express in that I don't know if I have a local copy (that isn't then mirrored on the server), or what (the ____ have I got)? An article that explains the overall relation of Database Explorer to the underyling Server would be great as well
View 8 RepliesVS 2010 Connecting VB 2010 Express To SQL Server 2008 Express Database Via IP
Feb 29, 2012I am trying to make a user account SQL database work with Visual Basic 2008 Express for login purposes, i.e. usernames & passwords. Plan is to host this server so people can login to use the the application and verify they have a valid account. I would like to host all the account information in SQL due to the possiblity of hundreds of users at any given time. I also need the ability to add data to the database for users registering for the first time. The SQL server will need to be able to access the SQL Server databases remote via WAN.
View 3 RepliesConnecting VB 2010 Express To SQL Server 2008 Express Database Via IP
Feb 29, 2012Here is the scoop: I am trying to make a user account SQL database work with Visual Basic 2008 Express for login purposes, i.e. usernames & passwords. Plan is to host this server so people can login to use the the application and verify they have a valid account. I would like to host all the account information in SQL due to the possiblity of hundreds of users at any given time. I also need the ability to add data to the database for users registering for the first time. The SQL server will need to be able to access the SQL Server databases remote via WAN.
View 1 RepliesINSERT Or Update In SQL Server 2008 R2 Express In VB 2010 Express
Jan 21, 2011I am trying to re write a VB6 program using MS Access, many years ago, using VB 2010 express and SQL server 2008 R2 Express. I have a database with several tables, which I created using the designer. I am able to connect to the database and select data and display it in textboxes etc in vb code. What I have not been able to in code is to INSERT rows DELETE rows or UPDATE any data in the tables. I can do any of these operations using the Query Designer, but I want to do it in code. I can post some code if necessiary, but I thought it might just be some property that I had not set in the designer.
[Code]...
Connecting VB 2010 Express To SQL Server 2008 Express Via IP
Feb 29, 2012there Dream in Code Community! Im an okay programmer as far as skill right now I am still learning as we all are I need some help from some experienced VB.NET programmers in the community, Here is the scoop: I am trying to make a user account SQL database work with Visual Basic 2008 Express for login purposes, i.e. usernames & passwords.
[Code]...
VS 2008 - Downloaded SQL Server Express - Create A Database - Find/connect ?
Feb 26, 2010I've just downloaded SQL server express and have created a database in there. Now back in my VB.NET application from Visual Studio how do i find/connect to it?
View 16 RepliesVS 2010 Opening Server Explorer From Within A Program?
Jun 9, 2012Is it possible to open up Server Explorer from within a compiled program. I would like to give certain users the ability to open up the database tables and view and possibly even amend data within them.
View 3 RepliesAdd A Remote SQLServer Database To My Database Explorer Window In 2010 Express?
Feb 14, 2011I'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...
Databases : Find An Angle In VB 2010 Express?
Apr 23, 2010i want to create a windows form where i can add names, Employee ids and the projekt they are working on. Clicking a button should add the data to a database. Later id need to retrieve this data.First i was thinking that setting up a sql database and finding functions to access it would be fairly easy however.. Theres obviously more than one way of doing this and im having trouble finding the right angle...
View 13 RepliesFind Tutorials On Program 2010 Express IDE?
Jan 25, 2012I just installed the Visual Basic 2010 Express and I have no idea how to start! The IDE is so new to me and I need the place or link where I can download or watch video tutorials about the IDE and its features. I also want to learn the VB 2010 Express language from the very basics of it.
View 2 RepliesVS 2010 Connect To SQL Server With .NET Express?
Oct 29, 2010I try to use my data source and setup a new connection, but i see it wont let me.Is this another features they left out of 2010 express edtions?I just want to setup a connection to sql server with vb.net express 2010?
View 2 RepliesConnect A Sql Server Express Database In 2010?
Sep 17, 2011I want to use a connetction string for connect a databse in sql server express by vb.net? My code is : Cn1.ConnectionString ="Data Source=.SQLEXPRESS;Integrated Security=True;Connect Timeout=30;User Instance=True" but i when open then connection i see this error Cannot open user default database. Login failed. Login failed for user 'Shahab-PCShahab'.
View 6 RepliesIntegrate 2010 Express With Team Foundation Server?
Jan 28, 2011I've used MS Visual Basic 2010 Express to build a very simple VB.Net Windows app. I need to check the code into our Team Foundation Server Source Control. Is there a TFS plug-in for VB Express? If not, do I need to check the code in manually?
View 3 RepliesUpdate Data In SQL Server Express 2008 Using VB 2010
Jan 17, 2012Here is the code snippet
objCommand.CommandText = "UPDATE tblCustomers SET weight= @weight, height= @height WHERE id=@id "
What i want to do is the following:
I have a form and i want,by clicking the appropriate button, to update the height and weight values which have the specified primary key 'id'.
The primary key 'id' is of type IDENTITY.The problem is that the above code does not work. It says Must declare the scalar variable "@id".
Deploying An Application Express 2010 With A Sql Server 2008 R2 Database?
Apr 10, 2012I have recently developed a back end database in SQL server 2008 R2 and attached it to a application in VB express 2010.Everything works fine and when i publish the application, it works fine on my machine, but once i try to setup up the application on another machine i get the error message: A network related or instance specific error occurred while establishing a connection to SQL Server. Server was not found or not accessible please verify the instance name is correct or allow remote connections.I have read numerous forums on this saying about changing the connection string and instance name.but with being novice i dont understand what needs to be changed etc.The sql server allows remote connections, but i am unsure what else needs changing to allow the application to work with the database on another machine.
View 5 RepliesDoes Not Have The Choose Microsoft SQL Server (SqlClient) In VB 2010 Express Edition
Nov 28, 2011I have version VisualBasic.2010 Express Edition , but this version Does not have the choose Microsoft SQL Server (SqlClient) when open vb.net choose : add new data source and choose database and add connection Does not have the choose Microsoft SQL Server (SqlClient)
View 1 RepliesSQL Server - Local Database With Visual Basic Express 2010
May 24, 2011Visual Basic 2010 Express, lets the user to add a Local Database with .sdf extension. These databases needs MICROSOFT SQL Server to be created or they can run in the user's pc without any additional software? What are the limit of these databases unlike an external database?
View 2 RepliesUsing Search Server 2010 Express Web Service Results Are Returning .aspx Pages Instead Of Documents?
Feb 23, 2011I have a Search web reference (from a Search Server 2010 express install) in a vb.net application that is utilizing the QueryService Class to search a production Sharepoint foundation 2010 site.At a previous point in time, we had created a proof of concept on an entirely test system that has since been turfed. From my recollection on this test system when documents were uploaded as a specific site content type (that inherits from document) and metadata was provided, we could search for specific metadata by making managed properties for each, and search results would be returned as documents (with the isdocument flag set to true). Viewing the document then became simple, as we could simply use the filename and path to display the stored file.Now we are developing a production system and we have encountered a new behavior, where these results now are returned as aspx results such as
[URL]
This of course makes it terribly difficult to locate and view the document, we can extract the Title which will then give us the name of the file with no extension, but that hardly helps, as the FileExtension data is aspx, not the documents file extension, so we don't have a full filename. We could display the page returned as a result, but would much prefer the document itself.
I've made a test document library, with just bare bones setup, (not using the site content type, or site columns) and uploaded some documents on the same site, and they are returned in the same fashion, so I don't believe the document library, or content type are the issue.
With a fairly limited understanding of both Sharepoint and Search Server, I don't know if this is a setup issue with the search service itself, with the site configuration, or with the querypacket I am sending. We also have a third party application (Knowledgelake) installed on the server that ties into sharepoint which could have changed configuration somewhere as well?
I don't think the query packet has changed since it was working in the proof of concept, other than the custom data column names. I will provide it here in case there is something glaringly obvious to an external reader.
<QueryPacket xmlns='urn:Microsoft.Search.Query.Document'>"
<Query>
<SupportedFormats>
<Format>urn:Microsoft.Search.Response</Format>
[code]....
VB Express 2010 : A Network-related Or Instance-specific Error Occurred While Establishing To Sql Server
Jun 1, 2010i downloaded samples of vb 2010, i tried to run Create DB (Data Samples) but i'm receiving this error. I have MS SQL Server 2008 installed.a network-related or instance-specific error occurred while establishing to sql server. the server was not found or was not accessible.Verify that the instances name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error:40 - Could not open a connection to SQL Server)
View 3 RepliesIDE :: Getting Back The Solution Explorer On Vb Express 2005?
Dec 28, 2009ok so when i was watching a tutorial with my dad about learning the ropes of vb express 2005 i saw something he had that i didn't. so i paused the video and my dad tried getting the part to where i needed it and in the process deleted most of the stuff on the right hand side. so he uninstalled then reinstalled and we got most of it back except the solution exlorer. now i've gone to view and when i click on the solution exporer nothing happens.
View 2 RepliesConnect To A Database On SQL Server R2 Express From Visual Basic Express?
Nov 1, 2011Is it possible to connect to a database on SQL Server R2 Express from Visual Basic Express? I am following a set of tutorial videos done in SQL Server 2005, but cannot seem to connect to create the database. I have created the database in SQL Server R2 Express, but cannot connect. Is there a work around?
View 4 RepliesXCopy Deployment Of A VB Express App Which Uses A SQL Server Express Database?
May 13, 2005It's probably just a case of me not looking in the right place or not seeing the obvious, but does anyone know if a machine with just version 2.0 of the .NET Framework should be able to run a VB.NET Express application which accesses a SQL Server Express database file? Or is there an additional requirement for a non-development machine to have some kind of SQL Server Express runtime component in addition to the 2.0 Framework?It seems to be counterintuitive to expect that a VB.NET application would be able to access any kind of SQL Server data without having some kind of SQL Server host component (Express or otherwise) installed. But then again, it seems just as counterintuitive that Microsoft would require the download and installation of the new framework as well as a separate database runtime in order for the average user to run an application with accesses a local SQL Server Express database.To me, it runs contrary to the whole concept of XCopy deployment to require more than just the application's files and .NET Framework for an application to run properly. But nothing I've read so far explicitly indicates that a user would require anything more than the app files and the framework to run an application which accesses SQL Server Express data. But...I can't get any VB Express applications which uses a SQL Server Express databases to run on any machine that doesn't have SQL Server Express installed.What am I missing?(Apologies if this isn't the right group to post this in.
View 3 RepliesFind Explorer.exe Hwnd?
Mar 12, 2010I want to find & enumerate explorer.exe.
Found 'EnumChildWindows' API call but how to 'get' explorer.exe hwnd ???
Imail Server Express 11.5 Server APi For .Net : Unable To Load DLL 'IMailsec.dll': The Handle Is Invalid?
Sep 30, 2011I am writing a custom application for IMAIl express 11.5 using IMAIl Server API for .Net
I am using the following code:
Dim DomData As New DomainData()
DomData.Aliases = "TestALias"
[code].....
Find Parent ZIP File From Arguments On Double Click In Win Explorer?
Jul 13, 2011In Windows Explorer, when you open a ZIP file and double-click a file, say a JPEG file (.jpg), Windows extracts the JPEG file to a temporary folder, and passes the temporary file name to the associated program as the one and only argument, such as "C:UsersjpriceAppDataLocalTempTemp1_<>.zip<>.jpg"
I noticed that some applications, like the Windows Photo Viewer in Windows 7 know what ZIP file the temporary file came from. You can click next and previous and get the next/previous files from the ZIP file (as you do, they are also extracted to temporary files). I've googled and prowled through system.io.packaging, but I can't figure out how to get the path of the original ZIP file (the file name is part of the temporary file path). It's not done with the shell-->open command, Windows Photo Viewer only gets the temporary file name as far as I can tell.
The Photo Viewer command line is
%SystemRoot%System32
undll32.exe "%ProgramFiles%Windows Photo ViewerPhotoViewer.dll", ImageView_Fullscreen %1. I did use ProcessMon to watch Photo Viewer and saw it read the .zip file (probably using zipfldr.dll) but could not discover how it knew where the original zip file was.
Server Explorer Adds A Copy Of The Mdf?
Apr 22, 2011I have a VB2008 application that uses SQL Server 2005 Exspress Edition. I was modifying my application and then decided to add a table to the mdf (named "Pipe.mdf"), which I have don many times before, but I must have messed something up when I made other changes. After I added the new table I opened the Dada Source Configuration Wizard to add the new table to the dataset and I don't see the new table to select it. However, it added a copy of "Pipe.mdf" and named it "Pipe.mdf1" to the Server Explorer.
If I delete this copy of the mdf, it appears again in the Server Explorer when I open the Data Source Configuratuion Wizard.
If I add a Table to the copy of the mdf ("Pipe.mdf1"), it shows up in Dada Source Configuration Wizard.
what to change so that the new table appears in the Data Source Configuration Wizard for the original mdf (Pipe.mdf) and not add the copy of the mdf?
Data Lost When Refreshing The Server Explorer?
Mar 24, 2011i had insert data to my database.and it run perfectly like i want.but when i refresh the server explorer all the data that i inserted using my form is lost when i debug it again.
View 5 RepliesConsiderations For Choosing SQL Server CE Or SqL Server Express
Nov 15, 2009Ive been using both SQL Server CE and SQL Server Express. Both are pretty easy to program. What are the considerations for choosing one over the other ?
View 1 RepliesUnhandled SqlException In VB 2010 Express Thta Does Not Occur In VB 2008 Express?
Oct 16, 2010I tried to start using VB 2010 Express with a program I originally developed with VB 2005 Express that I moved to VB 2008 Express successfully a couple years ago. It uses a database file (*.mdf) that is on the computer ( not out on a server). When attempt to run the program in debug mode, I get the following error "An attempt to attach an auto-named database for file C:Documents and SettingsTomMy DocumentsQuizzing StuffQuestion Database 2010QuizQuest ionGameQuizQuestionGameinReleaseQuizQuestionDB.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share."
I first made a copy of the entire project folder that was working in VB 2008 Express and gave it a different name. In VB2010 I opened the project in the copied folder and it said it successfully converted the project. I am able to open the Data Source inthe Designer and see the database structure as I expect. I think the project is still using SQL Server 2005 Express (because it is what is checked in the list of prerequisites on the Publish tab).
Note, I have programmed off and on for many years, but fairly new to using databases and SQL Server.