[lnkForumImage]
TotalShareware - Download Free Software

Confronta i prezzi di migliaia di prodotti.
Asp Forum
 Home | Login | Register | Search 


 

Forums >

microsoft.public.dotnet.framework.odbcnet

ODBC fails if AS/400 offline

Rob T

8/7/2002 4:48:00 PM

Hi,

I have a working ODBC connection to our AS/400. However, if the AS/400 is
off-line, my program just quits. I have tried an On Error event, but no
error number is raised. I saw someone else had asked a similar
question...with no results.

Any suggestions? Thanks.

PS. Here's a VP snippit of my code if it is of any use.

On Error GoTo BombOut
strSQL = "Select * from POMASTL0 where UUSAPM='1'"
dstOdbc = New DataSet()
cnnOdbcCUS = New OdbcConnection(strCUS)
dadOdbc = New OdbcDataAdapter(strSQL, cnnOdbcCUS)
dadOdbc.Fill(dstOdbc, "Info")
dataView = New DataView(dstOdbc.Tables("Info"))