Is the
Set DB = OpenDatabase(App.Path & "/Storage.mdb")
Set dbRecordset = DB.OpenRecordset("T1")
still the same in VB 2008? Just want to know and how? Specially the "App.path", Im trying connect but I cant.
I created a project in vb.net which is connected with database. The problem appeared when i changed the path which connect with the database, i made it relative. So some of the forms which contain the connection are working properly but in one form i got this error: [Code]
View 10 Repliescan i know what code that enable me to list all currently running process and get their path and list all the path in listbox1.
View 2 Repliesi'm working on a system that upgrades a basic version to a proversion but i have a payment gateway . it generates a code in an SQL DB.now i have a form in VB that has a textbox and a button how can i let VB connect to my SQL DB receive the code and then check if that code is correct and if its correct download silence the pro file. from an url.
View 7 Repliesneed to connect to a MySQL 5 DB from VB.NET [2008] 3.5 Framework from code.Help ..need the connection code
View 11 RepliesI have a Access program and I'm using VBA code in the background to run Winunzip using shell command. Well, the path of the .zip file has spaces in it and it's not recongizing the path as a valid path. Is there a another way to tackle this problem besides the shell?I can't us pkzip either. Has you can see I had to use progra~1 instead of Program Files.[code]
View 2 RepliesException: ASP .NET VB .NET Code connect to sql server using sql authentication sql onnection stringHere is the solution for the problem
View 1 Repliesprovide me a simple code to connect .net and MSAccess? also provide me the details of where to find ADODB control.
View 6 RepliesI'm in need of a simple database for a program I'm writing...First, here's some info on what I want to do, so you can even tell me if a database is what I would need to accomplish it.It needs to have a single table, with two columns.First column will hold only 8 digit HEX codes (can be stored in a string if need be) - every entry will be unique Second column will hold a file path I need to be able to search for the path from the HEX code.I was able to create and link to an SQL Server Express DB in VB by using this tutorial: [URL]But that just create's and links the database, without telling me the code on how to manipulate it.
View 14 RepliesI have a search page in my application where I am searching the database for the records that meet the specified conditions that the user selects. All of this works by creating the dataset, datatable, and dataadapter in the code. I then take a created bindingsource link it to the created datatable and then attach the bindingsource to my datagridview to display the results. Now what I am trying to do is to figure the Mean, Median, Mode and Standard Deviation of the results that were found above. My question is how to I run a select query on the code created table. I have the select query I want to use and when I try to use it in the code it talks about the connection. Now I have a dataset that is part of the project and I have the on just for the search page. Let me know if you need any code samples.
View 10 RepliesI am using VB 2010 Utimate on a Win7 64bit machine. I have an accdb database created through MS Access 2010 (database has a password). How do I go about connecting to it using codes without having to drag a database control on the form, also is it possible to code my form so that it will automatically detect the path of the accdb database? Also I want to view the whole table using datagrid view as well as perform database actions such as add, edit, del, save, search and etc.
View 7 RepliesI'm supporting an old vb.net program whose database it connected to was moved from SQL Server 2005 to SQL Server 2008. Is there a setting on SQL Server 2008 which will allow ODBC connections to access the database but not allow VB.NET to connect to it programmatically?
[Code]...
Can i please get a copy of the code which you used to get the MSCOMM to connect to the robot and send single bytes of information? Having loads of errors with my code.Working on a similar project but using the mind-storm nxt kit.?
View 4 RepliesFirst off, my apologies for being a complete Newb! I have a SQL Express database that I use quite successfully to track my investments in several accounts. I built it myself, it's quite functional, and Im happy with it. The problem is that there are multiple account tables and updating them can be tedious in SQL Server, if multiple purchases and sales in multiple accounts have occurred in a month. Tedium can lead to errors¦
[Code]...
Running off my laptop: Visual Basic 2010 Express & SQL Server 2008 . I've successfully been able to use the connection wizard to connect to my database in vb.net and read/write data using datasets/tableadapters/binding_source etc.
Now I am trying to create an SQL connection via code to connect to my database to do some more complicated queries. I was successful in being able to connect to my database with SQL, but by doing so it produces an error when it tries to run any .Fill() methods from my TableAdapters below. The error produced is the following: "SqlException was unhandled. Cannot open user default database. Login failed. Login failed for user 'Chris-PCChris'".
If I remove my SQL connection code, the TableAdapter.Fill() methods will work fine.
[Code]...
how to connect to a usb port (for disital persona finger scanner)? I have no idea how to connect to usb using vb code.
View 5 RepliesI am creating a form which has the customer information entered by the user.When the user clicks submit the row need to be inserted into table "customer".writing the code to connect to the access database and insert the new row?
View 3 RepliesI have a directory with multiple sub directories that contain .doc files. Example:
[Code]...
In my code below, I am trying to display in a list box all of the files that end with extension '.doc' that are in sub directories of C:Users medinaDocuments estenviromentReleased So for example, I have
[Code]...
I'm using crystal reports 9, visual studio 2008, and oracle 9i in this project I'm doing. My crystal reports pull data from an oracle database, and are displayed on a CrystalReportViewer on a windows form. How would I make this connection using vb.net code?[code]...
View 1 RepliesAm using this code to connect to an SMS server to send sms to mobile phones but am getting stucked at the the bold like below:
[CODE]:.....................
With a function being passed a full path to a file, such as C:someFolderanotherFoldersomeXML.xml, determine whether the folder exists. Is there a smarter/better/more elegant way of doing this? Here is my implementation:
[code].....
I'm trying to develop some AI code for a game I'm creating. I have a list of x,y coords and I need help figuring out what I can use/do to build the shortest path between any 2 points in this list. I would like to build a function that I can pass a list of valid X,Y coords to use when generating the path, start point, end point, and have it return a list of points, which would be the shortest path between the start and end point, using the list of points supplied. I have looked at A* and Dijkstra's, but am having problems implementing the algs in code, as all this seems graph based.
View 3 RepliesI am working with Vb.Net 2005, at run time I receive the error;
UnauthorizedAccessException was unhandled Access to the path 'F:New FolderTest' is denied
and this path does exists..
Note:
Label1: 'F:New FolderTest'
Label2: 'F:New FolderTest2'
[code]....
My primary task is to read all the zip files in folder Test, unzip them and copy them to folder Test2.
I enter a valid picture path run this code and get error in the sqrt line
CODE:
How to fix ?
Problem drawing dotted path lines, with even dots along the path line.I want to draw a path line that can be any shape (square, round, outline etc), and along this path line I want even dots to appear.
I also want to be able to resize the shape (as in the example attached)This is very easy to do using "DrawPath" and defining points for the path and using a pen defined as dots.The problem I have is I want the dots to be evenly placed along the path, on any shape or size I draw.In the example I have created, I create a square with 4 points and draw a dotted path.There are 2 buttons that allows me to resize the square (larger or smaller) this helps show the problem more clearly.
The path starts at the top left corner and finishes back at the top left corner, the dots are evenly placed along the path, except the final dots at the end of the path. (Sometimes the dots are even and other times they are not even).The shapes I want to draw can be any size and any shape, but I have used a square in this example to show the problem I have. point me in the direction I need to go that allows me to draw the dots and give the impression that they are even all along the path, for all shapes and sizes.
In the pictures below if you change the size of the shape, one will have even looking dots, the other will not.
[Code]...
i used the following codes:
private mediapath as string = "C:movie.avi"
private form1_loads blah blah blah
[code].....
I am trying to create a function to convert a mapped drive path to a UNC path. I did some googling and found several different pages on the matter. I am most interested in the first one, but I cannot seem to get the code to cooperate. Since the original post was in C#, here is my VB.NET conversion:
[Code]...
We have a VB.Net application which works fine in our tests in different Windows XP SP3 machines. However there is one machine in which is displaying this error:
Unable to connect to any of the specified MySQL hosts
Using the mysql command, we can successfully connect to the database. We already checked for any other application or firewall that could be blocking the connection but it seems fine. We also reinstalled the system (no errors during the installation) but the MySQL error message doesn't change.
The system settings are exactly the same as in the other computers. We are using "localhost" as server in the connection string. The "hosts" file has its default values (nothing strange in there).
I'm working on an application where I'm using an webcam image. I have code that works when using the built in iSight (It's an Apple running boot camp windows 7) camera. However after installing a second USB powered Microsoft Life Cam I am unable to connect to this second camera. When runnign this code I only ever get one input device:
Private Sub LoadDeviceList()
Dim strName As String = Space(100)
Dim strVer As String = Space(100)
[Code].....
I am trying to read and display a file using MapPath as follows :
Response.ContentType = "Application/pdf"
Dim FilePath As String = MapPath("../Document/123.pdf")
Response.WriteFile(FilePath)
Response.End()
This procedure will work fine and display in the browser. However, if I save the file to C:Document123.pdf, how can I access this file using relative path in MapPath function. Is there an option to access the file which is saved out of IIS server? I am using vb.net 2003.