SQL Anywhere Feedback - DBINIT command line option for password to dba user

Author

DBINIT command line option for password to dba user

vsv

2005-12-07, 8:24 pm

DBINIT command line option for password to dba user.
Helpful especially if the dba pwd is case sensitive & if i use unload/reload
option.
Thanks
vsv

Breck Carter [TeamSybase]

2005-12-07, 8:24 pm

Some kind of SQL procedure should be provided as part of the MobiLink
consolidated setup to let MobiLink scripts send text to the MobiLink
server diagnostic log. Debugging complex MobiLink scripts on Oracle,
for example, is a nightmare.

Especially when the order of MobiLink events is changed (:

Breck

On 7 Dec 2005 14:31:26 -0800, "vsv" <nospam@nospam.com> wrote:

>DBINIT command line option for password to dba user.
>Helpful especially if the dba pwd is case sensitive & if i use unload/reload
>option.
>Thanks
>vsv
>

--
SQL Anywhere Studio 9 Developer's Guide
Buy the book: http://www.amazon.com/exec/obidos/A...7/risingroad-20
bcarter@risingroad.com
RisingRoad SQL Anywhere and MobiLink Professional Services
www.risingroad.com

Jason Hinsperger $iAnywhere$

2005-12-08, 1:23 pm

Breck, I think you posted this as a reponse, but meant it as a separate
topic.

--Jason

"Breck Carter [TeamSybase]" < NOSPAM__bcarter@risi
ngroad.com> wrote in
message news:3loep1988vbr4q4
g71bke3av90rocdfk0c@
4ax.com...
> Some kind of SQL procedure should be provided as part of the MobiLink
> consolidated setup to let MobiLink scripts send text to the MobiLink
> server diagnostic log. Debugging complex MobiLink scripts on Oracle,
> for example, is a nightmare.
>
> Especially when the order of MobiLink events is changed (:
>
> Breck
>
>
> On 7 Dec 2005 14:31:26 -0800, "vsv" <nospam@nospam.com> wrote:
>
>
> --
> SQL Anywhere Studio 9 Developer's Guide
> Buy the book:
> http://www.amazon.com/exec/obidos/A...7/risingroad-20
> bcarter@risingroad.com
> RisingRoad SQL Anywhere and MobiLink Professional Services
> www.risingroad.com

vsv

2005-12-08, 1:23 pm

thanks Jason, I didn't get it until I read yours.
vsv

"Jason Hinsperger (iAnywhere)" < NOjason_hinspergerSP
AM@hotmail.com> wrote in
message news:4398716e$1@foru
ms-1-dub...
> Breck, I think you posted this as a reponse, but meant it as a separate
> topic.
>
> --Jason
>
>
> "Breck Carter [TeamSybase]" < NOSPAM__bcarter@risi
ngroad.com> wrote in
> message news:3loep1988vbr4q4
g71bke3av90rocdfk0c@
4ax.com...
>
>

Greg Fenton

2005-12-12, 3:23 am

vsv wrote:
> DBINIT command line option for password to dba user.
> Helpful especially if the dba pwd is case sensitive & if i use unload/reload
> option.

Though I don't disagree that this could be a useful feature, you can do
this from the command line today:

$ dbinit foo.db
$ dbisql -c " uid=DBA;pwd=SQL;dbf=
foo.db" grant connect to DBA
identified by 'MyNewPassword'

greg.fenton
--
Greg Fenton
Consultant, Solution Services, iAnywhere Solutions
--------
Visit the iAnywhere Solutions Developer Community
Whitepapers, TechDocs, Downloads
http://www.ianywhere.com/developer/

Daigo Moriwaki

2005-12-14, 8:24 pm

Greg Fenton wrote:[color=darkred
]
> vsv wrote:

I like that option because I want to increase the file size at dbinit.

$ dbinit -p 4096 --file-size 400MB --password 'newdbapwd' test.db

Everything is done!

Thanks,
Daigo

--
Daigo Moriwaki
iAnywhere Solutions K.K. [Tokyo]
daigo.moriwaki at ianywhere dot com

Sponsored Links