using osql to update access db at command line
This is a discussion on using osql to update access db at command line within the MS SQL ODBC forums, part of the Microsoft SQL Server category; --> am trying to update an access file table contents using osql and am getting all sort of error Can ...
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-27-2008, 08:45 PM
| ||||
| ||||
 using osql to update access db at command line am trying to update an access file table contents using osql and am getting all sort of error Can anyone help This is the querry osql -U aaa -D MyLocalConfig -P synprof97 -Q "update System set LocalConfigPath = 'C:\DBase\Test\Config' where Ref = '{B2244A43-CAF7-11D0-8DD6-0000C07E4B0E}'" I get the following errors, using the same query on SQL db is okay [ODBC Driver Manager] Driver's SQLSetConnectAttr failed [ODBC Driver Manager] Driver's SQLSetConnectAttr failed [ODBC Microsoft Access Driver]Invalid connection string attribute APP [ODBC Microsoft Access Driver]Invalid connection string attribute WSID [ODBC Microsoft Access Driver]Invalid connection string attribute APP [ODBC Microsoft Access Driver]Invalid connection string attribute WSID [ODBC Microsoft Access Driver]Invalid connection string attribute APP [ODBC Microsoft Access Driver]Invalid connection string attribute WSID [ODBC Microsoft Access Driver]Invalid connection string attribute APP [ODBC Microsoft Access Driver]Invalid connection string attribute WSID [ODBC Microsoft Access Driver]Optional feature not implemented      |
|
02-27-2008, 08:45 PM
| |||
| |||
| Re: using osql to update access db at command line Hi OSQL is used to communicate with Microsoft SQL Server, no Microsoft Access. Regards -------------------------------- Mike Epprecht, Microsoft SQL Server MVP Zurich, Switzerland IM: mike@epprecht.net MVP Program: http://www.microsoft.com/mvp Blog: http://www.msmvps.com/epprecht/ "Addcom" <albert.addo@oxinst.co.uk> wrote in message news:u82DQmpZFHA.3840@tk2msftngp13.phx.gbl... > am trying to update an access file table contents using osql and am > getting all sort of error > Can anyone help > This is the querry > osql -U aaa -D MyLocalConfig -P synprof97 -Q "update System set > LocalConfigPath = 'C:\DBase\Test\Config' where Ref = > '{B2244A43-CAF7-11D0-8DD6-0000C07E4B0E}'" > I get the following errors, using the same query on SQL db is okay > [ODBC Driver Manager] Driver's SQLSetConnectAttr failed > [ODBC Driver Manager] Driver's SQLSetConnectAttr failed > [ODBC Microsoft Access Driver]Invalid connection string attribute APP > [ODBC Microsoft Access Driver]Invalid connection string attribute WSID > [ODBC Microsoft Access Driver]Invalid connection string attribute APP > [ODBC Microsoft Access Driver]Invalid connection string attribute WSID > [ODBC Microsoft Access Driver]Invalid connection string attribute APP > [ODBC Microsoft Access Driver]Invalid connection string attribute WSID > [ODBC Microsoft Access Driver]Invalid connection string attribute APP > [ODBC Microsoft Access Driver]Invalid connection string attribute WSID > [ODBC Microsoft Access Driver]Optional feature not implemented > > |
|
02-27-2008, 08:45 PM
| |||
| |||
| Re: using osql to update access db at command line Thanks Mike Do you know to update an access mdb file through a batch file or command line? or it is impossible? "Mike Epprecht (SQL MVP)" <mike@epprecht.net> wrote in message news:%23MMMOFvZFHA.1152@tk2msftngp13.phx.gbl... > Hi > > OSQL is used to communicate with Microsoft SQL Server, no Microsoft > Access. > > Regards > -------------------------------- > Mike Epprecht, Microsoft SQL Server MVP > Zurich, Switzerland > > IM: mike@epprecht.net > > MVP Program: http://www.microsoft.com/mvp > > Blog: http://www.msmvps.com/epprecht/ > > "Addcom" <albert.addo@oxinst.co.uk> wrote in message > news:u82DQmpZFHA.3840@tk2msftngp13.phx.gbl... >> am trying to update an access file table contents using osql and am >> getting all sort of error >> Can anyone help >> This is the querry >> osql -U aaa -D MyLocalConfig -P synprof97 -Q "update System set >> LocalConfigPath = 'C:\DBase\Test\Config' where Ref = >> '{B2244A43-CAF7-11D0-8DD6-0000C07E4B0E}'" >> I get the following errors, using the same query on SQL db is okay >> [ODBC Driver Manager] Driver's SQLSetConnectAttr failed >> [ODBC Driver Manager] Driver's SQLSetConnectAttr failed >> [ODBC Microsoft Access Driver]Invalid connection string attribute APP >> [ODBC Microsoft Access Driver]Invalid connection string attribute WSID >> [ODBC Microsoft Access Driver]Invalid connection string attribute APP >> [ODBC Microsoft Access Driver]Invalid connection string attribute WSID >> [ODBC Microsoft Access Driver]Invalid connection string attribute APP >> [ODBC Microsoft Access Driver]Invalid connection string attribute WSID >> [ODBC Microsoft Access Driver]Invalid connection string attribute APP >> [ODBC Microsoft Access Driver]Invalid connection string attribute WSID >> [ODBC Microsoft Access Driver]Optional feature not implemented >> >> > > |
|
02-27-2008, 08:46 PM
| ||||
| ||||
| Re: using osql to update access db at command line i was looking for something that would do the same thing. i found this on sourceforge which should do the trick: http://sourceforge.net/projects/oledbcmd/ *** Sent via Developersdex http://www.developersdex.com *** |
Linear Mode
