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].....
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
I'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]...
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 RepliesIn 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 RepliesVB.NETbyte[] packetTemp;
packetTemp[1] = (byte)pSize1;
return new byte[0];
CSharp (converted but i don't think they are correct):Dim packetTemp As Byte();
Return New Byte() {0}
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.
I have used the code convertor at developerfusion to convert the following two pieces of code (originaly from url...Can anyone tell me how to get the returned Latitude and Longitude values to display in my textboxes named tab5txtLatitude and tab5txtLongitude? [code]Conversion seems to have been done ok apart from the two lines (in red text) which appear to be missing from the converted function.
View 7 RepliesIs 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>)
I have a small vb.net application that fires a crystal report through crystal viewer.
The report uses an ODBC connection provided by 32-bit software accounts package, which is installed in the ODBC 32-bit This all works fine on 32-bit XP and 32-bit Win7 with no problems, When run on a win7 64-bit machine the application launches ok, but when it comes to running the report, it prompts for a database logon box for the odbc connection.
When the report is run seperate on its own, on the exact same pc through crystal reports desginer it runs fine, Its almost like the application is not picking the 32-bit ODBC set up is it the case that the connection needs to be coded rather than using the report connection,
I need code for opening DB connection using an ODBC data source. then I need to get some data from there to a data set.
View 7 RepliesThe following code snippet is taken from Julie Lerman's, "Programming Entity Framework" 2nd edition on page 765. The code is in C#, and I don't normally have a problem manually converting C# to VB, but I can't figure this one out.
_activities is a List(Of Activity). Using VB, how would you convert a List(Of Activity) to a List(Of T) as in this code sample? The compiler doesn't like anything that I've tried thus far.
private List<T> GetStoredList<T>()
{
string typeName = typeof(T).Name;
List<T> list;
[CODE]...
I m comparing two images in VB.Net..I get the code in C# & dat code is working 100 % Correctly..Now want to convert dat code to vb.net..& i need help in just converting two lines-
[code]...
I'm trying to convert an object, that is a list of something, to that list, but I'm having problems figuring out exactly how to do that. I have created the following code:
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Dim a As New List(Of String)
[Code]....
I need assistance converting the following C# code which works into VB code. The code detects when a specific type of USB device is connected and disconnected and writes the status to a status strip:
[code]...
I have a checked list box with lots of values and i need it so that when one of the items is ticked that a different box will display a value ie 50 so for instance i think it would be along the lines of
View 5 RepliesOk I have been working on a little project and it involves a list box.I want to be able to get all the text from the list box and set it as a String or somehow put it all in a text box (which will be set invisible).I tried using a text box before I started using the list box but it just wont work and all the buttond on my form stop working all together.
View 9 RepliesThis has to be incredibly simple, but I must not be looking in the right place.
I'm receiving this string via a FTDI usb connection:
'UUU'
I would like to receive this as a byte array of
[85,85,85]
In Python, this I would convert a string to a byte array like this: [ord(c) for c in 'UUU']
I've looked around, but haven't figured this out. How do I do this in Visual Basic?
i am new to vb .net i just want to ask why is it i don't see the odbc data adapter in the toolbox pane? i just have (under data) pointer, dataset, datagridview, bindingsource, and binding navigator.
View 3 RepliesI have a function that works great in C# that I'm converting to VB.Net. I'm having an issue converting the result set to a generic list in VB.net.
The code:
Public Function GetCategories() As List(Of Category)
Dim xmlDoc As XDocument = XDocument.Load("http://my_xml_api_url.com")
Dim categories = (From category In xmlDoc.Descendants("Table") _
Select New Category()).ToList(Of Category)()
Return categories
End Function
The error occurs when convertng the result via .ToList(Of Category)() The error:
Public Function ToList() As System.Collections.Generic.List(Of TSource)' defined in 'System.Linq.Enumerable' is not generic (or has no free type parameters) and so cannot have type arguments.
Category is a simple object I've created, stored in the App_Code directory.
I have the necessary "Imports System.Collections.Generic" reference in the file so I don't see why I can't convert the result set to a generic list.
I have a generic List(Of Customer). The customer class has a name, address, and phone number properties. I also have a property of another class that accepts a customer name array. I am able to do this by doing the following:
Dim names As String()
Dim i As Integer = 0
'customer.GetCustomers is a List(of Customer)
[Code]....
Is there a better way to convert this to a string array?
I want to loop through all the items in the items, but first I must to cast to appropriate type which I fail. [code]
View 1 RepliesI am trying to avoid every single function affecting my response time.therefore my question is using ToArray while converting generic list to array, does this take significant response time?should I use array directly while building my array within for each or working with list of and then at the endusing ToArray? any difference?
View 1 RepliesI am currently writing unit tests for an application near completion (before management looks at it and turns it inside out). I am testing the business layer and a method is set to return a datatable of all "GroupID"s, which are simply an integer to represent the group that a user belongs to.
I'm assuming the best way to assert on this unit test would be to assert that the correct groupIDs are being returned from a controlled test database. However, I'm not sure how to assert on a datatable. Is the only (and best) possible way to accomplish this to simply loop through the datatable until it's empty and add each value to an array of integers? How would one go about asserting on this test?
I got this code from msdn[URL]..I have most of it converted but having an issue with the following sub getting it converted correctly Protected Overrides Sub AdjustEventHandlers(ByVal sender As
[Code]...
I am converting a c++ code to vb but there is a problem, i dont know how this code work, if you know what is type of SetFilter parameters and SetBitFilter tell me. i cant use SetBitFilter in vb because it give me an error this is cause of i dont declare them correctly or their values. but when i use SetFilter it work few second and it stop working and with a dialog that have 2 button (close and debug)
This is code in c++ :
CODE:
I found some code on the net that is supposed to convert a BMP file into a AVI file.
[URL]
The example is in C# so i converted it using a C# to VB.NET converter and fixed a few of the conversion bugs. The code executes but fails on the line 'Throw New AviException("error for AVIFileOpen")' saying 'AVI exception unhandled'.
I have some code, that I am converting from C# to VB, in the code is the following line.
int index = ((int)document.GetCharAt(wordOffset +1)) % 256
that translates to something like this:
Dim index as Integer = CInt(document.GetCharAt(wordOffset + 1)) Mod 256
The problem is that the GetCharAt() function returns a Char type (pretty obvious from the name). VB throws an error saying that Type Char can't be converted to Type Integer. So my question is, what is the result of the explicit conversion in C# code?
I am currently in the process of converting a program I have developed from VB6/VBA to Visual Basic.NET. The object of this function is to run a query on an SQL Server Hosted database and output the results to Excel. I have a couple of last final problems though, in the old vb6 lines:
[Code]...
I never used delegate before Currently I am converting some C# code to VB.NET and am having some issue, it says
Error 2 Method 'Private Sub OnNewMessage()' does not have the same signature as delegate 'Delegate Sub OnChangeEventHandler(sender As Object, e As System.Data.SqlClient.SqlNotificationEventArgs)'.
[code]...