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 want to start a new project, an application to detect drivers installed and not installed.
can someone give me some details about how can be checked, what codes i need to retrieve.
i am using visual studio 2008 for my final year project.i m making billing system.the system using micrososft access as a database.i used odbc as a connction with database.which one is better?odbc or oledb?
View 2 RepliesI currently connect to a MySQL database using the ODBC MySQL 5.1 Connector, how would I be able to detect if the driver is installed before a connection attempt?
View 4 RepliesI have a VB.net 2005 application that will use both Access and SQL server databases. I have DSN namesfor both access and sql server database. I used OleDb.OleDbConnection to open the Access database and it works fine. I am trying to make it work with sql server database. Do I have to have to have separate source codes using Sqlclient.SqlConnection and its related name spaces? Can I use odbc.OdbcConnection name space
View 4 RepliesOption 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].....
I'd like to mention that getting a list of the installed programs via the registry is not a viable way to receive a full an accurate list. The two main areas where the programs in the registry are stored, are mainly MS programs. Some manufacturers put their keys here as well, but most don't. And since it's impossible to know where the manufacturer has stored the key, let alone the name of the key that would give the list and the uninstall capability, it's not ideal to use the registry.
That being said, I was told that there is a COM API that Microsoft has made and uses in the Windows OS and was hoping someone knew what that API is and how to maybe implement it in VB.
I have created an application in VB.Net 2010 and am using an Access 2010 db. Connecting to this DB I use the Provider= Microsoft.ACE.OLEDB.12.0 and it works fine on my machine. This was a recent update from using Jet as that provider was having issues on client Win64 computers that had Access 2007 or 2010 installed.Basically my issue is that I get the error that Microsoft.ACE.OLEDB.12.0 is not installed when I try to run the application on the client.
The problem however, is that I do not want ask the users to install Data Access Objects in addition to .Net 4.0. I want a simple install that they can run and upgrade to .net 4.0 if they need to. The above thread states a solution as "You can also consider to use ADO.NET object in System.Data.OleDb namespace to connect to the Access database instead of the Provider. In my opinion, this is the best choice since the ADO.NET provides you the powerful data access objects." This sounds like a great option, however I cannot find any way to install the ACE dll and get it to work on the client.what do I need to include in the client installer to get my application to run on systems without Access installed? Do I just include the ACEODB.dll or is there something else that needs to be done?
I'm currently using the following to code to grab the installed programs and list them in a ListView:
vb.net
Dim SoftwareKey As String = "SOFTWAREMicrosoftWindowsCurrentVersionInstallerUserDataS-1-5-18Products"
Using rk As RegistryKey = Registry.LocalMachine.OpenSubKey(SoftwareKey)
For Each skName In rk.GetSubKeyNames
[Code] .....
What I don't understand is when I run the code, I get a NullReferenceException was Handled on this line:
vb.net
If name.ToString <> "" Then
I haven't been able to find much on the error. It seems like it is a pretty generic one and can fit into a lot of different scenarios.
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 RepliesQuestion: How do I programmatically determine which provider to use (Microsoft.Jet.OLEDB.4.0 vs Microsoft.ACE.OLEDB.12.0) when my app runs as a 32-bit process on a machine with Office x64 installed?
I'm developing a VB.net WinForms app in VS 2010 and targeting both x86 and x64.The app processes data from xls, xlsx, mdb and accdb files using System.Data.OleDb:Dim oConn As OleDbConnection = New OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=...")
The x64 version of the program works as expected. The x86 version works as expected on a system with Office x86.When I run the x86 version on a machine with Office 2010 x64, I get the following exception when trying to open a connection:
The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.I believe this is because I'm running Office 2010 x64 so the x86 data access components are not installed.I can get it to work for Office 2003 files (*.mdb and *.xls) by changing the provider to Microsoft.Jet.OLEDB.4.0.
How do I figure out which provider to use when running as a 32-bit process on a machine with Office x64 installed?Ideally, I'd like a function:If ProviderIsAvailableFor("Microsoft.ACE.OLEDB.12.0") Then
Else If ProviderIsAvailableFor("Microsoft.JET.OLEDB.4.0") Then
i want to ask what is the difference between oledb connection and odbc connection. I have a case, my office used ncomputing then i have to developed an application using sqlserver 2000 and vb.net 2005, i used oledb connection. When i try to implement it in ncomputing, why user must has admin access level and dbo level in sql server, it seems trouble when all users are admin. But there's a rumor that when using odbc connection, we dont need to give admin access level for users.es.
View 1 RepliesIs 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.
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>)
I have been trying for days now how to create a process to the user to easily create a connection to any installed data types they have installed. I have found an example right inside vb2008. I never use this because I code my own connections, but this would be real nice if I could include it or duplicate it.
View 1 RepliesBasically I need to create a form that will display a summary of the population trend for each species of butterfly from a database that I have.I will do this by having the user select which butterfly species he/she wants to view from a combo box and then the list box will display the count_2010 and count_2011 information for that butterfly species.
I have managed to link my combo box to the database but I am unable to get any information to be shown in my list box. I can use a select case and input text myself but I don't want to do that as in another form records need to be added. Is it possible to have the relevant fields from the access database show up in the list box after the user selects a species from the combo box?
[Code]...
I have added a module to the project. Inside the module I have the following
Public Function ListOFT() As List(Of String)
Return ListOFT
End Function
When I try to add something to ListOFT I get:
Quote:
Object reference not set to an instance of an object.
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,
Is there an easy way to get a list of the installed web browsers on the system (including the path to their respective .exe)? I have a web application which uses the Web Browser Control, but I would like to give the user the ability to view their web page in any of their other installed browsers.
View 6 RepliesHow to get list of installed programs into my listbox?
View 5 RepliesWith the following code I can list the display name of all software installed on a local machine.
'Declare the string to hold the list:
Dim Software As String = Nothing
'The registry key:
Dim SoftwareKey As String = "SOFTWAREMicrosoftWindowsCurrentVersionUninstall"
Using rk As RegistryKey = Registry.LocalMachine.OpenSubKey(SoftwareKey)
'Let's go through the registry keys and get the info we need:
For Each skName As String In rk.GetSubKeyNames()
Using sk As RegistryKey = rk.OpenSubKey(skName)
[Code] .....
What I need is to get the FileName
to be used to start the application like notepad.exe and not just the displayname
Dim p As New System.Diagnostics.Process
p.StartInfo.FileName = filename & ".exe"
instead of all listed in the registry key, "Microsoft Digital Image Library 9" doesn't even show in installed programs list. [Code]
View 2 Replieshow can i view my installed program list and uninstall program from the list using vb.net 2008.
View 1 RepliesApplication: Arrays are to be used for this. When button Add Student is clicked it should add all the information for a student and when Show Student button is clicked it should prompt the user for student's last name and student's information in a message box. Class ranking list box has an enum function to it and has to be stored be show along side other answers.NOTE: FindItemIndex if from the last application I did, i am suppose to use it in this one,so you can modify it the way you want.
[code]...
Has anyone ever used Game Maker 7?
I was wondering, if anyone had any information on making DLL's for this software to extend its function list.
I know that all installed programs and updates can be found at HKEY_LOCAL_MACHINESOFTWAREMicrosoftWindowsCurrentVersionUninstall key in the registry.
But how can I differentiate between installed programs and installed updates?
I need to get a list of installed program on local machine with application icons. Below is the code snippet that am using to get the list of installed program and installed directory path.[code]....
View 1 Repliesit seems always at this time I cant figure out how to do something maybe it has something to do with lunchtime.
Im having trouble using a method that is defined by an outside company
This is a link to their integration guide:
[URL]
This is their documentation for the class Im trying to use
OrderQueryWebService Class
This class is for SID in particular and is made for use with the notification methods. This is for the Order Query Web Service specifically, allowing clients to return the status of transactions for their merchant, whenever they want to.
Methods
/ <summary>
/ Pass through the variables required and receive a list of Transaction
objects showing transaction status
[Code].....
The MerchantCode, the MerchantUsername, the MerchantPassword are all good the List is a custom type called SetComHash.Transaction
Everytime I try adding a string to the list such as the transactionNumber and some other values it gives me a type error:
"Value of type string cannot be converted to 'SetcomHash.Transaction'
Just wondering if i might hit a snag in my program. Ive got 10+ users using the same files, via a Oledb to put info into an excel spreadsheet. If 2 or more people save there file at the same time will the program go into read only on one person. Normally one 3 will use the file at one time. I know Sql itself would be better to use. best way i can describe it, normally using excel if you manage to open the same file twice one opens as normal but the other opens as a Read only file, will the same thing happen if im using Oledb connections?
View 2 Replies