csv - VBScript Error 80040E14 Syntax error in FROM clause -

-

i'm trying use script found on internet allow bulk creation of new user accounts in active directory using vbscript , csv file. i'm not using csvde b/c script create passwords. keep encountering error when running code cannot figure out. can help?

'********************************************************************* ' script: createusersfromcsv.vbs                                     * ' creates new user accounts in active directory csv file.     * ' input: csv file layout logonname,firstname,lastname,password  * '                                                                    * '*********************************************************************  option explicit  dim scsvfilelocation dim scsvfile dim oconnection dim orecordset dim onewuser  ' variables needed ldap connection dim orootldap dim ocontainer  ' holding variables information import csv file dim slogon dim sfirstname dim slastname dim sdisplayname dim spassword dim npwdlastset dim nuseraccountcontrol ' used enable account dim sdomain dim scompany dim sphone dim semail dim sdescription  dim numchar, count, strrdm, intrdm dim fso, f, fso1, f1  '* modify match company's ad domain sdomain="mydomain.local"  '* input file location scsvfilelocation = "c:\documents , settings\administrator\desktop\" 'keep trailing slash!  '* full path input file scsvfile = scsvfilelocation&"newusers.csv"  ' commands used open csv file , select of records set oconnection = createobject("adodb.connection") set orecordset = createobject("adodb.recordset") oconnection.open "provider=microsoft.jet.oledb.4.0;data source= " & _ scsvfilelocation & ";extended properties=""text;hdr=no;fmt=delimited""" orecordset.open "select * " & scsvfile ,oconnection  ' create connection active directory ou container. set orootldap = getobject("ldap://rootdse") set ocontainer = getobject("ldap://ou=test," & _ orootldap.get("defaultnamingcontext"))   on error resume next   until orecordset.eof ' reads values (cells) in sinputfile file.       ' --------- start creating user account    ' read variable information csv file    ' , build needed create account    slogon = orecordset.fields.item(0).value    sfirstname = orecordset.fields.item(1).value    slastname = orecordset.fields.item(2).value    sdisplayname = sfirstname&" "&slastname    spassword = orecordset.fields.item(3).value     ' build user account set onewuser = ocontainer.create("user","cn="&sfirstname&" "&slastname) onewuser.put "samaccountname",lcase(slogon) onewuser.put "givenname",sfirstname onewuser.put "sn",slastname onewuser.put "userprincipalname",lcase(slogon)&"@"&sdomain onewuser.put "displayname",sdisplayname onewuser.put "name",lcase(slogon)  ' write information active directory can ' modify password , enable user account onewuser.setinfo  ' change users password onewuser.setpassword spassword onewuser.put "pwdlastset", 0  ' enable user account onewuser.put "useraccountcontrol", 512 onewuser.setinfo   objfile.close  '******************* orecordset.movenext loop '******************* ' used debugging 'if err.number = -2147019886 ' msgbox "user logon " & slogon & "already exists" 'end if ' --------- end of user account creation

here error occuring, line 51 char 1:

orecordset.open "select * " & scsvfile ,oconnection

maybe scsvfile contains special characters , therefore must escaped this:

orecordset.open "select * [" & scsvfile & "]", oconnection

i hope helps.


Comments

Post a Comment

Popular posts from this blog

Cursor error with postgresql, pgpool and php -

-
hey, struggling bit determine exact cause of error has been popping in our release environment. there not seem dealing particular error on google. this error message getting: sqlstate[34000]: invalid cursor name: 7 error: portal "" not exist the error pops when using pdo prepared statements. this setup our release environment: pgpool 3.0.1 (the postgresql backend in streaming replication mode!) php 5.3.5 postgresql 9.0 edit: architecture 64bit. the same error not manifest in our test environment (edit: forgot mention, standard test environment uses postgresql 9.0 without pgpool). thus, led suspect pgpool @ least partly suspect. does know probable causes error are? edit: ok, here example of kind of code causes error. $sql = 'select * '; $sql .= 'from "mytable" "mystuff" '; $sql .= 'where "mytable"."status" = 1 '; $sql .= 'and "mytable"."mytableid" = :table...
Read more

delphi - ESC/P programming! -

-
why need use because printers using tprinter prints weird hieroglyph @ beginning of printable area. my problem if send commands, nothing happens. esc e (#27 #69) - sending escape sequence didn't work expected. removed first letter , rest of string made bold. eg. hello -> ello . after changed esc e esc (#27 #69 #27), worked fine. example managed figure out, but... trying select character table "esc t n" (#27 #116 n), make "õäöü" work. command doesn't work. nothing happens! , command supported esc/p, esc/p 2 , 9-pin esc/p, should work fine. manual can found here . if has ever needed use esc/p commands maybe 1 can shed light how work them! thanks in advance! edit: in previous post asked more or less same question though answers how did send commands printer. (i'll change question there according answers!) i accepted ken's answer, because claimed way transferred commands wasn't best , got work escape command. problem after t...
Read more

c++ - error: use of deleted function -

-
i've been working on c++ code friend has written , following error have never seen before when compiling gcc4.6: error: use of deleted function ‘gamefsm_<std::array<c, 2ul> >::hdealt::hdealt()’ implicitly deleted because default definition ill-formed: uninitialized non-static const member ‘const h_t floppokergamefsm_<std::array<c, 2ul> >::hdealt::h’ edit: comes part of code using boost msm: boost webpage edit2: there no = delete() used anywhere in sourcecode. generally speaking, error mean? should looking when type of error occurs? i don't think other answers mentioning =deleted; syntax correct. error message says default constructor has been deleted implicitly . says why: class contains non-static, const variable, not initialized default ctor. class x { const int x; }; since x::x const , must initialized -- default ctor wouldn't initialize (because it's pod type). therefore, default ctor, need define 1 (and must ...
Read more