.net - C# ODBC Driver's SQLSetConnectAttr failed -

-

i'm trying connect access 2007 database (.accdb) .net console application. setup system dsn in odbc manager. how i'm setting connection:

conn = new odbcconnection(); conn.connectionstring = "dsn=hu-fu"; conn.open();

on development machine works perfectly, today tried install on client machine , i'm getting following error: 

error [im006] [microsoft][odbc driver manager] driver's sqlsetconnectattr failed

anyone has idea problem?

here odbc trace source:

upsshipmentserv 1454-6f0 enter sqldriverconnectw    hdbc                0x00424070   hwnd                0x00000000   wchar *             0x69938b34 [      -3] "******\ 0"   sword                       -3    wchar *             0x69938b34    sword                       -3    sword *             0x00000000   uword                        0 <sql_driver_noprompt>  upsshipmentserv 1454-6f0 exit  sqldriverconnectw  return code -1 (sql_error)   hdbc                0x00424070   hwnd                0x00000000   wchar *             0x69938b34 [      -3] "******\ 0"   sword                       -3    wchar *             0x69938b34    sword                       -3    sword *             0x00000000   uword                        0 <sql_driver_noprompt>  diag [im006] [microsoft][odbc driver manager] driver's sqlsetconnectattr failed (0)

upsshipmentserv name of app. sadly not mean me...

one more addition question. checked access driver's (aceodbc.dll) version on both machines , mine newer client's. problem? there way update driver?

thanks.

okay guys, have apologize question...

i know problem. it's stupid error. in odbc manager when setup dsn did not select accdb file. program failed cause there no db file selected dsn.

so next time, if see error, make sure dsn set correctly. replies anyway.


Comments

Post a Comment

Popular posts from this blog

jasper reports - Fixed header in Excel using JasperReports -

-
how can create excel report fixed header using japserreports? mean need header fixed when scroll excel file. this possible adding couple properties in jrxml file each report. take @ advanced excel features freeze panes. if wanted freeze after first column header (down left side basically) this: <statictext> <reportelement style="sans_bold" mode="opaque" x="0" y="60" width="104" height="20" forecolor="#ffffff" backcolor="#666666"> <property name="net.sf.jasperreports.export.xls.auto.filter" value="start"/> <property name="net.sf.jasperreports.export.xls.column.width" value="110"/> <property name="net.sf.jasperreports.export.xls.freeze.column.edge" value="left"/> </reportelement> &
Read more

media player - Android: mediaplayer went away with unhandled events -

-
i need duration of audio file series of voice announcements need play app. have added audio files resources , play fine. sample code below works perfect intended purpose: return duration of audio files. here code: float getdurationofaudioresource(locationenum loc, context context){ float duration = 0; try { mediaplayer mp; mp = mediaplayer.create(context, getaudioresource(loc)); duration = mp.getduration(); mp.release(); mp = null; } catch (illegalstateexception e) {e.printstacktrace(); logerror(25, "testdescitem:fault::could not open mediaplayer object audio resource.");} return duration; } here's weird thing. code called in main activity prepares set of audio instructions given test. there no errors within activity. second activity called, long string of errors on logcat. 03-07 13:23:43.820: i/actionlogger(21435): gentest_info_test #0 created. 03-07 13:23:43.830: i/actionlogger(21435): gente
Read more

python - ('The SQL contains 0 parameter markers, but 50 parameters were supplied', 'HY000') or TypeError: 'tuple' object is not callable -

-
import pyodbc,nltk,array cnxn = pyodbc.connect('driver={mysql odbc 5.1 driver};server=127.0.0.1;port=3306;database=information_schema;user=root; password=1234;option=3;') cursor = cnxn.cursor() cursor.execute("use collegedatabase ;") cursor.execute("select * sampledata ; ") cnxn.commit() s=[] j=[] x=[] words = [] w = [] sfq = [] pos=[] entry in cursor: s.append(entry.injury_type),j.append(entry.injury_desc) nltk.tokenize import punktwordtokenizer nltk.corpus import stopwords tokenizer = punktwordtokenizer() english_stops = set(stopwords.words('english')) in range(0,26): # filter stop words tokenizer.tokenize(j[i]) w.append([word word in tokenizer.tokenize(j[i]) if word not in english_stops]) in range(0 , 26):#converting tokenzied text ito string sfq.append(" ".join(w[a])) replacers import regexpreplacer replacer = regexpreplacer() in range (0,26):#pos tagging replacer.repl
Read more