| Author |
using osql to update access db at command line
|
|
| Addcom 2005-06-01, 7:23 am |
| 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\Confi
g' 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
| |
| Mike Epprecht \(SQL MVP\) 2005-06-01, 8:23 pm |
| 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\Confi
g' 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
>
>
| |
| Addcom 2005-06-01, 8:23 pm |
| 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...
>
>
| |
|
|
|
|