Search results for query: *

Hi, I'm using vb.net with an as/400 db and a oledb connection. But each time I get the error "Unable to connect to database. It is only possible to connect to SQL Server Desktop Engine databases and Microsoft Access databases with this version of visual Studio." I'm using .net...

Hi, Does anybody know what the reason could be why the parameterfields property only returns the parameters of the main report. But it doesn't contain any parameters from the 10 subreports. We use VB6 with CR 8.5 and the CraxDRT.DLL Here is some code; Dim repReport As CraxDRT.Report Dim...

Hi, We use VB6 and Crystal Reports 8.5. We wrote code with CraxDRT instead of CRPEAuto object that exports a CR to a PDF in Batch or displays it onscreen. The CR has 146 parameters and the problem is the following. The CR works fine when we display it on screen. But when we export it, the...

I use vb6 wit folowing code to send XML document to receivestandard.asp page in Biztalk server. 'Get Purchase order from commerce server into xml Dim oXML3 As New MSXML2.DOMDocument sFilePath = "c:\POTest\PO.xml" oXML3.async = False oXML3.Load sFilePath...

Can anyone tell me how to write/update to a text file from a stored procedure...

I know that you can convert a recordset into a XML document in VB6.0 by doing the following; Dim oStream As ADODB.Stream Set oStream = New ADODB.Stream rs.Save oStream, adPersistXML but does anyone know how I can do the opposite. Namely how do you put the content of a XML document into a...

How do you treat the output of SQLServer2000 in VB6.0. Normally it returns a recordset after querying. But what if the communication between VB and SQLserver is in XML. Do you have to transform the incoming XML to recordset?? If so how do you do that?

Can anyone email me some code or give me a hint on how to communicate in a C/S appl between SQLserver2000 Database and a VB6.0 application using XML.

When I use a TTX file for passing decimal values from visual basic to Crystal Reports 7.0, I get a rounded value in my report. E.g. when I pass the value 12.123456 to Crystal reports, I get the value 12.12!!! PS: I declare a decimal value in my TTX file as Number. Does anyone know how I can...

When I pass a decimal e.g. 1,123456879 to CR 7.0 via VB by using a TTX file, I have but one possibility of datatype. Namely NUMBER. The problem I have here is that in CR7.0 the value has changed to 1,12. Does anyone know a solution so I can get the full value into my report without sending it to...