Is 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 Repliesi am new with SQL server 2005 and visual studio 2008.how do i connect the forms and the tables in the database
View 4 RepliesVisual 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 RepliesIn the beta version of Beta2 of Visual Studio Professional, when I choose add new connections, I can select a I can select a " SQL Server (SQL Client)" datasource, which works great with my SQL Server Express DB running on the local machine.
In VB2008 Express, though, I can't select a "SQL Server" in the datasource dropdown. I can only try to connect to a Microsoft SQL Server Database File.
When I actually try to connect using the .mdf file that is being managed by my local SQL Server, I get an connection error -- can't make connection to the server (and the usual message about enabling remote connections".
I 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 RepliesI have th is little programm:
Dim dbOud As ADODB.Connection
Dim rsOud As ADODB.Recordset
Dim strCnnOud As String
[code]....
I'm trying to connect from VB 2008 Express Edition to a database in an instance of SQL Server 2008. Both, VB and SQL Server are running on the same machine. From a VB project, when I try to define a new Data Connection I find just three Data sources available: [Code] I selected the last one but when I browse for the mdf file I cannot select it because it tells me that the file is in USE. I have stopped all the services but still I'm not able to link the database file.
Two questions: 1. Is there a way to connect to the SQL Server Instance and from there to select the desired database? 2. How to connect using the Database file.
I'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 RepliesHere 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 RepliesIt'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 RepliesI 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 was a COBOL programmer agout 15 years ago and I am now just getting into Visual Basic. The owner of a local business has asked me to write a program to perform what I think is a simple task. In the past the business would process payroll checks and print them in-house. Now they are using direct deposit. Checks are no longer printed. The check stub though is printed. This stub is then carried to each of 10 locations across West Tennessee and distributed to the employees.
This is my task: capture the stubs to a file (PDF, XPS) and email it to each employee. This way the employee will recieve the stub on the same day the deposit is made. I can capture the output file (the stubs) and save it as a PDF file or a XPS file. I can send an email from within a program. What I don't know how to do is open the PDF or XPS file, read the email address and insert the page into the email body.
'm trying to use Visual Basic 2008 Express and connect to a DB of SQL Server 2008 Express but ... you can tell me why in the Database Explorer and the Data menu of VB only have the following options for data source? Microsoft Access Database File Microsoft SQL Server Compact 3.5 Microsoft SQL Server Database File does not have the options Microsoft ODBC Data Source Microsoft SQL Server obs.: I have the Visual Web Express 2008 installed, and there are the options available.
View 10 RepliesI have been given a task to:Develop a program where a child will be presented with picture of a fruit (one of five possible fruit) on the screen at the click of a start button. The child will then try to recognise the fruit and write its name in a specified place on the screen. On the click of a check button the name of the fruit written by the child will be checked by your program and if correct will reward the child with a suitable message. If the name presented by the child is not correct, a suitable message should be presented on a red background with the correct name of the fruit included in the message.
so far I have managed to create a form with 5 different fruit pictures and a text box below them. a button at the bottom of the form then checks the results and presents a message box to tell them if they have passed or failed.
[Code]...
I have a chart wich contains a series and I want to determine whether the points are inside or outside the series area.
So I thought that I should find the two X values for the series at the Y value of the point and check if the X value of the point is between them.
I too have recently downloaded VB 2008 Express, but when I try to register it after the live.co.uk sign in all I get is a blank web page. How can I get registered ????
View 1 RepliesDoes anyone have any idea when Visual Basic 2010 Express will be available?
View 1 RepliesI'm creating a project with my pc under xp and wondering whether the build will install and run under vista?
View 2 RepliesI am using this connection string to connect to my database and still it won't connect[code]....
View 3 RepliesI 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 RepliesI've installed MySQL .NET connector but it's not shown in data source options to connect in Visual Studio Express Edition.
View 2 RepliesI 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 RepliesIs it possible to add a small icon/picture within a button (to the left of the button text)? I don't seem to find any solution to this
View 1 RepliesI want to creat office addins with my VB 2008 express, but i can NOT find the template.
View 3 RepliesHow do i open an VBS project in Visual Basic Express Edition?
View 1 RepliesIs there an easy way to set the tab order for controls on a form in Visual Basic 2010 Express? I saw some references to a "View / Tab Order" menu item, but I don't see anything like this in the View menu when I am designing a form.
View 5 RepliesWere can i find instructions on the use of the IDE? My problem is that after writing code, in a botton for examle, I can't return to my Form.
View 2 RepliesIs there a way to import an exe file into a visual basic project?
View 8 RepliesI am new to Visual Basic. The only programming I have played with thus far is Perl and some Python in script writing for Paint Shop Pro. (if that is acually programming) I found a tutorial on About.com "from the ground up" with a link to download VB 2010 and when I tried to install the vb_web file I got this error:C:usersuserAppDataLocalTempSit24308reboot.ini cannot be opened. I did a computer search and found this file was not in the Temp folder. The install just hung and I could not cancel or retry. I shut down from task manager. When I looked in add emove there was not a Visual Basic listed. I couldn't tell if there were any other files that were added even though VB is not listed. There seems to be more C++ files (which came installed on my laptop) but I'm not sure if there are more of these C++ files.
I have searched for a week and cannot find a tutorial of how to install this program. I see VB 5, VB 6 and VB 2008. I also see a file for Microsoft Web Platform Installer, but it does not say if I need to download and install this file in order to download Visual Basic 2010 Express. I keep going in circles with my searches and always end up back where I started which is at the Visual Basic 2010 Express download page.
how to make a listbox change the selected item to the next or previous item by using a button... I want to have up/down buttons.
View 2 Replies