Recent content by blweb

Does anyone have experience with NeoTools in the vb.net environment? I'm trying to read HL7 from a file in a scanned folder. I cannot for some reason get the controls to interact together to allow me to see what HL7 messages are in the files.

Use a trigger or something of that sort in SQL and leave the application out of the picture all together if it needs to go off at a specific time. If you need the app to start this SP, then you will need to create a thread and call it cause you are going to be expending the system process...

I think we need a bit more information here. Are you trying to get rid of Form1 when you hit the button and it loads Form2? If so then throw "Unload Me" after Form2.show. That will stop the code in Form1 from running. Otherwise you can hide the form or leave it sit while Form2 is running. If you...

can anyone even give me a guess on this?

Here's a list of facts. ASE 12.5 Windows 2000 pro (machine) I have a table that times out every 1 of 3 times I do a select all statement and 3 of 3 times when I do a select where PatientID statement on it. Primary Key for the table is not TreatmentID. Anyone have an idea of how to approach...

Ok, Let's see if I can't cover all basises here. If you are using error handling where you are doing On Error Goto Error_Handler later down the code you want to do custom error handling you can create another section and make the same call as above only after goto adressing the custom...

I am trying to control the size of the excel sheet that comes up from the OLE object in VB6. I have put the control in a frame so that it doesn't autosize across the entire form. When I tell it to zoom or stretch to the size of the ole control, the width and height set themselves right, but...

I am trying to control the size of the excel sheet that comes up from the OLE object in VB6. I have put the control in a frame so that it doesn't autosize across the entire form. When I tell it to zoom or stretch to the size of the ole control, the width and height set themselves right, but...

Forgot. More specifically here's what's wrong. Set prmDatabase = datCmd1.CreateParameter("p_Database", adVarChar, adParamInput, 200) You're missing one parameter. It should look like this. Set prmDatabase = datCmd1.CreateParameter("p_Database", adVarChar, adParamInput, <length of string>...

ToeJam, It has to deal with how you are setting up your parameter. Set objCmd = New ADODB.Command With objCmd .ActiveConnection = PROJ_DB .CommandType = adCmdStoredProc .CommandText = "sel_from_tbl" Set objParm = .CreateParameter("@Parm1", adVarChar...

I pulled this one from www.connectionstrings.com. "Driver={SQL Server};Server=Aron1;Database=pubs;Trusted_Connection=yes;" then all you'll have to do is write your open statement as follows. .open, <UID>, <PW> If that doesn't work then referr to my first 2 questions I posted. Cheers...

If you try a different UID and password what does it give you? If it lets you in, then MSDE is looking at the UID and password for SA incorrectly. Does the machine have Query Analyser or something equivalent on it? If so you can try logging on with it to make sure the UID and PW for SA works...

mkefeli, To accomplish this you can either store the loaded column widths or keep them in the ini you were thinking about then use a For Each loop to check the widths on exiting the form. For Example... Dim oItem As ListItem For Each oItem In ListView1.ListItems if...

deulyd, In these instances I use the Nodes collection in a For Each loop and a For Each to go through the collection. You do not loose much time by doing it this way. for example. If I have a collection named g_Col Then I would work the situation as follows. Dim oObj as <name of class in the...

Swi, Thanks for the response. I modeled the connection strings above from www.connectionstrings.com giving me the results above. I found it as a great resource, but no luck. As for http://www.able-consulting.com/ADO_Conn.htm, it says that I need to create an .IDS file. Only problem is that...