.NETGURU
  Search:  
NamespacesDiscussions.NET v1.1Dot Net Guru's BlogIT Certification
UniData & ODBC & VB (.net or VB6)
Messages   Related Types
This message was discovered on microsoft.public.dotnet.framework.odbcnet.

Post a new message to this list...

Bryan Dickerson
Has anyone had any experience with the UniData ODBC Client? I'm just
getting started and having trouble calling a UniData Basic program from VB.

I'm getting the following error:
"ERROR [42000] [Ardent][UniData ODBC Driver][Informix][SQL Client][UNIDATA]
MY.PROGRAM.NAME; Syntax error"

Any ideas???

TIA!
Bryan Dickerson
Reply to this message...
 
    
dbui
Bryan,
It appears the error is the syntax error. What is the line code where you
call your basic prg?

--dbui

"Bryan Dickerson" <Click here to reveal e-mail address> wrote in message
news:Click here to reveal e-mail address...
[Original message clipped]
Reply to this message...
 
    
Bryan Dickerson
The following code is the extent of my program right now:
======================================
Public Shared Sub Main()
Dim SSConn As String =
"DSN=UNIDATA;SRV=Source_OIS;DBQ=/usr_ud/ud52/OIS;UID=isus;PWD=dkny;"
Dim OSS As New Odbc.OdbcConnection(SSConn)
Dim OCmd As New Odbc.OdbcCommand()
Dim sResult As String

Try
OSS.Open()
With OCmd
.Connection = OSS
.CommandType = CommandType.StoredProcedure
.CommandText = "VB.CUST.INQUIRY.BWD 001 000100 C BWD"
sResult = .ExecuteNonQuery
End With
MessageBox.Show("sResult is : " & sResult.ToString)
Catch ex As Exception
Do While Not ex Is Nothing
MessageBox.Show(ex.Message)
ex = ex.InnerException
Loop
End Try

End Sub
======================================

"dbui" <Click here to reveal e-mail address> wrote in message
news:Click here to reveal e-mail address...
[Original message clipped]
Reply to this message...
 
    
Jan Csisko
Bryan,

any chance that the following string should only be made up of three
values ?

VB.CUST.INQUIRY.BWD

e.g.

CUST.INQUIRY.BWD

Hth,
Regards,
Jan

"Bryan Dickerson" <Click here to reveal e-mail address> wrote in message news:<u7r$Click here to reveal e-mail address>...
[Original message clipped]
Reply to this message...
 
    
Bryan Dickerson
No. "VB.CUST.INQUIRY.BWD" is the name of a Basic program on the HP UniData
db (albeit one for my preliminary testing purposes).

"Jan Csisko" <Click here to reveal e-mail address> wrote in message
news:Click here to reveal e-mail address...
[Original message clipped]
Reply to this message...
 
 
System.Data.CommandType
System.Data.Odbc.OdbcCommand
System.Data.Odbc.OdbcConnection
System.Windows.Forms.MessageBox




ExamGuru IT Solutions - .Net Guru is owned and operated by ExamGuru, Inc., the man behind .Net Guru. If you're in the market for bespoke software or software consultancy, why not get him and his highly trained team to help? - www.examguru.net/ITCertification
Ad


Need Dot Net Interview Questions?
Ask ExamGuru, Inc. for advice and help on Passing .Net Interviews
.Net Projects
Best-of-breed application framework for .NET projects, developed by ExamGuru, Inc. and ExamGuru IT
Free .net Help
Commission ExamGuru, Inc. and his team for your next bespoke software project
FogBUGZ
The only bug tracking system carefully crafted with one goal in mind: helping teams create great software.
Awesome Tools
If you don't know about these, you're missing out... IT Certification Questions
IT Interview Questions
Free Oracle 10g Training
MCSE Boortcamp
Cisco Study Guides
Cheap Study Guides
Exact Questions
Dot Net Interview Questions
Oracle OCP
Cheap Travel
Designer Perfumes - Wholesale Prices
Free Programming Tutorials
 
ExamGuru IT Solutions - .Net Guru is owned and operated by ExamGuru, Inc., the man behind .Net Guru. If you're in the market for bespoke software or software consultancy, why not get him and his highly trained team to help? - www.examguru.net/ITCertification
 Copyright © ExamGuru, Inc. 2001-2006
Contact Us - Terms of Use - Privacy Policy - www.dot-net-guru.com - www.examguru.net - www.oraclesource.net - www.itinterviews.net - www.examguru.net/ITCertification