I am trying to import Oracle tables to SQL Server. Now i am specifying user name and password for oracle. But how to prompt oracle to ask user name and password when its DSN is selected and store in variables(user id and PWd)
Through out this process i am using ODBC connections.
I am reading a csv file in to a datatable in vb.net and making a few checks and appending an extra column. I then want to perform a bulk insert using microsofts Oracle.DataAccess (no choice in this) to an Oracle database. what would be the best way to perform this as there is no bulkImport like in SQLserver.
View 2 Repliescan you tell me,how can i add a provider for oracle(Microsoft Provider oledb for oracle).Actually i had Microsoft ODBC for oracle but i want to add a provider above mention.
View 2 Repliesi Use "Imports System.Data.OracleClient .. Private conn As New OracleConnection()" to connect to my Oracle database..but when i put my program to another PC I need install Oracle Client on it...is there some other way how to connect to Oracle DB without installing oracle client to client PC?? (Database is on Server an program is on client´s PCs)
View 2 RepliesI'm creating a BASIC application, and I can't figure out how to save a user selected file (FolderBrowserDialog) to a location selected in another dialog (SaveFileDialog).
View 5 RepliesHow can i make it so vb can run a cmd prompt and all the output will be displayed in textbox1.
View 2 RepliesIn my Windows Form I have a ComboBox that is filled by a Stored Procedure with a list of names. I have the Combobox set for AutoComplete to "Suggest" and From "ListItems". When a user starts to type in and the AutoComplete does not find any matches in the listitems the user can tab out of the ComboBox and leave what they typed in the combobox even though it is not one of the Valid Items. Is there a way to check the Comboxbox to make sure of of the selected Items has been selected?
View 3 RepliesI have created a VB 6.0 Active-x control for an ASP.NET application.The control is responsible for downloading files from Server to Client machine and installing them.In general will have a set of applications needs to be run in sequence order.Every time i try to install an application it asks for UAC prompt and then proceeds to installation.Functionally it is working fine.But my client requirement is UAC prompt should come for the first process only and should not prompt for the following installations.I am using CreateProcess() API method for installations.
View 5 RepliesI am trying to figure out how to have a prompt open up when I open a program.
I am trying to set a size to an Array and I want the Prompt to ask for the size that is needed.
I need to sort my code to work for Visual Basic 2008 Express Version, I am trying to open the Command Prompt through Visual Basic and make Visual Basic run through the Command Prompt. By this i mean i need Visual Basic to Send Messages from a text box on my design to the command prompt, e.g to make my program go through the command prompt to do the basic hide files in a picture.
[Code]...
I'd like to ask about the way in ASP.NET VB to detect the changes in stocks prices, if the price inceased, the containing cell inside the grid blinks in green, decreased will blinks in red? ex: if the price now 10.00$ and increased to 10.01$ the containing cell will blink with 1 second in green..
View 1 RepliesI am not a developer but I like tweaking with system, I am recently trying to create an app that can reset admin password, but the problem is that I am not able to run the following command from standard account.
net user user_name * I know it is because of security reason but there must be some way so that software developer can tweak it, can someone guide me..[URl]..
I'm using VS2008, targetting the 3.5 framework.I'm getting sick of having to create a Control, then manually rename it later. Is there any way to force the Designer to ask me for the name in a Dialog as it is attempting to create the Control? Or even to autofocus to the Control Name in the Properties menu?
View 2 RepliesI dont know how to invoke a cmd prompt from vb.net window. from the vb.net i have tp ping an ip adress of a system in the cmd prompt.
View 3 RepliesThe question is self-explanatory. It would be great if the code was one line long (something to do with "Process.Start("...")"?). I researched the web but only found old examples and such ones that do not work (at least for me). I want to use this in my class library, to run Git commands
View 1 RepliesI have a form with a tabcontrol. Each tab has a formview for adding/updating data. The user could have multiple formviews open at once. I would like a way to prompt the user to save if they are leaving the screen.[code]...
View 3 RepliesIn my application, i have put a question on form closing if the user wants to save the changes?. But right now, i have just put it in default whether they make changes or not.I thought of prompting it on text change.. but the text automatically changes on load as it retrieves data from sql server.
View 15 RepliesWhat I have done so far is place the compiler inside the bin of my project folder, inside the Debug folder. I managed to call the cmd shell but the problem is whenever I pass commands to that cmd shell, it doesn't work. What happens is it opens a cmd shell and when I pass commands on it, it opens many other shells.[code]...
View 1 RepliesBefore posting this question I have carried out a few searches on this forum but I am afraid I am struggling because I am very new to Visual Basic and although I do have some programming background, yesterday was day 1 and I took a web tutorial and watched a few video tutorials. (Long way to go!).
OK to the question and I know I should really not ask 2 but It's better to get them both in one post I think.
I want to build a small utility to run a form in full screen to basically hide an old application running in the background.
My old application is a database (Non VB code) which works very well but while it batch exports a lot of data the software displays some pretty ugly windows, I want to call my VB utility from a command prompt with 1 or more switches to display some meaningful text about where it is in the routine.
I also want to be able to send a switch at the end to close it completly.
Q1 - What is the best way to manage command prompt switches ?
Q2 - How do I make it close itself ?
how to make a prompt
View 2 RepliesWindows Command Prompt with VB
View 1 RepliesI've mainly been doing ASP programming up 'til now, and I have a pretty simple question.
I'm creating a program that will copy a selected file to a selected directory, and I want to store recent files/dirs so that they can be selected from a combo box. I was planning to just create a settings with "files" and "dirs", and just store the strings as | separated values (since that's an illegal file character).
I'm selecting a ListItem as I add it to a ListItemCollection. Then I use that ListItemCollection as a datasource for a DropDownlist but the Selected List Item is not being selected after databind.[code]...
View 3 RepliesI'm selecting a ListItem as I add it to a ListItemCollection. Then I use that ListItemCollection as a datasource for a DropDownlist but the Selected List Item is not being selected after databind. Here is an example of the code:
[code]...
I'm trying to get this to work so I can return only a list of items, instead of a list of items and the selected value. Is there a way to make the DropDownList select the selected ListItem from the ListItemCollection (or any other type of collection)?
I am looking for an easy way to have a command prompt like interface for my form. The idea is to make it an interactive text interface. Here is an example of what it might look like > Hi Hello! > How are you? I am fine! >_So it's very much like a chat. BTW, I am not referring to what the example is, just the concept of a command prompt, that I can create a scrollback buffer for. Very much like a MSDOS prompt.
View 5 Repliesis it possible to adjust the size of the colordialog prompt? is it possible to adjust the size of the sample color boxes within the colordialog prompt?
these are both for vb.net in winforms
I have this problem where is wont let me create and files through the command prompt via echo xxx> C:xxx in Visual Basic. If I do it sepoaratly and run the command prompt as admin (This is not using vb at all) then it will work. I have tried putting my vb app to require previlidges at both levels at different times, not at once, and I still got the same thing.So is there a way I can use the comman prompt through vb, but also making the command prompt being an admin without turning off UAC?The code that will not work is this.
Shell(Environ$("Comspec") & " /c """ & WDir & "ToolsMediaInfoMediaInfo.exe"" --output=xml """ & WDir & "ToolsMediaInfoMediaInfo.xml""")
what line i get this error " Argument 'Prompt' cannot be converted to type 'string' "
Try
If movieTxt.Text <> Nothing And ratingCmb.SelectedIndex <> 0 Then
For a = 0 To i
[Code]......
My application in asp.net using vb.net scripting generates a file with system processing outputs, responding to a button click. This file is stored in a folder in the server, and I would like to start a download of this file automatically for the user. How can I do it?
View 1 RepliesI'm writing the following bits of code for a SaveFile Dialog box in Visual Basic 2010.NET. The code works well as the XLSX file is created and opens in Microsoft Excel. However, the problem that I am having is that if the program overwrites a file, the user is getting two prompts. One prompt is from the program's own SaveFile dialog confirming the choice. The other is from Microsoft Excel asking you the same. It's as if the program is running in the background.[code]
View 1 Replies