Thanks for your reply. I wonder if it was some sort of dns / cache / whatever issue, as I got it to work this morning by simply using the IP address (which didn't work either yesterday afternoon).
My advice is free, and you may get what you paid for.
Hi, You can try to add a linked server for the secondary server to the primary server. After that your query might work. You could also try the OPENROWSET function. Regards, Johan
My advice is free, and you may get what you paid for.
Hi, I migrated a web application from a local (virtual) server running Windows Server 2003 to another local (virtual) server running Windows Server 2012 R2. In our warehouse we do order picking with (non domain joined) pda's using this web application. The (motorola) pda's run Windows CE, and are connected to the network over wifi / wlan. I can connect to the web application on the old server from the pda's, but I cannot connect to the web application on the new server. I cannot even connect to the default website on the new server. I can connect to the web application on both the old and new servers, with normal domain joined PC's running Windows 7 and 10, and also with my iphone (safari browser). So the question is, how do I get my pda's to connect to the web application on the new server? Google has not been forthcoming, or I simply haven't been able to figure out the right search term. Any help very much appreciated. Please let me know if I have left out pertinent information or if there might be a better forum for this question. Regards, Johan
My advice is free, and you may get what you paid for.
Hi, Thanks for your reply. I omitted the @ characters, but unfortunately still no sigare. Regards, Johan
My advice is free, and you may get what you paid for.
Please google: "excel maximum cell text length"
My advice is free, and you may get what you paid for.
Hi, Breaking my head, over this error, for which the reason according to all google results I have been able to find, is usually a simple omission of SelectCommandType="StoredProcedure", or some simple typo. If this is the case for me, I am just not seeing it.
The address shows that the necessary parameter values are being passed to the page: "http://address/folder/OrderPicking.aspx?_afp\_nr=**1586474**_&_wh\_nr=**02**_" Any and all help much appreciated. Regards, Johan
My advice is free, and you may get what you paid for.
Hi Michael, Thanks for your response. My apologies, I posted about this problem on another forum as well, and forgot to update this one. As it turns out, our firewall wasn't blocking any ports, it was just not allowing other SMTP traffic than specified, and nothing was specified. Anyway my code was good, including TLS, so the question remains, how come Outlook was not blocked by our firewall, when my code was. Regards, Johan
My advice is free, and you may get what you paid for.
No argument here. I just use Access because it happens to be in Office anyway, and I have neither budget to purchase any better tools, nor the time to build my own.
My advice is free, and you may get what you paid for.
Hi Richard, It all turned out to be an installation issue with Office. After an online repair of my Office 2016 installation, the references were back, and my code ran just fine again. Thanks for your help though. Regards, Johan
My advice is free, and you may get what you paid for.
Hi, Sorry, I mixed up the articles, because it mentions "...vs ADO...", and there is another article about using ADO to connect to an Access database. Anyway, my original code was written according to this article, and indeed worked fine. The problem is, that the code in this article no longer works once you install Office 2016 (at least the version that comes with Office365, if there is a difference), as apparently it does not include the Access Object Library. Regards, Johan
My advice is free, and you may get what you paid for.
Hi Richard, Thanks, I have read this article, but it only covers data access, whereas I specifically need the reports / printing functionality. The basic idea is that my access database is linked to an MS SQL database, and takes its data from there. Data access simply goes through MS SQL client. Regards, Johan
My advice is free, and you may get what you paid for.
Hi, I have a couple of windows applications that use MS Access to print reports. They were built on MS Access 2007, and worked fine until I was forced to upgrade to Office365 and thus MS Access 2016. Unfortunately (apparently) Office365's version of Office 2016 does not allow you to have other Office versions installed, so I had to remove my Access 2007 version. The simplified version of my code that worked fine until now:
Dim oAccess As Access.Application
Dim x As Long
AccessExecutablePath = New FileInfo("C:\Program Files\Microsoft Office\root\Office16\MSACCESS.EXE").FullName
x = Shell(AccessExecutablePath & " " & Chr(34) & DatabasePath & Chr(34) & " /runtime", AppWinStyle.MinimizedNoFocus)
oAccess = New Access.Application
oAccess = GetObject(DatabasePath)
oAccess.PrintReport("Some_Report_Saved_In_MSACCESS")
Apparently when you install Office 2016, it no longer has the necessary interop driver for Access, and the code no longer works. However, all microsoft's (I suppose outdated) documentation still says to use the code above. Here is my question: Has anyone else faced this issue, and more importantly can anyone suggest a solution, or another method to interact with the Access client? Regards, Johan
My advice is free, and you may get what you paid for.
My first guess was also that the problem is in our firewall, but I only asked our admin about a port being blocked. I will have to ask again about a possible black/white listing. Thanks for that suggestion. As for the SMTP server, per MickeySoft's instructions I use smtp.office365.com and port 587 or 25. I suppose that address has its own autodiscover protocol. nslookup gives me the specific smtp server name outlook-emeaeast3.office365.com and 9 different IP addresses. What I have been wondering about is, how MS Outlook contacts exchange online. Why is it not having any problem connecting?
My advice is free, and you may get what you paid for.
Hi, Thanks for your reply. I set the application to specifically show smtp errors, but the error remains the same:
Quote:
System.Net.Mail.SmtpException: Failure sending mail. ---> System.Net.WebException: Unable to connect to the remote server ---> System.Net.Sockets.SocketException: No connection could be made because the target machine actively refused it 40.101.88.18:587
Quote:
(an SMTP error message or an ICMP message from a router/firewall at the target)
The application works fine when I run it on any machine that is not on our network. Wouldn't that suggest that the error is caused by our own network, but somehow is not interpreted as a remote error? I can ping 40.101.88.18 normally. Regards, Johan
My advice is free, and you may get what you paid for.
Hi, I have a simple test application that allows me to send an email message through an Office 365 account. When I run this application from say my home PC it works fine, but when I run it from any machine on my company's network, it doesn't work. The application allows for two different methods of sending a message, a simple smtp server address and a webservice. When running the application I get a different error for each method: - smtp server:
Quote:
No connection could be made because the target machine actively refused it
- webservice:
Quote:
Autodiscover service couldn't be located
Our system administrator tells me our firewall is not blocking the port, and has not been able to suggest anything else. We only recently switched from third party Exchange 2010 to Office 365 and our on-premise AD is synced to it. MS Outlook works fine. Our office scanner also cannot send scans to email anymore, which it could through Exchange 2010's smtp server. I am at a loss, and any help with this issue will be much appreciated. Regards, Johan
My advice is free, and you may get what you paid for.
I think people are not entirely sure what you are asking. Do you need code samples and such, or do you just want ideas on what sort of programs you could try to code using VB6 ? If you want samples, you need to be more specific as to what of, and you need to show that you have made some sort of effort already yourself. Show some code that you have written that you want help with. If you want ideas for programs to code in VB6, then you are not asking in the right place. On this forum you can get help realizing your coding goals, but very very little in determining what these goals should be.
My advice is free, and you may get what you paid for.
Thanks Dave, I will look into that. Thanks for the help !
My advice is free, and you may get what you paid for.
Hi Dave, You were right (as usual). I found that I was calling another method (see below) before using the one I posted originally. When I commented this one out, the first method worked as expected. Looking at it though, I don't see how this method caused the unexpected behavior. As far as I can tell, it is pretty much doing the same thing.
Public Sub FormatTable(ByVal dgv As DataGridView)
Dim cs_Default As New DataGridViewCellStyle(dgv.DefaultCellStyle)
Dim cs_Money As New DataGridViewCellStyle(cs_Default)
Dim cs_Date As New DataGridViewCellStyle(cs_Default)
Dim cs_String As New DataGridViewCellStyle(cs_Default)
Dim cs_Integer As New DataGridViewCellStyle(cs_Default)
Try
With cs_Date
.Alignment = DataGridViewContentAlignment.MiddleLeft
End With
With cs_Money
.Alignment = DataGridViewContentAlignment.MiddleRight
.Format = "F"
End With
With cs_Integer
.Alignment = DataGridViewContentAlignment.MiddleRight
.Format = "N0"
End With
With cs_String
.Alignment = DataGridViewContentAlignment.MiddleLeft
End With
For Each clm As DataGridViewColumn In dgv.Columns
Select Case clm.ValueType
Case Type_Double, Type_Long, Type_Decimal
clm.DefaultCellStyle = cs_Money
Case Type_Integer
clm.DefaultCellStyle = cs_Integer
Case Type_String
clm.DefaultCellStyle = cs_String
End Select
Next
Catch ex As Exception
EC(ex)
End Try
End Sub
Regards, Johan
My advice is free, and you may get what you paid for.
Hi Dave, Would it suffice if I tell you the steps (in pseudo code) ? 1. Open Visual Studio 2012 Express 2. Start new Windows Forms project (.NET 4) 3. Drag DataGridView and button controls onto Window 4. Press button = - Use SqlCommand to run MS SQL stored procedure that returns a table - Use SqlDataAdapter to enter data into DataSet 5. BindingSource.DataSource = DataSet 6. DataGridView.DataSource = BindingSource 7. Run Method as in my original post Regards, Johan
My advice is free, and you may get what you paid for.
Ok, so I tried step through, and the only thing unexpected that I see, is that once the Format property has been set for a column in the loop, that setting is maintained through subsequent loops, until changed (again). So unless this is a bug or some cache issue in the debugging process, showing the value of a property incorrectly, I suppose it is possible that properties of the DefaultCellStyle, accessed through the column, get set for all columns in the DataGridView, not just for that specific column. I have worked around this by using:
DataGridViewCell.Style.Format
, but it takes noticeably longer now that I need to apply formatting one cell at a time.
My advice is free, and you may get what you paid for.