vb6

How to write a Proper SQL Connection String?

Using VB 6 and Sql Server 2000. In my code I am using open dialog control for selecting the database file, once I selected the database(Dual_ACS.mdf) file, it will appear in the textbox (path and filename) Textbox name = databasetext My code. Cn.ConnectionString = "Provider=SQLOLEDB.1; Persist Security Info=False;User ID=" & UName & ...

How to open the sql data base in crystal report?

How to open the sql data base in crystal report? Using VB 6, SQL server 2000, Crystal Report 8.5 My code. CR.DataFiles(0) = App.Path & "\Database\DUAL_ACS.mdf" CR.ReportFileName = App.Path & "\rpt_attendancereport.rpt" CR.Action = 1 But it showing “Cannot Open Sql Server” What wrong in my code. Need VB 6 code Help? ...

Can a VB6 component be compiled to 64 bit?

Is there a way to compile a VB6 component into 64 bits? My feeling is that the answer is "no", but I would like to confirm this. Please, if you can, paste a link to an authorative source that would confirm. ...

Vb6 to VB.Net- How to replace registered dll concept

I am replacing a VB6 application with a rewritten counterpart in VB.Net. In the VB6 app there was a 'control' application which presented a form to the user and allowed them to select a 'client' from a drop down list. Selecting a client caused the reading of an ini file which set client-specific parameters, including the program names of...

How to Pass a Late Bound Parameter

In VB6, I'm trying to pass a late bound object to another form. frmMain.vb Dim x Set x = CreateObject("MyOwn.Object") Dim f as frmDialog Set f = New frmDialog f.SetMyOwnObject x frmDialog Dim y Public Sub SetMyOwnObject(ByVal paramX As Variant) Set y = paramX End Sub The contents of y are a string containing the type name of the...

A Simple C# DLL - how do I call it from Excel, Access, VBA, VB6 ?

Hi all, I have a simple class library written in c#. using System; namespace TestDll { public class Test { public string HelloWorld { get { return "Hello World"; } } } } My question is how can I call this HelloWorld function from Microsoft Office ...

Mappoint 2009 Europe MapPointControl.ocx

I have an old legacy VB6 app that I support, which uses the MapPointControl.ocx. Customers are saying it doesnt work with Mappoint 2009. Having Googled, it would appear the European addition of Mappoint shipped with a bad OCX file on it. Apparently this has now been sorted on the latest CDs, but that doesnt help my customers who are s...

Tool for analyzing VB6 source code (like Understand from SciTools)

Does anyone know of a tool to analyze/navigate VB6 source code like the tool from scitools? http://www.scitools.com/products/understand/ ...

creating a server project in vb6 and ms-access

Hi guys, i am making a project in visual basic 6 and ms-access. Its about college management system and is a server based application. Clients can access the system in the server. But the main problem is how can i make my client use the access file located in the server computer.?? if my database file is already opened in the server com...

Exposing C# struct to COM breaks for VB6 app

Last Updated: 2009-08-11 2:30pm EDT A few days ago I posted this question about some very strange problems. Well, I figured out what specifically was causing a build on one machine to not run on others and even came up with a work-around, but now it leaves me with a nice, specific question: Why? To reproduce the problem, I create a new...

Access Visual Studio 2008 server-based database from VB 6 project

Is it possible to access a Visual Studio 2008-created server-based database from a VB-6 application? If not, what is the best way to share a database between a VB-6 application and a C# application? ...

Need Binary Tree Control in VB6

Hi, I just need to ask, does anyone have link to free resources where I could get the control to draw a binary tree using VB6. Note that I am not saying regarding TreeView control in VB6. I need a control to draw a binary tree like 1 /\ 2 3 /\ /\ 4 5 6 7 ...

Difference between a report and a form

What's the difference between a report and a form? In VB6, we have Data Report Designer to help with the creation of data reports. I have not really used a report in my application yet. To me, it looks just like a form, but I think there must be some difference between them, or there is no need for the word "report" to exist? Would so...

VB6 - Open file for shared writing

Want to know how to open a file in VB6 for shared writing. ...

Do you use Data-aware classes?

I'm using VB6. Data-aware classes refers to classes whose DataBindingBehavior or DataSourceBehavior property is set. I learned this concept from MSDN and am wondering usually when should we use this technique of Data-aware classes? Or just like the Data Environment Designer which is just ignored by most developers? ...

Which reasons could make ShellExecute fail?

I have a VB6 application which opens files with their associated application using: ShellExecute(0, "open", filename, params, vbNullString, vbNormalFocus) This works perfectly. Now I got a customer (running XP with Adobe Reader) who can't open any PDF file using the above command. But the same file is being opened without any proble...

Detecting for Pessimistic lock in VB6

I have a database system developed in VB6, and we have a scenario where more than one user may register at the same time triggering an insert in the database. I have used normal sqlconnection and recordset to make the insert and i initialize it with a pessimistic lock. Now how can i check in my application before inserting a record, if t...

How to display the text file while clicking the button

How to display the file(*.txt) while clicking the command button Using VB 6 Am New to VB 6 How to display the content of the file while clicking the button Data's are stored in the text file, ex 1.txt when am clicking the command buttion, 1.txt file will open and 1.txt data's should display Need VB 6 code Help? ...

VB6 scrollbar problem

i'm working on a VB6 project where I need to have a form and within that form i need to have a picturebox and a scrollbar to scroll the picturebox. the setup is straight forward like this: FormMain -> FormSub(with scrollbar) -> PictureBox now the problem lies where the scrollbar is. when i add the scrollbar to the FormSub, the PictureB...

Access Denied using MSXML

I have a VB6 backend for a classic ASP site. That VB then calls a web service on the same server using MSXML2.XMLHTTP. This works all of our servers but one. If I set the web service site to accept anonymous login it will work however if I force only integrated security MSXML returns an Access Denied error. I'm using code from the examp...