asp.net - oledbConnection.Open() yields Error E_FAIL(0x80004005) when attempting to connect to Informix db using DSN -
i'm trying connect informix database using oledbconnection object, using vb in asp.net script here's code looks like;
dim oledbconnection = new oledbconnection("provider=ifxoledbc;dsn=dwh;") qry = "select location dim_location" try oledbconnection.open() '<-- interpreter bails here 'otherstuff oledbconnection.close() catch ex exception return ex.message() end try
everywhere else looked problem occurs @ query, not case me, can please help
below easy syntax creating oledb connection on informix. might want change code piece new oledbconnection("provider=ifxoledbc;dsn=dwh;")
match below
provider=any oledb provider name;oledbkey1=somevalue;oledbkey2=somevalue;
hope helps!
Comments
Post a Comment