Connect To Postgres With Native Provider
Apr 15, 2011
I'm writting an application that needs to connect to a postgres 9 database. I'd rather not use any 3rd party drivers like NPgsql and the like. I'd like a driver that comes with the visual studio.I tried to create a data connection from the IDE with .NET framework provider for Ole DB and the provider was "microsoft jet 4.0 OLE DB Provider" and it didn't work.
View 5 Replies
ADVERTISEMENT
Jan 27, 2012
I am getting this error No mapping exists from object type System.String[] to a known managed provider native type.The code is
Dim conn1 As SqlConnection
conn1 = New SqlConnection("Data Source=win2008-2;Initial Catalog=h1tm11;User ID=sa;Password=#1cub3123*;Persist Security Info=True;")
' Dim conn1 As String = ConfigurationManager _ .ConnectionStrings("Connectionstring").ConnectionString()
'conn1.ConnectionString = ConfigurationManager.ConnectionStrings("Data Source=win2008-2;Initial Catalog=h1tm11;User ID=sa;
[code].....
the error occurs at adapter.Fill(table)
Dim addressstring1 As String = txtpostcode.Value.Trim()
Dim addressstring() As String = Split("addressstring1", ",", 1)
View 1 Replies
Jul 29, 2010
I am using OLE DB provider to connect to database
View 5 Replies
May 1, 2011
The vb.net code for populating tree view from the SQL Server Database is given in following link: [URL]I tried the code given in the above link to solve my problem but I was unable to change the code of SQL Sever for Postgres Database. I want to do the same thing using vb.net and database Postgres.
View 1 Replies
May 7, 2009
how to connect to a database and retrive data in a table using oledb data provider in Microsoft access?
View 2 Replies
Aug 3, 2011
i have 2 computers - a Server and a Client pc which is running on local area network with MICROSOFT SQL SERVER 2008 R2 Developer kit at the main pc and Client computer will need to connect to SQL SERVER at main pc using connection string.Let me named server computer as 'MAGNA-PC' and the client pc as 'LAC-PC' and database name is 'db_referafriend' so the code for MAGNA-PC(server) connection string is:[code] i GOOGLE and YOUTUBE for almost 2 weeks before i post . I know that i need to configure the sql configuration manager and enable tcp/ip also add a new port at firewall to allow remote connection also add the sqlserver.exe and sqlbrowser in firewall and I have also chosen "Using both TCP/IP and named pipes" under Remote Connections in the SQL Server 2005 Surface Area Configuration. and all of this doesnt work!
View 10 Replies
May 3, 2010
What's the advantages of the above types of dll? Is there any other type?
View 1 Replies
May 3, 2010
What's native code? And native dll?
Can i create a native dll using vb.net?
View 2 Replies
Nov 9, 2011
I have an external database that is feeding information to me. One saves their data as native GUID format and my other data source supplies standard .NET GUID format string. Is there a tidy way to convert from Native GUID to GUID Structure? Also is there any validation bit to determine if a provided value is a Native GUID or not? I can't seem to find any if there is one. The difference is as follows:
typedef struct _GUID
{
DWORD Data1;
WORD Data2;
WORD Data3;
BYTE Data4[8];
} GUID;
Data1, Data2 and Data3 get their byte order reversed but Data4 remains the same, see [url] for more info.
View 2 Replies
Jan 12, 2012
I have a vb6 project in which I use a dll library to do some tasks. For that, I add a module which declares all functions of that library such as:Declare Function myFunction Lib "abcdapi.dll" (ByVal hVar1 As Long, ByVal hVar2 As Long) As Long When I call this function (and many other similar) I'm able to do the work and correct Long pointer is returned. But when I try to do the same thing by VB.net (by importing the same library using dllimport and calling the same function), I get no result. although it does return some pointer but that doesn't produce correct result.
[Code]...
View 1 Replies
Aug 20, 2009
I need to convert a windows service written in .NET into native code, independent of the .NET framework. I've looked into using NGen to do this, but couldn't figure out how to use it. Essentially, I would like to take my windows service, run it through *insert app here* and have it bundle together all of the dependent dlls from the framework into their native code equivalents, so the service is installable without the framework.
View 13 Replies
Mar 5, 2009
I'm using VB.Net 2008, and I'm having difficulty finding information on how to detect the presence of the SQL Native Client components. I would like to detect their presence on a computer, and then find the version of the components.Does anyone have any information?
View 4 Replies
Jul 20, 2010
i want to use some api's in my software . Other than api there is no other way .
I want to learn more about win32 api . Can some one tell me
And what is the difference between Native api and normal api
View 12 Replies
Nov 1, 2010
I'm looking at a small remoting project in VB.NET. Initial research turns up references to msrdp.ocx which my Windows 7 Ult system doesn't have; a filesystem search on the same platform turns up MsRdpWebAccess.dll which doesn't appear to be well documented; finally hunting through COM references in Visual Studio turns up rdpencom.dll labeled "rdpcomapi 1.0 Type Library" which seems to be best documented via personal developer blogs (which isn't encouraging but is a lot better than other options).
My goal is a lightweight remoting application I can deploy to Windows 2000 Client/Server, WinXP x86/x64, Win2k3 Server, Vista x86/64, and Win2k8 Server.Is there anything DotNET Native I can use instead of one of these COM libraries? Is one of these COM libraries better for the job overall than others; and then am I going to have platform-specific compatibility issues if I don't provide support for more than 1 of them in my app?
View 5 Replies
Nov 15, 2011
I'm trying to print a barcode using the following code in Lightswitch Application[code]...
View 1 Replies
Sep 16, 2011
A DLL file contains some images inside PNG resource type.
I can view the PNG images in softwares like Resource Hacker, Anolis Resourcer & Resource Tuner. Check this screenshot of Anolis Resourcer for more details:
how do I get the PNG image no. 5220 from the DLL file and put it inside a PictureBox? I don't think APIs like LoadImage or LoadBitmap will work.
View 3 Replies
Sep 5, 2010
In a previous post [URL].. I needed to change how the values of an object's properties were displayed. In my case, I wanted to change how the native System.Drawing.PointF structure was displayed. If you check the post, it was resolved by using a TypeConverter.Now, my next question is how do I give existing properties attributes? For example, the System.Drawing.PointF structure has three properties: X, Y, and IsEmpty. I would like to give the X and Y properties descriptions. Also, I would like to hide the IsEmpty property, i.e., Browsable(False).
View 3 Replies
Jun 2, 2011
I'm creating a VB.Net Windows Form Application. Apologies if this is not clear as I'm still new to .Net. This consists of a text box and a gridview.The user is able to write SQL code in the textbox, click run and see the results in the gridview.It uses a SQL DataAdapter and the fill method to a datatable to populate the gridview.My problem is that I need to know the SQL datatypes for each column in the data table (NOT the .net ones). I.E SQL Server 2008 data type 'Date' is stored as System.Datetime in the datatable. I need to know if the SQL Server datatype is 'Date' or 'Datetime'.
View 2 Replies
Feb 18, 2009
I have a file called CalcProg.DLL written in Delphi which is used in Plaxis. I am planning to write a VB.net wrapper for this DLL. The problem is that I don't know what function names there are in the DLL. I was wondering if there was a wrapper generator so I could input a DLL and the generator generates a dummy CalcProg.vb with the function names so I could have a VB class that does something like this:
[Code]...
View 8 Replies
Mar 21, 2011
To do some testing with MPIR, GMP, the .Net Bigint module and other math libraries I've recently written a small program which allows me to create random sequences of numbers with a certain amount of precision: Always this amount of digits in front and behind the comma, no starting/ending zeroes. While it might not be the most elegant of code, it really blew my mind when I found out my application was running up to 10 times faster with Mono under Ubuntu 10.10.While the code is not elegant and in Basic, it was developed by me in about an hour's work and it serves the purpose: To generate dependable huge datasets consisting solely of preconfigured numbers before or after the comma. To get a general idea the UI's posted here:[code]Eliminating IO by not writing to IO but just to a List instead Eliminating an "if" path which checks if the random before/after float character is checked.Disabled progress reporting in general which causes the backgroundworker to not report any progress.Play around with the amount of symbols, theres very little difference between just getting 1 random character or getting 15 per record.I'm at a loss to what causes my program to run so slow under Windows/.Net compared to Ubuntu/Mono. I'm only a "half programmer", which means: I'm a Bussiness and ICT student who mainly focusses on human ICT, and the Microsoft Platforms certainly have lead on that, however such a huge performance hit compared to Linux for this soul and simple program really gives me a cold chill when it comes to my favourite platform.
View 3 Replies
Oct 17, 2010
I have a function that is exported by a C library with the following signature:
extern "C" BOOL Func()
The function is declared in VB.NET code like this:
<DllImport("mylib.dll", CallingConvention:=CallingConvention.Cdecl)>
Private Shared Function Func() As Boolean
End Function
The problem is that I get an ExecutionEngineException when I call the function from .NET code.
Given that BOOL is typedef'd as int in this C code, should the declaration be different? If so, how should I be declaring this? As Short or Int32? Do I need to marshal the return value?
View 1 Replies
Aug 14, 2009
We are working with an existing native application (most likely written in VB) that loads assemblies and calls methods with "Late Binding." We do NOT have access to its source code. We want to implement this interface in C#, and have the native application call our C# assembly. Is this anything we have to do beyond matching the method names and method signatures to make it work?
View 2 Replies
Feb 27, 2011
I have a component that I have built that includes a webbrowser control. I don't know if that is important, so I mention it anyway.
When I put the control into my form everything is fine,however, when I debug the application I get the following cryptic message:
COMException crossed a native/managed boundary
Error HRESULT_FAIL has been returned from a call to a COM component.
Private m_MouseOverListBox As Boolean = False
View 6 Replies
Mar 4, 2010
I need to write software that will do a lot of math. Mostly it will be matrix multiplication with integers to compute DCT. How much faster should I expect the code to run in native c as compared to VB .Net? Factor of 2, factor of 10, factor of 1000...?
View 3 Replies
Feb 16, 2012
I am migrating project from .net 3.5 to .net 4.0 and faced the following issue. There are 2 DllImport statements:
<DllImport("hid64.dll")> _
Public Sub GenerateHardwareID( _
<MarshalAs(UnmanagedType.LPArray, SizeParamIndex:=1)> ByVal Buffer As Byte(), _
[Code].....
View 1 Replies
Apr 18, 2011
Is this the most straight forward way to return a typed collection?Here's the key line of code which returns a implicit type of IEnumerable that used to manually loop through to manually recreated a TYPED collection. Is there any native LINQ way to return a typed sorted collection without this recreating of the collection? [code]
View 2 Replies
Aug 22, 2011
In .NET you can mark certain methods as obsolete so that developers are alerted when they attempt to use the deprecated method.
<Obsolete("Do not call this method.")> Private Sub FormerMethod()
The thing is you can only do this within classes you control. What do you do when you want your developers to avoid using certain methods on classes provided natively in .NET or by a vendor?
For example, what if you want your developer to prefer some custom extension method on DataTable rather than Select. I'd hate to have to define a custom version of the DataTable class if only to deprecate Select. That would leave us having to police whether or not the custom table was being used.
View 1 Replies
Jul 25, 2010
is there any native net code to convert BMP/JPG/GIF/PNG to JPG and adjust quality(if JPG),cropping and get output size?the code below just convert BMP to X, and no quality or cropping option(this code from freevbcode).
Public Function ConvertBMP(ByVal BMPFullPath As String, _
ByVal imgFormat As ImageFormat) As Boolean
Dim bAns As Boolean
Dim sNewFile As String
[code].....
View 3 Replies
Jul 27, 2011
I got this chunk of code off the internet, i think the sample program was called "store images and files on sql server" i added the delete routine, so it is a little better than when i found it, but it opens pictures in big picturebox at the very last line, i was wondering if there's a way to call windows photo editor or something newer instead of the form it's calling
View 6 Replies
Aug 15, 2009
I'm am amateur but avid computer programmer. I have been trying to find the best ways and methods to design my own webbrowsing program, like so many others individuals, using Visual Basic 2008.
A few things are a mystery to me, such as how to replace the native contextmenustrip (cms) of a Microsoft WebBrowser (imported AXWebBrowser, not to be confused with the standard WebBrowser control in VB) with the contextmenustrip of my own design.
I've searched Google, MSDN, and other potential knowledge bases to no avail.
Allow me to repeat, I am not using the VB-standard "webbrowser" control that comes pre-loaded in VB. What I am using on my Form is an "AXWebBrowser" control, a reference to the Microsoft WebBrowser that I have added myself. It has much better functionality, as far as I am concerned.
how to replace the contextmenustrip for the AXWebBrowser?
View 1 Replies