DB/Reporting :: ODBC To SQL Server 8 Shows List Of Procedures But Not List Of Tables Or Views?
Oct 27, 2009
In VS 2008, VB.Net, I am successful connecting to a local SQL Server (version 8) and seeing all tables/views/procedures in Server Explorer. The local OS is Win XP Pro SP3. I created an ODBC data source to a remote SQL server (also version 8) with a database of the same structure as the local one. The connection tests out ok. The remote computer runs Windows Server 2000 SP4. In the VS 2008 Server Explorer I add this ODBC source. When I click on the plus-signs to expand items, neither the tables nor the views show anything, whereas the full list of procedures appears. Is it the old SQL Server version? Is it the old Server OS version? Something else alltogether?
View 2 Replies
ADVERTISEMENT
Oct 27, 2009
In VS 2008, VB.Net, I am successful connecting to a local SQL Server and seeing all tables/views/procedures.I created an ODBC data source to a remote SQL server with a database of the same structure as the local one.The connection tests out ok. In the VS 2008 Server Explorer I add this source. When I click on the plus-signs to expand items, neither the tables nor the views show anything, whereas the full list of procedures appears.How can I see the lists of tables and views in Server Explorer for an ODBC source?
View 1 Replies
Dec 30, 2010
This is what I'm sure will be the first of many noob-ish questions from yours truly... I'm studying as a mature student for a Computing Degree (encompassing web design, hardware, programming and systems analysis). The programming seems to be my weak spot this year. I enjoyed C++ last year, doing basic console applications, but progamming visually with VB in Visual Studio 2008 I'm struggling!
[Code].....
View 12 Replies
Oct 20, 2009
I have just started to learn how to use SMO in some cases. Below is some code I found from a site to list the servers and databases for each. What I would like to do is go a step further and list all of the databases and stored procedures in their own listboxes when I select a database. I would like to not include the system ones or at least have a checkbox to decide to include them or not. I searched and could not find how to do this.
Here is the code I have so far:
Imports Microsoft.SqlServer
Imports Microsoft.SqlServer.Server
Imports Microsoft.SqlServer.Management
[Code]....
View 2 Replies
Nov 5, 2011
I wish to make a project where a teacher views a list box with a list of students of a class. When he selects a name from the first list box the second listbox would change its data to show the grades for that one student.
View 10 Replies
Aug 5, 2010
I have one application create tables in database dynamically during run. Another application need to find all these tables' name in the database. how should in do in vb.net
View 7 Replies
Mar 12, 2009
I have used list views for a project. I have used sum items on the items. The sub items are prices of products. I will need to use these sub items to come up with a total.Also, i have used to listviews, for a smoother look and feel. You click the product which then is removed from the list view and added to the second one. Would this also "move" the sub item across to the other list view?
View 1 Replies
Mar 10, 2009
I am trying to learn how to work with the different controls in Visual Studio for VB.Net in particular the List View and Tree Views. I don't have any code to show as I am not working on anything in particular just messing around with it to learn what the different controls do that weren't covered in my Intro to VB.Net class last semester.I would like a clearer explanation on how to actually use code for these controls. In particular adding and removing items from the List and Tree Views using code.
View 1 Replies
Aug 4, 2009
I am using VB 2008 and wonder if there is a way to draw lines between the data elements in two listviews to bind the elements together?
View 1 Replies
Mar 17, 2008
I am trying to test a number of stored procedures through SQL Server Query Analyzer. But am stuck when I try to test stored procedures that contain Output parameters.
Code:
DECLARE @Counterbigint
DECLARE @GUIDuniqueidentifier
exec usp_tbl_User_Add @Counter, @GUID, 'UserName', 'First Name','Surname',
[Code]....
When I put the Select statement though in the 'usp_tbl_User_Add' stored procedure in works fine and gives me the correct values.
View 2 Replies
Jan 27, 2011
I have a small problem i'm trying to fetch list of directoies from 1 special ftp server wich does not support LIST command i was try this code and it works for all ftp server i have try exept this special one :
'' Get the object used to communicate with the server.
'Dim request As FtpWebRequest = DirectCast(WebRequest.Create("ftp://" & txtFTPhost.Text), FtpWebRequest)
[code]...
I'm getting error 502 which means command is not supported and app crashed. I would just simple said leave it but i have try normal ftp clients like FlashFXp and it works just fine (i can see error in the log but it just pass it and show direcoties)
View 4 Replies
Jun 23, 2011
Is there a way to get a list of ODBC drivers that are installed on a Windows XP machine from .NET?
I basically would like to see (in .NET) what is in:
Control Panel->Administrative
Tools->Data Sources (ODBC)->"Drivers"
Tab.
View 1 Replies
Jun 8, 2011
Is there any way to pass multiple values (a list of values) to a query via ODBC Parameters in VB.Net?
For instance, is there a way to create a query along the lines of:
-- vb.net has something like Dim itemNumbers As New List(Of Integer)(SomeCount)
SELECT Cost, Description
FROM MyItemList
WHERE ItemNum IN (<my list of item numbers>)
View 1 Replies
Jan 21, 2009
Option Explicit
Private Declare Function SQLAllocEnv Lib "odbc32.dll" (phenv As Long) As Integer
Private Declare Function SQLFreeEnv Lib "odbc32.dll" (ByVal hEnv As Long) As Integer
Private Declare Function SQLDataSources Lib "odbc32.dll" _
(ByVal hEnv As Long, ByVal fDirection As Integer, ByVal szDSN As String, _
[code].....
View 1 Replies
May 24, 2011
Can anyone tell me how to list ODBC and OLEDB drivers that are installed in the windows system?
I want to display them in a DGV and create a connection string from the users choice.
XP,Vista and Widows 7
View 4 Replies
Dec 15, 2011
Ive got 2 List boxes 1 Shows Processes other one is for Storage. Anyway that's not important. Im trying to Kill all the Processes wat are stored in Listbox 2. I had to add .exe at List for Listbox 2 But still not working ? The problem is its not removing the File names that are stored
ProgressBar1.Increment(1)
Process.EnterDebugMode()
If ProgressBar1.Value = ProgressBar1.Maximum Then
[CODE]...
View 19 Replies
Nov 27, 2010
Im trying to add a variable that shows amount of tax deducted in a list box among other output variables. If anyone can help I would like to know how to code the lstResults.Items.Add("-$ " & Tax & " Tax") bracket to display the amount of tax deducted from the total salary wages.
Public Class Form1
'Decalirs Variables
Dim Hours As Integer
Dim Overtime As Integer
[code]....
View 3 Replies
Aug 17, 2010
so im dynamically populating a checkbox list. I have confirmed that my text and values are correct for each checkbox but when I check a few and click my event button when I loop through the items they are all set to select=false...
Dim resource As ListItem
Dim SelectedHashTable As New Hashtable
For Each resource In chkResources.Items
[code].....
View 1 Replies
Oct 24, 2010
I want to make simple photo gallary . First thing I have a combo box contain several folder whene I choiec a a certain folder, it should shows all the pic name that the selected folder contain. Whene I click in certain pic in the listbox , the picture box should show the selected pic.
[Code]...
View 5 Replies
May 22, 2008
anyone knows how to fetch the query of a view (Sql server) in vb.net?
View 3 Replies
Feb 13, 2011
I need to create a program that when I click a button it shows a sentence (took it from a list) random. But after it have to delete the sentence from the list 'cause we dont want to read it again I don't know so much about VB so I'd like some help!
View 25 Replies
Aug 12, 2010
I am trying to achieve this.
Public Enum Tables
customers
[code].....
View 1 Replies
Mar 19, 2011
I am absolate new to vb.net .can some one help me to write a query that will display list of tables in combobox.using the code bellow i can create table but i want to be able to add all the avilable table names in combobox.Imports System.Data.OleDb Public Class Form1
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim Cmd As OleDbCommand
Dim SQL As String
Dim objCmd As New OleDbCommand
[Code]...
View 2 Replies
Aug 15, 2011
is it possible to fill a list box from two SQL tables firstname lastname.
View 7 Replies
Jul 13, 2009
I am trying to write the code needed to link two tables together. One table is a list box and the other table is a data grid view. What would the example of the code needed in order to link these tables together so that each time you click on an item in the list box, the data grid would then show the corresponding information that matches up with the selected item.
View 1 Replies
Oct 27, 2011
I am trying to create a button on a form that will open a connection to a database and list all the tables in the database inside a listbox. Everything I have read indicates I can associate a single table to a form, and have no idea how to:
a. Create code for the button to access all the tables in the database.
b. Display that list in a list box.
The text that I am using is murach's ADO.NET 3 database programming with VB2010, and I am less that thrilled with it.
View 3 Replies
Apr 1, 2008
Got a form linked to a database and i have the first column of data appearing in a list box on my form. In the database there are two records with the same value and so, of course, in my list box the value is given twice.How do i remove this repetition from the list box? (still keeping it the same in the database)
View 5 Replies
Feb 17, 2008
I am working on what appears to be a very simple application but have a problem that I can't seem to get around. Using Visual Basic 2008 and an Access database. My application starts with only 3 text boxes and using the Data Wizard it works fine. I want to expand it to give the user a way to select an individual record to review so I dragged a ListBox on to the form onto the form, filled the DataSource and DataMember properties and When I run the program I click on one of the items in the List Box and the proper record fills the Text Boxes.
[Code]...
View 2 Replies
Nov 23, 2011
I have the following:
a table of addresses and a bindingsource for the table
a enum list of address type: 0 = "Mailing", 1 = "Physical", 2 = "Shipping" etc...
I would like to bind the datasource of the combobox to the enum so it displays "Mailing", "Physical" etc. Then I would like to change the bindingsource position of the address table based on the user selection of the combobox.
Here is what I have so far:
cbxAddressName.DataSource = New BindingSource(ApplicationEnums.GetEnumList(GetType(ApplicationEnums.CompanyAddressType)), Nothing)
[Code].....
View 1 Replies
Apr 23, 2008
How to Filter a Database Query Using a List..
View 2 Replies