Accessing SQL (.mdf) Files With VB Program
Feb 10, 2012
I am attempting to access an SQL (.mdf) file I have created with the Database Explorer utility of Visual Basic. Here is some relevant code from the program:
Imports System.Data.SqlClient
Dim Database01 As SqlConnection = New SqlConnection("Data Source=C:Test01.mdf")
SMUDatabase01.Open()
At this last line of code, I get the following error message:
"A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)".
I am using Windows Vista OS and the firewall is turned off.
I suspect the problem might be the settings (such as connection strings) within the app.config file, but if so I am unsure what the correct coding within this file should be to access the file.
View 8 Replies
ADVERTISEMENT
Jul 20, 2008
how would I go about making the user access different local SQL databases. As in they use a GUI program to access / read / write data in a database but can also use that same GUI program to do the same to multiple database files.Is that sort of setup easy to integrate into a VB program? or does a VB program by nature only try to access one database? To integrate the open and close dialogs into a VB GUI in terms of different database files, is there much involved?
View 10 Replies
Feb 1, 2010
I need to show a grid of saved projects (compare "orders") in a datagrid, where the projects are saved in an Access 2000 database with a similar schema as follows:
ID Name Country_ID Plant_Type
1 'Test' 1 1
2 'Second' 2 2
Let's call the file "Projects.mdb". This is then showed in the datagrid as:
ID Name Country Plant Type
1 'Test' 'Germany' 'Free Range'
2 'Second' 'France' 'Inclined Roof'
where the countries and "Plant Types" are fetched from a different table in a different .mdb file (also Access 2000, call it "Language.mdb", although there is a lot of different background data in it), depending on the current user's language preference. It is unfortunately not an alternative to merge these .mdb's into one file.
To be able to show the datagrid I have so far linked the tables from "Language.mdb" into "Projects.mdb", but this screws up when the project is being installed on another computer with the .msi file i created (we'd like to have this easily packaged and installed), as the "Language.mdb" doesn't exist on the linked path on the target computer (Basically the problem here).
I can come up with the following solutions:
Force all users to install on the same path, so that the links will work (undesirable)Use connection strings in the query as shown here on MSDN (still trying this out, but I need to work on the details)make a post-install script that relinks the tables according to the correct path.
View 3 Replies
Oct 8, 2009
I want to know that is there is anyy way to access the video files in vb.net .I know the WMEencoder but tell how to get it in our program
View 4 Replies
Jul 29, 2009
In this program i am making, i want to get information from a text file. but i need to get it from 2 different subs. one sub loops and gets the information every loop and other gets it when a user clicks a button. when they get it at the same time, i get an error saying that it is already being used by another process.
View 7 Replies
Jun 1, 2011
My problem is that I have a program which needs to access images for multiple choice questions, hundreds of them. Now when I publish the program it is not taking the images with it. I have read some information by 'kleinma' regarding publishing and he says to right click on the Bin and click include in project, but when I do this there is no command in the menu for this.
I have included all of my image files in the Bin and have also added them using the resource editor, but to no avail As I have indicated it is the Express edition, could this make a difference
View 5 Replies
May 1, 2011
I have created a sub folder (named 'Data') under my project through the solution explorer. I also have created a text file (data.txt) inside the new sub folder. This text file is used to store information such as settings and connections.
I can check the file using the full path. However, I want to avoid errors such as moving the project folder to a different location. Is there anyway to check using a relative path? File.Exists("~Datadata.txt")
Or is it better to create it under Application.StartupPath?
View 10 Replies
Nov 20, 2009
For a project, I need to extract all the frames of an AVI video. This I have accomplished by with free program. The problem: it took a 30 second clip and spit back 5400 some frames, and the image only changes every 20 frames or so. I really only need about 270 frames, but I didn't want to go through each one manually. So, I wrote a small program using Visual Studio 2008 and VB to open each image in binary and compare it to the one before that. If there is a discrepancy of more than 55000 (to accommodate slight errors in capturing), it leaves the file be. If not, it deletes it.
After much troubleshooting, I got it all to work. I ran it on the directory containing the images, but when it finished, only the first image remained. I checked into it, and found that the FSO loop I have set up to loop through each file was pulling the files in apparently random order. It will give me the image "bg(01).bmp" and then immediately "bg(1362).bmp" and so on. And the order changes every run.
I tried setting up an array to generate a list of all the files and then sort them, so I could pull off the name of the file, then the next one, ect. but it took over 3 hours to finish processing the array, and then It was using a huge chunk of RAM.Is there some way to "force" vb to pull off files in alphabetical order? here is my, code, it belongs with a form. fPath is a global variable, simply pointing to the source directory.
[Code]...
View 2 Replies
May 8, 2009
My application (vb.net) sometimes throws an "access denied" exception when attempting to delete files in the AppData folder and I'm not sure why.I confirm that the file exists before attempting to delete it and have not done anything to make it readonly, etcThe interesting thing is that it seems to go okay when I'm logged in with Admin rights
View 2 Replies
Apr 18, 2012
How can I prevent debuggers from accessing my program?
View 2 Replies
Jan 1, 2010
Suppose I want to broadcast CTRL+C to my program without using complicated code (accessing Windows API) to do it.
View 3 Replies
Jun 10, 2009
I have VB project and I tried to use PUBLISH feature.It seems to create nicely some kind of setup program, but the setup program does not ask where to copy files (it does not seem to copy filesto target machine "PROGRAM FILES".)Is this setup program somehow different from usual installers?
NOTE: I want that app files are installed to Hard disk( from USB stick source)Is the signing recommended or necessary? My App is pretty simple, its just using access DB + printer api, should I still sign?
View 2 Replies
Dec 26, 2009
I am trying to retrieve file details from files in the Program Files folder. I receive an error while trying to retrieve file details.
Dim sFileName As String = ("%ProgramFiles%Windows DefenderMSASCui.exe")
Dim Info As FileVersionInfo
Info = FileVersionInfo.GetVersionInfo(sFileName)
Msgbox(Info.ProductName.ToString())
I receive file not found error at 3rd line. But if I change the path from "%ProgramFiles%Windows DefenderMSASCui.exe" to "c:Program FilesWindows DefenderMSASCui.exe" it works fine.
What should I do if I want to retrieve file details from the path which includes a "%" character?
View 2 Replies
Jul 30, 2009
Having a slight permission problem with Win 7 I am guessing it will be the same on Vista but work fine on XP (yet to try)But my program is sitting in: C:Program FilesCompanyProgram And its trying to create new files alongside itself in the Program Files area but bombing out which I know is permissions. If I go there to create the file myself it comes up with a UAC prompt and when I hit allow it works fine but obv the program can't do that byiteslf so bombs out.Is there anyway I can over come that without the user having to grant admin rights to the program each time it starts or do I have to write data to another place?
View 4 Replies
Dec 11, 2011
I wrote a program to download and play AVI files the files are large in size and long time wise. I have the files playing as they are being downloaded but i can't see how long the file is or seek reliably. i was reading that the AVI headers are in the last 512kb of the AVI file *why would't they put it at the start* lol so my question is is there a way to download the last 512Kb of the file i'm downloading. i have the Bytes Read and Length of the file while its downlaoding i'm just not sure where to go from there, or how to do it atleast. If i had the length in time of the Avi file i could set the trackbar to be able to seek properly. or if someone has an idea how i could get the time of the video by using fps and some math i could prob do it that way too but idk how i would tell how i can find how many kb are in the fps i'm sure it changes so think that way is't going to be reliable. how to get the last 512kb would be the best option not sure if it can be done even.
View 4 Replies
Mar 26, 2011
I'm coding this neat little project that's kind of a hack into the SanDisk U3 Cruzer's ability to have both a CDFS and FAT32 File System. This is helpful because the program is burned to the CDFS (It's basically slip streamed as an .ISO in place of the original U3 .ISO), and the settings files (which I've developed as text files) are placed on the root of the flash drive. The program itself is VERY simple actually, except I'm having a slight issue that's really driving me insane:
The drive path of the Flash Drive won't be the same from computer to computer. I.E... The files are "UAI.txt" and "UInfo.txt". The root of the drive on my comp is "I:", but on my laptop is "F:". So if I program the path from my computer as the absolute path, an exception is thrown when the path changes on another computer. I cannot have this happen. It is probably THE MOST crucial element to this program. How can you save and read info if you can't find the files? =P
So I've gone through so many threads and forums trying to find a batch of code to allow me to make the path relative. I've found the following code (modified, of course). It works PERFECT in Debug, but throws an exception once packaged to the CDFS partition:
[Code]...
View 3 Replies
Jan 8, 2010
In class i saved my program in with load of other test programs for the same assignment and got everything mixed up i finally figured out what was what and loaded the program in Visual Basic. Now my program doesn't recognize one of my forms when i try to access the design view of it. I hit run for the hell of it and the program runs with errors of course but the form1 "the missing one" shows up with all the buttons etc and i can use it.
Heres the link to the files. [URL]
View 3 Replies
Sep 20, 2010
I have a program where a lot of the required information for it is stored in text files. I simply read this information into large arrays. However, I don't think it's necessary to load all the information each time. Rather, it would be more efficient if I could simply search through a list of items to find the one I need and then use the data from it, or to find a similar name and use it elsewhere.
Would I be right in using a database? And is database programming done in SQL? I have a book on it telling me to use the SQL Server (IIRC), so I shouldn't be doing it in the VB.NET Express GUI?
Here's an example of what I would do:
Hex = 03 00 => dex number 003
Search in file Pokemon Dex Numbers
003 returns Bulbasaur
Check Bulbasaur base stats in the base stats file
etc
So basically I'm reusing a lot of information. I think a database would be best and it would all be internal right? I'm getting complaints about access denied to a text file (since it's stored in the program directory in the program files).
So to cap up the few questions I have:
-Databases are done in SQL and not inside the GUI?
-Databases would load internally?
-I could search a database without having to load it into like an array or something?
View 2 Replies
Jun 9, 2011
Im having kind of trouble looking for this info, but i created a POS program that when i install it, it install under Local SettingsApps2.0labla
So what i want to know if how can i make my system install like any other program, "Under Program Files/POSystem/" like so
View 2 Replies
Apr 20, 2009
Im designing a program that will read from various text files (preferably RTF files) and then put them into the RTF box in the program when a button is clicked.
Here is the portion of my code that i am referring to.
Try
Dim fileText As String = My.Computer.FileSystem.ReadAllText("c:\" & selectedHero & ".rtf")
infoDisplay.AppendText(fileText)
infoDisplay.Rtf.Format()
Catch
MsgBox("Selected Hero currently has no File with us.")
End Try
Now heres the problem. In the file i have a few pictures and its formatted and what not. I thought since its a RTF file and the Box is RTF it would auto format.... but anyways. It appears like this in the RTF Box.
{\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\fswiss\fcharset0 Arial;}}
{\*\generator Msftedit 5.41.15.1507;}\viewkind4\uc1\pard\f0\fs20{\object\objemb{\*\objclass Paint.Picture}\objw3000\objh3000{\*\objdata
[CODE]...
Ok so im not sure how i can read from a RTF file and put it in the RTF box with the right format....Ive been searching around for a while.
View 9 Replies
Dec 28, 2010
Is it possible to build a program through VB that creates a folder in program files folder and behaves like any other usual program?If not, though witch program can i make this?
View 6 Replies
Jun 15, 2009
I'm making a presentation program. It's a bit like PowerPoint, but less complicated and for a different purpose.
All files used in the presentation (like images, texts and sounds) should be put into a single 'file-package'. This package should later be opened by my program, which should be able to use the files from the package. (Just like PowerPoint creates a single file with all images and sounds included, which can be loaded in PowerPoint on a different computer.)
Actual compression for the file is not really needed. It could be sort of like a tar-file.
View 1 Replies
Mar 6, 2010
I'm trying to create an installer like application. Here is what its supposed to do: create a directory in C: and name it batch. Then copy the files from the folder and move it to the C:atch directory. But the copying of files doesn't work.
How am I supposed to put the exact directory in here if that exact directory does not apply to all.What do I do with it. If the file that is to be copied is from: E:Documents and SettingsRewMy DocumentsVisual Studio 2008Projectsatchatch[code]...
View 1 Replies
Feb 3, 2011
I have got a lot of documents that gets automated in Word format which is great, but also I would like to be able to create and save documents in pdf format.
I understand there is software for converting and creating pdf documents but I want to know if I would be able to program any simple documents for a start myself in pdf format.
View 1 Replies
May 1, 2009
I am just trying to learn Visual Basic in 2008. I need some help theory about dll and ocx files. I have seen videos tutorials, and in some of them they use some additional files. i.e. MSwinSck.dll, or DVD .dll ect. But lot of these files does not exist in my program, noone is telling about these files and where to install them or how to get them.
[Code]...
View 6 Replies
Dec 17, 2010
I would like to embed an RTF file that can be chosen with the OpenFileDialog control into my form.
View 11 Replies
Jan 18, 2009
Ok first i want to say im sorry if i put this inthe wrong section i have no idea what the thing im doing is called "I call it a notepad" Ok i made a notepad saved it ect now i got the .exe file i tryed making that my default notepad but when i click on a .txt file i get an error massage
C:Documentsand SettingsUserDesktopTry.txt is not a valid Win32 application
i dont get the point in making a program and not using it..The Notepad is only a simple one "My first project" Only has features like
[Code]...
Edit 1 If anyone can tell me the diffrence between TextBox and RichTextBox would be nice also
View 19 Replies
Oct 23, 2009
I have audio files in the directory of my program.. Can I somehow code the audio files within my program? Like they compile within my program and are called from within the program..Is this what my.resources is for? (I don't know anything about my.resources..
View 4 Replies
Aug 15, 2011
I have already posted a thread regarding this but no one has ever shed a light upon it. I want a program that searches for files (.docx, exe, ppt, txt) from all folders.
View 7 Replies
Jun 12, 2009
I am creating a small project for my company ie; document controller. In this project a small module is reading documents. I already made reading of other documents like word,text, etc. But I am unable to create a program that can read pdf files. My main aim is to find out the searching a word available inside the file.
I tried with some codes but it showing some unexpected outputs like that
xref
6 19
0000000016 00000 n
0000000859 00000 n
etc......
give me a source code with that I can read the pdf file effectively.?
View 6 Replies
