Re: Create table by batch file/command line?

From: hackian@my-deja.com > >In article <8a8t90$co$1@news.xmission.com>, > "Obnoxio The Clown" <obnoxio@hotmail.com> wrote: > > > > From: hackian@my-deja.com > > > > > >I am trying to understand how to automate the > > >creation of a table from an NT command line using > > >a batch file. I also need to do this for stored > > >procedures. > > > > > >I looked at DBAccess but that seems to act like a > > >utility that does not take any arguements? I > > >know I need to specify the database and give user > > >information. I have a .sql file that I created > > >by saving the table. > > > > > >I was trying for something like... > > > > > >DBACESS TABLE mytable.sql > > > > > >I am missing connection information. > > > > Good to know, thank you. > > > > Have you tried: dbaccess databasename yourscript.sql ? > >Yes, I get Connection a permission error: > >387: No Connect Permission >111: ISAM: No record found Jeez, well it does help us when you tell us what the problem actually *is*: GRANT CONNECT TO username;______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com