UniData & ODBC & VB (.net or VB6)

Bryan Dickerson · Joined: 08 Aug 2007 Posts: 3

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

Archived from group: microsoft>public>access>odbcclientsvr

dbui · Joined: 08 Aug 2007 Posts: 1

Bryan,
It appears the error is the syntax error. What is the line code where you
call your basic prg?

--dbui

"Bryan Dickerson" wrote in message@TK2MSFTNGP12.phx.gbl...
> 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
>
>

Bryan Dickerson · Joined: 08 Aug 2007 Posts: 3

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" wrote in message@TK2MSFTNGP09.phx.gbl...
> Bryan,
> It appears the error is the syntax error. What is the line code where you
> call your basic prg?
>
> --dbui
>
> "Bryan Dickerson" wrote in message
> @TK2MSFTNGP12.phx.gbl...
> > 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
> >
> >
>
>

Jan Csisko · Joined: 08 Aug 2007 Posts: 1

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" wrote in message news:...
> 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" wrote in message
> @TK2MSFTNGP09.phx.gbl...
> > Bryan,
> > It appears the error is the syntax error. What is the line code where you
> > call your basic prg?
> >
> > --dbui
> >
> > "Bryan Dickerson" wrote in message
> > @TK2MSFTNGP12.phx.gbl...
> > > 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
> > >
> > >
> >
> >

Bryan Dickerson · Joined: 08 Aug 2007 Posts: 3

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" wrote in message@posting.google.com...
> 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" wrote in message
news:...
> > 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" wrote in message
> > @TK2MSFTNGP09.phx.gbl...
> > > Bryan,
> > > It appears the error is the syntax error. What is the line code where
you
> > > call your basic prg?
> > >
> > > --dbui
> > >
> > > "Bryan Dickerson" wrote in message
> > > @TK2MSFTNGP12.phx.gbl...
> > > > 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
> > > >
> > > >
> > >
> > >

Madison Le · Joined: 08 Aug 2007 Posts: 1

Hello,

I have the SQL 2000 with application is EPI Suite 6.0 running with connect to Unidata database. I have the process to pull data from Unidata to SQL 2000. I recently upgraded the UniData 7.1 and found that the process is no longer work. The tranmitted data is failed from UniData to SQL 2000 table. The error message is
Error Source: Microsoft OLE DB Provider for ODBC Driver
Error Description:[Ardent][UniData ODBC Driver][Informix][SQL Client][UniData] Database collive doesn't exist
collive is the name of the UniData database.
I could not locate where is the problem come from. I did install the new driver in the server so it should work for the new version of UniData 7.1. Any help or thought is greatly appreciated.

From http://search.yahoo.com/search?p=[ardent]]UniData+ODBC+Driver][Informix][SQL+Client][UniData]&toggle=1&ei=UTF-8&fr=yfp-t-500&b=1

Posted via DevelopmentNow.com Groups
http://www.developmentnow.com

IBM Unidata Interface? Has anyone used .NET to interface with IBM's Unidata environment? I'd really appreciate some pointers. TIA Harry

add row ODBC ADO.NET . Reply (E-mail) Forward (E-mail) Subject: Add row, ODBC and ADO.NET From: "Marcus Olsson" Sent: 9/1/2003 8:08:17 AM Hi! I have a beginner problem and hope that someone easily can solve my problem. I want to connect to my Access d

ODBC to Ole Db Is there an ODBC Driver that can talk to an Ole Db provider???

ODBC.NET & MYSQL Can I connect to MYSQL databases using ODBC.NET? How?

ODBC DBHandle Hi All, Is there any possability to retrieve the DBHandle (m_hdbc in MFC) from a ..NET class? We would need to do this because we need to call an MFC DLL for some updates in the same transaction that we started in our ..NET server. TIA Thom