I guess the default path for the SQL Server files is located at:
C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDATA
Is there any way of reading the default directory with the .NET Framework?
I am deploying my application on a 64 bit windows 7 system (setting the platform property to x86) , after the installation process the app needs to set its connection string in the config file; and this is where I am having issues, the app is not able to write to the config file if/when its located under the program files directory (no admin privileges??), the app works fine when installed on a public folder.Please let me know how to give admin or write access to my app when its installed to the default program files directory
View 2 RepliesI am retrieving some pictures from the images in my Picture Box on the form I added my "images" folder to the bin/debug folder , and used the code for retrieving images from this directory.
Dim myDir As String = Application.StartupPath & "images" '-- my folder for images
I don't know of the default server name. I need to work on our project to connect vb.net with wamp server, and for that to happen, I must know the server name that I will put on the codes.
View 3 RepliesAll I am trying to do is write a simple program that will let me choose a directory and get a listing of all files in that directory and its sub-directories and show it in a RichTextBox. I got as far as being able to select the directory but when I click "OK" I get "access to c:documents and settingsstevedesktopmp3 is denied".The code I am using is listed below.
Imports
System
Imports[code].....
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?
I would like to get a list of sql server instances on a computer but need both default and named instances.In the post: [URL] the code works perfectly for finding the default instance of SQL Server but it doesn't show other running instances (named instances). On my development computer, SQL Server Express, SQL Server 2005 (both named instances) and SQL Server 2008 (default) are all running but express and 2005 don't appear in the combobox dropdown list.
View 3 RepliesI am using the following code for creating the folder on FTP server ; But its not working in my case :-
[Code]...
In the above case i am not getting any error but when i am going to upload a rar file then it is giving the following exception The remote server returned an error: (550) File unavailable (e.g., file not found, no access). And File Upload code is given below
[Code]...
We are developing our application using MS Visual Studio 2008 VB .Net. We have to use Active Directory Server for authenticating the user logging into the application. Does any one has code samples intergrating .Net and ADS?
View 3 RepliesHow can I get a list of available webservices from a server/directory?For example from:[URL]Which should at least give me ReportService2005.asmx I was wondering if there wasn't a ReportService2008.asmx
View 1 RepliesNow, i found this code to upload a file.
Dim request As System.Net.FtpWebRequest = DirectCast(System.Net.WebRequest.Create("ftp://quex.dk/file.txt"), System.Net.FtpWebRequest)
[code]....
I wrote some code yesterday which shows a directory listing of an FTP server and if you click on a folder it will show that directory and their is a back button. But I dont think it is efficient and I can tell there will be a lot of errors.
Imports SylentUpload.Utilities.FTP
Public Class Form3
Private DirectoryHistory As String = "/"
Private DecryptedUsername As String
Private DecryptedPassword As String
[Code] .....
I am trying to copy a sql database into a vb.net application however it is not maintaining the default values when I do this. Is it possible to import the default values and have them automatically assigned when creating a new row or do I have to manually assign the default values again in my code?
View 1 RepliesI want to associate my program with a certain filetype. I know how to do this, but my question is: how i can i see witch file is opened?
View 1 RepliesI am trying to retrieve all the users in the Active Directory and dump into a Sql Server Table(Sql2008). I was able to search one employee at a time but could not able to search all the employees in the Active Directory. Basically i want to retrieve 1.SamAccountname and 2.Employeenumber. I am using VS2010/VB.NET/ASP.NET.
View 1 RepliesI am trying to retrieve all the users in the Active Directory and dump into a Sql Server Table(Sql2008). I was able to search one employee at a time but could not able to search all the employees in the Active Directory. Basically i want to retrieve 1.SamAccountname and 2.Employeenumber.
View 2 RepliesMy web and sql db are on two different servers. I'm developing a component in my vb.net web app which uses sql dbmail to send mail. That part is already working but part of the requirement is to allow the users to add an attachment to their email. SQL dbmail requires an absolute path for the email attachment for example, in sql:Declare @Attachments nvarchar(max)
Select @Attachments = 'D:emp ewreport.pdf'So currently in my vb code I have the following:
[Code]...
I wanted to create some CLR functions that will access Active Directory, but I discovered I can't add a reference to "System.DirectoryServices" to my CLR project.
I googled it, and found that I have to add the AD dll as an Assembly to the SQL Server. Like so:
CREATE ASSEMBLY [System.DirectoryServices]
FROM 'C:WindowsMicrosoft.NETFrameworkv2.0.50727System.DirectoryServices.dll'
WITH PERMISSION_SET = UNSAFE
GO
The problem here is that I have to set the "PERMISSION_SET = UNSAFE" to the dll... this means that I have to set the database as "TRUSTWORTHY ON", and this opens a can a worms!
I have done VBscripting the past and I have actually made this work in a script however I am trying to convert it to VB for the client so that it has a nicer interface and basically is a better program. There are several parts to this program but I am stuck on this part right now. I am attempting to get a list of all servers from Active Directory and then sort them by type. The program will run however it will not produce any results. Its just an empty file. I figured the problem was with my filtering but I just don't understand why this will not work. I have written it in two different ways and get the same result each time.
Imports System.DirectoryServices
Imports System.DirectoryServices.ActiveDirectory
Imports ActiveDs
[Code]......
I have made a web browser program and would like to know how to set it as my computer's default program for opening web pages
View 4 RepliesA variety of files (pdf, images, etc.) are stored in a ntext field on a MS SQL Server. I am not sure what type is in this field, other than it shows question marks and undefined characters, I am assuming they are binary type.
The script is supposed to iterate through the rows and extract and save these files to a temp directory. "filename" and "contenttype" are given, and "data" is whatever is in the ntext field.
I have tried several solutions:
1) data.SaveToFile "/temp/"&filename, 2
Error: Object required: '????????????????????'
???
2) File.WriteAllBytes "/temp/"&filename, data
Error: Object required: 'File'
I have no idea how to import this, or the Server for MapPath. (Cue: what a noob!)
3)
Const adTypeBinary = 1
Const adSaveCreateOverWrite = 2
Dim BinaryStream
[Code]....
This works, but the file should be saving to the server instead of popping up save-as dialog. I am not sure if there is a way to save the response to file.
Multi-User Chat Program (Server & Client) with Main Server?
View 1 RepliesI made a simple TCP server (I've found the example on the web) in VB to receive data from about 40 TCP clients.The clients are not synchronized but sends data about every 18 minutes; the problem is sometimes several clients sends data at the same moment, so I can't receive data.I also made a second program that reads the data (server program writes data on a file, read from the second program) scheduled.
My question is this: I've seen on the web examples about Multithreaded Server Socket Program, so I suppose this could manage my 40 clients (but now the clients are syncronized and send data at the same time in client mode) or is better get data (I have a central client that asks data to all 40 devices in server mode)?
Second question: can I make a single program where I run both TCP client and TCP server at the same time?
It�s there a way in VB to get the dominant Webbrowser, antivriusprogram, firewall, mailprogram or other things that can be set as default?!
I have search on the internet but probobly not the right refrences, with no success?
I have made an app named photo viewer so how to make it the photo viewer Default program in user computer when he install it in his computer?
View 5 RepliesIm not sure of the dll to use for fire fox instead of using VB's Default web browser or if there is a way to use firefox in vb2008. If there is please let me know. I would rather use the fire fox in a program instead of the default that is internet explorer web browser.
View 10 RepliesHow to create login Form Authentication with Active Directory?
View 7 RepliesI'm a beginner. I recently developed an application in C#. Now I wanna develop its setup. I read a few articles online, followed them, found it very easy. I also changed the default location of application folder from C:Program Files to C:. My application folder is containing a few folders besides exe and dlls which I added manually.
Now here the problem starts, when I install the application and change the location say from c: to d:, my files (all files including exe and dll) are going to user's given location. But my folders (all folders in application folder) are going to c: (which is default location given while creating setup). But I want output files and that folders at same location
I have Excel 2003 and 2007 loaded on my computer. When I open an Excel file, it is defaulting to 2003. How do I check to see what the default program is for opening xls files and change this to 2007 in my code? I have already done the following manually:
1-Open My Computer
2-Go to Tools --Folder options
3-Click the File Types tab
4-Scroll down to the XLS file type and highlight it
[code]....
However I am not convince that its defaulting to Excel 2007 when I run projects in VB as I am seeing the "File Conversion" prompt when file are open.
I have two buttons. One to upload a file, and one to run the program after the file is uploaded.
How do I default the second button at the start of the program, then enable it after the file is uploaded?