I have the following procedure call in vb6: dim rs as adodb.command dim cnn as adodb.connection with rs set .activeconnection = cnn .CommandType = adCmdStoredProc .CommandText = "sp_qryUpdate" .CommandTimeout = 0 .Parameters("@uidbatch").value = lngBatchID .Execute , , adExecuteNoRecords end with I re...
i am using sql server for database. In my coding when am inserting integer value into table am getting type mismatch error. my code as set rst1=cnn1.execute("select distinct(tagid) from pgevent") it returns some values when am trying to insert into another table am getting error cnn1.execute("insert into tags values("+cint(rst1.field...
I am creating an application in Visual Basic 6.0 which has SQL server as its database. I want to connect to the database without having MS SQL service manger installed on the client. How can this be done? Should i add any dll's or .tbl or .ocx files? ...
If so, does anyone know a good tutorial for it? ...
I found this link to handle events for a dynamically created control in vb6 and I tried to use this for my code, but to no avail. Option Explicit Private WithEvents grid(0 To 23, 0 To 23) As Frame How can I get the same functionality for this array of controls? ...
I have been given an old dll and the assignment of accessing it through C# .NET 3.5. I believe the dll was originally built with VB6, but am not positive. There is no documentation or source for the dll aside from an example for how to use the it in VB6. I have been able to succesfully access it through VB.NET 3.5. Example code for acces...
Please do any one have idea how to Use Forms created in VB 6.0 in VB.NET .......please help i m stuck ...
Possible Duplicate: Function or interface marked as restricted, or the function uses an Automation type not supported in Visual Basic. Basically, im just searchign for uPnP devices using the uPNPDeviceFinder classes .FindByType method, .FindByUDN works, but FindByType gives an error: VB6 gives a compile error when I attempt t...
What does this error mean in VB6? Function or interface marked as restricted, or the function uses an Automation type not supported in Visual Basic. I keep getting it when i call a particular method of a dll that comes with windows xp and beyond (in system32 called upnp.dll) Anyone any ideas? google wasn't helpful ...
How to make a DLL in VB 6.0 , please write steps please please..... ...
I'm trying to implement an interface in VB6. I have defined the class Cast_Speed like this... Public Function Run_Time() As Long End Function and the implementation like this... Option Explicit Implements Cast_Speed Public Function Cast_Speed_Run_Time() As Long Cast_Speed_Run_Time = 0 End Function but attempting to compile it...
I am trying to estimate how long it will take to migrate a Classic ASP application to .NET and came across hundreds of COM functions written in VB 6. A majority of these functions only do parameter validation and actually calls the SQL server. Is this something that should be replace with an ORM? (Linq, nHibernate, Entity Framework)......
I have an older VB6 project that references the windows image acquisition API. Since wiaaut.dll (version 1.0) wasn't originally in windows XP I was deploying it with the project and simply referencing in from the project directory. However, once I moved the project over to windows 7 I noticed, using procmon, that it is now trying to ref...
Hi, I have a number of excel (.xls) stored in a folder in a local drive. I need to do some process to every file in this folder. What is the code that will loop through every file open the file Do some processing and then Save & close the file move the file to another folder after processing To be more clear, I want go over every fi...
In VB6, coercing True to an integer yields the value -1. Why is this so? What is the reasoning behind this? In most other programming languages (C/C++, Java, Perl, Python, etc.), true becomes 1 when coerced into an integer. In boolean algebra, the value 1 is used to represent true/on. Why does VB6 do it differently? I do see a certain...
I know this question could be similar to others but really I'm looking for reasons why VB6 developers should switch to C#. My company recently approved project to be written in C#, so we have a lot of VB.Net programmers, however, we have some legacy app developers as well that are in VB6. We have a time frame to re-write those apps in...
Hey all, I've tried for a good part of the day to do this. So please help me out. I want to draw something like a pie chart segment. So just a piece of a pie(chart), filled with a certain color. I know we can draw a circle using the Me.Circle function in a PictureBox to get a fill-circle. However, when you add the start and end, the ...
I recently converted a VB6 program to VB.NET. This program is used to communicate with the Superlogics PCM Series DAQ card that the company no more produces and has no support for VB.NET. My program was running fine in VB6 but has problems in VB.net due to the the functions in the external .dll file (I am not sure though) I read many fo...
i have a DLL of a VB 6 Project that has one class n a form............. the form is called from that class when its constructor is called..........i maked DLL on whole project......add that DLL in my .NET project references.....now when i call that class of that DLL.....it give following error Creating an instance of the COM component w...
I have a VB6 application that has started to randomly crash based on actions performed in the application. The crash doesn't kick back an error, the screen just closes. The application has no logging to a log file and no event entries in the system event viewer. Assuming that I don't have access to the source code to write in some loggi...